I am currently trying to set up a query for our purchasing & manufacturing department to show committed parts released & planned orders. So far I have located all my tables & fields I would like to pull from but i am unsure if it is even possible.
I am trying to pull most of my information from the production order (OWOR & WOR1) then connect to sales order (ORDR) & Item Master (OITW/OITM)
I have been using the wizard due to the fact that i am inexperienced with queries, the following is what i have entered but SAP shuts down. Also i have not defined any table relations.
Basically i want any child item in a released or planned production order with stock & SO details
Am i shooting for the stars???
Thank you in advance for any help!