Destination and departure country for 'Delivery in shipment'

[Former Member]

Hi,

I have a reporting that requires field from this structure VTRLP (Delivery in Shipment: item)

Therefore, I need to know the source of that this structure is getting from.

Below are the fields that I need:

1) LAND1 - destination country

2) ORT01 - destination city

3) ALAND - departure country

4) VSTEL - shipping point

5) VGBEL - reference order number

6) BRGEW - gross weight

I found that LIPS table contains has VBGEL and BRGEW fields, LIKP has VSTEL. I m not so sure whether I can used it or not.

I have no idea where are the sources for these 3 fields:

1) LAND1 - destination country

2) ORT01 - destination city

3) ALAND - departure country

Appreciate some advice. Thanks.

[Former Member · Accepted solution]

Hello,

LAND1, ORT01, Yo can get it from the ship to party customer.

Goto the Delivery document number and get the KUNNR and pick the ADRNR number from the LIKP and then goto ADRC table , there you can find the LAND1, ORT01

Departure country you can find it from the PLANT table T001W

Here also the same process, goto T001W and fetch the ADRNR and hen from ADRC you can find the DEPARTURE COUNTRY.

cheers,

[Former Member]

Hi,

May be you can try with table VTTS, it contains data from shipment - stages tab - departure point and destination.

Regds

Ravi

[Former Member]

Hi Ravi,

I found this table VTTS contains most the data that I need but it only has shipping number.

I need for each delivery in the shipment, display shipping point, destination country, destination city, order number, etc.

here is the sample report layout:

Shipment no. 1     Delivery shipping pont 1/ destination 1     order no. 1
                   Delivery shipping pont 2/ destination 2     order no. 2
Shipment no. 2     Delivery shipping pont 3/ destination 3     order no. 3
                   Delivery shipping pont 4/ destination 4     order no. 4

Thanks.

[Former Member]

Hi,

For, Shipment N.o - Table VTTKD ; Field TKNUM_TMP

Shipping Point - Table VTTS_ALL

Order N.o - Table LIPS

This is what I understand out of the requirement, if there is anything more to it please let us know.

Rgds

Ravi

[Former Member]

hello,

the departure country is from the shipping point data.

other things explained by santosh are correct.

rgs,

AK