Report on Shipment

[Former Member]

Hi Gurus,

Is there a query or transaction where I can extract a list all shipments made to customer during 2008 and 2007 by product and country/market.

For report with the following fields:

Product number, product description, quantity, shipment date, customer number (ship to), market/country (to which the customer belong).

Kindly comment so as to give me a clue to what tables to use to create a query.

Thanks

Bawa

[Manoj_Mahajan78]

Hi..

Below are some of Shipment reports-

1)VT11

2)VT12

3)VT16

4)VT20

If you want more reports you can try SE16 & PUT tables VTTK,VTTP,VFKK,VFKP

Regds

MM

[Former Member]

Dear Bawa,

I don't know, how useful would these reports be:

VT11, VT12, VT16 & VT20

If not, then you may also check/ develop your query with:

VTTP - Shipment header

VTTK - Shipment detail

Along with Delivery Details:

Table: LIKP/LIPS

Hope, this information may help you, some extent.

Very Best Regards,

Amit

Note: Reference -

[Tables and Structures|https://www.sdn.sap.com/irj/scn/wiki?path=/display/erplo/sd%252brelated%252btables%252band%252bstructures]