Connect Transport/Outbound Delivery Order/Warehouse Order

[former_member1340061]

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

[lenastodal]

Hi Tobias,

Thank you for visiting SAP Community to get answers to your questions. I am here to help you to get the most out of it.

First of all, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't done so already), as it provides tips for preparing questions that draw responses from our members.
For example you:
- can outline what steps you took to find answers (and why they weren't helpful)
- can share screenshots of what you've seen/done
- can use a descriptive subject line

As I can see, you already phrased your question pretty detailed, which is brilliant.

Please also make sure you're using all appropriate tags, so the right experts can find your question. Overall, the more details you provide, the more likely it is that members will be able to assist you. Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question - but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Best regards,
Lena (SAP Community Moderator)