Skip to Content
Former Member
Jun 06, 2014 at 03:27 PM

Query Help



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!