A query to display sales orders with corresponding outbound deliveries

[Former Member]

Hi Experts,

Don't know if this is the right place to post the question but i would like to know if a query, in SAP, can display sales orders with their corresponding outbound deliveries, i tried using table LIKP and VBAK, VBKD didn't help. the whole idea is to enter any specified sales order number and the query will return any outbound deliveries belong to the sales order.

Thanks in advance!

[csaba_szommer · Accepted solution]

Hi Simon,

Please try to use tables VBAP-LIPS-LIKP. (left outer joint type). Please take care which field to use when you connect the tables (check the given link)!!!

http://www.erpgenie.com/abap/tables_sd.htm

BR

Csaba

[Former Member]

Hi Simon,

You can try directly in table VBFA because this contains both the sales order and the delivery in one record. You dont need to make a query.

Regards

Nikhlesh