topic Re: Fetch Shipment data in Application Development and Automation Discussions

Fetch Shipment data

Former Member — Thu, 14 Jun 2007 12:43:15 GMT

Hello Friends

I need to fetch the following Shipment data, based on shipment # and Shipment end date.

Shipment#, Customer#, Shipment End Date, Carrier, Shito-City, Shipto-Zip, Shipto-Country, Pallet#, Total WT, UOM, Total Volume, UOM

I have got most of them. Just help in getting these 3

1.Pallet #

2.TOTAL WT

3.TOTAL Volume.

Thanks.

Re: Fetch Shipment data

Former Member — Thu, 14 Jun 2007 12:45:00 GMT

Use the Tables <b>VTTK and VTTP</b> for getting this data

see the VTTK fields for

ALLOWED_TWGT -- Allowed total weight of shipment

DTMEV -Volume Unit

DTMEG -Weight Unit

Pallet number and Volume may be the material number and volume which you have to fetch from thr Delivery tables LIPS and LIKP using the VTTP-VBELN field

Reward points for useful Answers

Regards

Anji

Message was edited by:

Anji Reddy Vangala

Re: Fetch Shipment data

Former Member — Thu, 14 Jun 2007 12:50:20 GMT

Hi Anji

Could you please tell me where is volume and weight in VTTK and VTTP.

Thanks

Re: Fetch Shipment data

Former Member — Thu, 14 Jun 2007 12:53:37 GMT

Take it from the LIPS table

Pass the VTTP-VBELN to LIPS (there is a chance that more than 1 item may be there)

so you have to take all the items LIPS-VOLUM and VOLEH fields and to add them for all items for a single shipment

And also Pallent no will be material no

If needed take the weight also from LIKP/LIPS tables

Reward points for useful Answers

Regards

Anji