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