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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[csaba_szommer]

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

[Former Member]

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

[former_member217082]

Hi frank

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

Regards

Srinath

[Former Member]

Hi

you can check VBELV field in LIPS table.