Skip to Content
author's profile photo Former Member
Former Member

relation beteween delivery and shipping tables

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

Add comment
10|10000 characters needed characters exceeded

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 09, 2007 at 09: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.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 09, 2007 at 09:45 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 09, 2007 at 09: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.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 11, 2012 at 03: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)

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 11, 2012 at 05: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

    Add comment
    10|10000 characters needed characters exceeded