Reservation vs Stock Transport Order

[former_member774347]

Dears,

I am runing reports to work on the open reservations and noticed that some of the reservations of this king have their stock transport order delivery completed indicator ticked meaning that the parts were already satisfied.

Do you guys know t-codes to run reports so I can make relationship between reservation and stock transport order or reservation and work order?

Both should list not only the reservation/work order/stock transport order but also their respective line items. This way I can concatenate both arguments to create a unique key.

I tried t-code ZSE16 table EKPO but this does not provide the tracking number (work order) line item.

System :G3P

Regards,

António Cardoso

[former_member751591]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with Community Q&A , 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)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line.

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial Q&A tutorial

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.

[Oscar_DC]

Can you elaborate on your business process a little more? You said you are running reports on reservations . I'm assuming you're going to the RESB tables or you're running MB25.

How do you create the relationship between reservation and transport order? Are you running MRP and creating requisitions that get turned into orders?

If you're running MRP, I don't think that you'll find a one to one relationship between reservation and transport order if you're running MRP. I think this would be the equivalent for looking for a relationship between a Purchase Order or purchase requisition and a material reservation. There's no relationship between them !

Many things can trigger the creation of a requisition or planned order : It can be unplanned demand, it can be that multiple reservations cause the available quantity to drop below your reorder point, or someone modified the MRP data, etc.

[BijayKumarBarik]

For reservation and order refer table RESB