Link between Sales order and PO

[Former Member]

Hi,

I cannot find the link between SD tables and MM so that I can find from sales orders the related purchse orders

Can You help me ?

Best regards

[Lakshmipathi · Accepted solution]

If the process is STO and you want to track the PO reference from SD side, then check the following:-

1) LIPS - VGBEL

2) VBRP - AUBEL

thanks

G. Lakshmipathi

[Former Member · Accepted solution]

HI,

WE can use the table VBKD (SALES DOCUMENT: BUSINESS DATA )

1. VBELN - Sales order

2. BSTKD - Customer Purchase order

we can link these two fields and can pass the data in a internal table after that Vbeln is also present in

Tables VBAP ( SALE DOCUMENT ITEM DATA )

1. VBELN - SALE ORDER

2. MATNR - MATERIAL NUMBER

3. KWMENG - ORDER QUANTITY

which could be used for further procssing

Thanks

Rajat

[RBM]

Hi,

Check the VBFA table (Document flow), here you could find the PO related.

Hope this helps!

Regards!