Quantity shipped total

[Former Member]

Hi all,

I need a table where I can get the total quantity shipped in a month of a certain part number.

Can someone help me please?

Thank you very much in advance.

Andreas

[Former Member · Accepted solution]

Hi Andreas,

Check table <b>VTTP</b>(Shipment Item). Get the deliveries from this table and get the quanties of material number from <b>LIPS table</b>.

Thanks,

Vinay

[Former Member]

Table: LIPS based on Material.

Standard SAP SD Reports:=

Statistic Group:

Purpose – To capture data for Standard Reports, we require to activate Statistic Group as under:

--> Item category (Configuration)

--> Sales document type (Configuration)

--> Customer (Maintain in Master data)

--> Material (Maintain in Master data)

When you generate statistics in the logistics information system, the system uses the combination of specified statistics groups to determine the appropriate update sequence. The update sequence in turn determines for exactly which fields the statistics are generated.

Configuration:

IMG --> Logistics Information System (LIS) --> Logistics Data Warehouse --> Updating --> Updating Control --> Settings: Sales --> Statistics Groups -->

1. Maintain Statistics Groups for Customers

2. Maintain Statistics Groups for Material

3. Maintain Statistics Groups for Sales Documents

4. Assign Statistics Groups for Each Sales Document Type

5. Assign Statistics Groups for each Sales Document Item Type .....

All Standard Reports which are available are as under:

SAP Easy Access: Information Systems -> Logistics -> Sales and distribution ->

1. Customer -> Incoming orders / Returns / Sales / Credit memos / Sales activities / Customer master / Conditions / Credit Master Sheet

2. Material -> Incoming orders / Returns / Sales / Credit memos / Material master / ...

3. Sales organization -> Sales organization / Sales office / Sales employee

4. Shipping point -> Deliveries / Returns

5. SD documents -> Orders / Deliveries / Billing documents ...

& so on.

Sales summary - VC/2

Material Analysis(SIS) - MCTC

Material Analysis- Invoiced Sales - MC+Q

Regards,

Rajesh Banka

Reward points if helpful.

[Former Member]

Hi Andreas,

Why dont you use Delivery Document Header (LIKP) and Item (LIPS) tables amd join them.

Regards

Nadarajah Pratheb