10-09-2007 10:42 AM
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
10-09-2007 10:45 AM
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.
10-09-2007 10:45 AM
VTTP has the field VBELN which corresponds with the key field VBELN for LIKP and LIPS.
10-09-2007 10:49 AM
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.
04-11-2012 4:45 AM
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)
04-11-2012 6:19 AM
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