Relationship table of Sales Order (VA03) and Delivery Order (VL03N)

[Former Member]

Hi everyone!

What table can I see the relationship of Sales Order document (VA03) and Delivery Order document (VL03N) as shown in VA03 > Environment > Document Flow?

I mean, what tables saves the partnerships of each document (query sales order no. and get equivalent delivery order no. or nos.)

Thank you very much!

[Former Member]

VBAK and VBAP for Sales Order and LIKP and LIPS for Delivery Order

Hope it helps!

Jen

[Former Member]

Hello,

these relationships are stored in table VBFA (Sales Document Flow) .

Just try the function module SD_VBFA_SELECT with your sales order number.

Rgeards

Wolfgang

[Former Member]

Thank you all!

[Former Member]

Hi

U can use the fm RV_ORDER_FLOW_INFORMATION in order to get out those links or you can read the item table LIPS:

LIPS-VGBEL = sales order number

LIPS-VGPOS = salese order item

Max

[Former Member]

Hi

Relationship table of Sales Order (VA03) and Delivery Order (VL03N) is VBFA.

Nikunj Shah

[Former Member]

CHeck the table.

VBFA - Sales Document Flow