Skip to Content
avatar image
Former Member

SD-How to find table of link between delivery and sales order?

Hi Experts,

I have a requirement as below.

In LIPS table (SD document: Delivery: Item data), in this table has one kind data.

One record has maintianed 2 fields PSPNR(Project definition (internal)) and PS_PSP_PNR(Work Breakdown Structure Element (WBS Element)).

How to find sales order number of the above record? Could you tell me which table link the delivery item data and sales order number?

Thanks a lot,

Frank

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Dec 19, 2008 at 10:03 AM

    Hi

    you can check VBELV field in LIPS table.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 19, 2008 at 02:03 PM

    Hi frank

    Check the following tables VBAP , VAPMA , VBUP . It may help you

    Regards

    Srinath

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 28, 2009 at 08:28 AM

    Hi Frank, if i understood your question correctly u want sales order no. refering to that delivery . if that is it then it will be available in LIPS table field LIPS-VGBEL.

    Think answers your question.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 28, 2009 at 12:41 PM

    hi ,

    to find the link between delivery and sales order.

    PLease go through the table:

    1.VAPMA

    2.VBAP

    3. VBUP

    hope this will be helpful

    Regards

    Tapeshwar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 28, 2009 at 08:21 PM

    If you give the delivery no. in VBFA-VBELN and the item no. of delivery in VBFA-POSNN you shoul get the sales order no. in VBFA-VBELV (VBFA-VBTYP="C").

    (table VBFA stores information on sales document flow)

    Regards,

    Csaba

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 28, 2009 at 08:57 PM

    You can find sales order & item reference in delivery from LIPS-VGBEL & LIPS-VGPOS

    Add comment
    10|10000 characters needed characters exceeded