Which table could let me check sales order type when giving dlv order info

[Former Member]

Hi,

Suppose you got the delivery order detail like delivery number#,dlv type...etc...

From which table link could we find the corresponding sales order type???

Is there any table indicate the document flow, and with that then i could find the sales order type for this dlv order???

Thank you very much!!

[Shiva_Ram · Accepted solution]

Hi,

You can directly connect tables LIKP and VBAK to find the details in the ABAP query.

Hope this helps

[Former Member · Accepted solution]

Hi Ram,

Could kindly indicate which field could link LIKP and VBAK directly..Thank you very much...

Maybe below way is not the fast way...

1) Get sales order number with dlv# by checking document flow table VBFA.

2) Get Sales order type by checking tbl VBAK with sales order number.

[Former Member]

ok

[Lakshmipathi]

Dear Hoo Laa

If you want to see the document flow, you have to run SE16 with table VBFA.

If you want to link sale order type, sale order reference with delivery, then you have to run SQVI and table join VBAK and LIPS where you can select the fields VGBEL for sale order reference and AUART for sale order type

thanks

G. Lakshmipathi