Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

relation beteween delivery and shipping tables

Former Member
0 Kudos

hi to all abap gurus

my querry is

what is the relation beteween delivery and shipping tables . ans\d common fileds for delivary and shiiping tables ?

ie relation bwteen likp , lips and vttk , vtto

thanks in advance points wil be rewarded for good ansers

5 REPLIES 5

Former Member
0 Kudos

The link between delivery and shipping tables is Delivery Number ( VBELN )

Theere are two type sof Shipment with type 9001 and 9002 .

After Delivery is created ,It has to be shipped so Shipment is created based on delivery(VT01 ) where you give options of dates and shipping type and condition and types of leg .

Please reward if useful.

Former Member
0 Kudos

VTTP has the field VBELN which corresponds with the key field VBELN for LIKP and LIPS.

Former Member
0 Kudos

hi,

likp is delivery header data. and lips is its detail table,

common fields are vbeln - delivery no.

this no. is unique identifier of delivery.

vttk is shipment header table and vttp is its detail.

common field is tknum i.e shipment no which is unique.

Former Member
0 Kudos

hi,

Relationship between the delivery and shipping table is

vttp(shipment item) in this table field VBELN-(delivery) is linked with the table LIKP-(Sales document delivery header) has the similar field  VBELN-(delivery)

jack_graus2
Active Contributor
0 Kudos

Delivery header data is in table LIKP.
Delivery item data is in table LIPS.

Shipment header data is in table VTTK.
Shipment delivery data is in table VTTP.
Shipment stage data is in table VTTS.

The link from delivery to shipment is table VBFA with VBELV = the delivery number and VBTYP_N = 8. Shipment number is in VBFA-VBELN.
The link from shipment to delivery is table VTTP with TKNUM = the shipment numer. Delivery number(s) are in VTTP-VBELN.

Regards Jack