Skip to Content
0
Jul 22, 2020 at 09:52 AM

Connect Transport/Outbound Delivery Order/Warehouse Order

97 Views

Dear community,

i am pretty new to creating querries in SAP so this might be a very basic mistake i can't figure out. :) I am trying to create a query which connects the SD-Transports with the Outbound Delivery Order and the Warehouse Order.

I've already tried several approaches but it always ended with way to many results.

My goal is to create a list that shows the Warehouse Orders grouped by Outbound Delivery Order grouped by the Transport the Deliveries belong to. I want to export that to excel and then create some barcodes of the Warehouse Order Numbers so my colleagues in the Warehouse can work with it.

I imagine it to look something like this

Transport || Outbound Delivery || Warehouse Task

1000 || 80000001 || 1000003610

1000 || 80000001 || 1000003611

1000 || 80000002 || 1000003612

With these Data i want create some barcodes representing the Warehouse Task Number in Excel

I've already found a couple of tables but something ist missing. I tried a couple of joints with varying results.

When i join the /scdl/sb_proch_o and the /scdl/sb_proci_o the results are fine. When i join /scwm/who and /scwm/ordim_o ther results are as expected. Once i connect these four tables together to get all the information in one query i get way to many results. I have no idea how to fix that.

This is the join i've came up with that gives me way to many results. I hope someone can help me with this problem.

Thank you in advance.

With best regards

Tobias

Attachments

edush.png (26.7 kB)