Query Help

Hello,

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.

• WOR1
  • ItemCode
• OITM
  • ItemName
• WOR1
  • PlannedQty
  • IssuedQty
• OITW
  • OnHand
  • IsCommitted
  • OnOrder
• OWOR
  • OriginNum
  • Status (released/planned only)
  • DocNum
    • and if possible the OITM - ItemName

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!