Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Open Production order report against project code?

Hi Friends

I need a report open production orders against project .

Regards

Reddy

replied

Hi,

Please try this query,

SELECT T0.[DocNum], T0.[Status], T0.[Type], T0.[Project], T1.[ItemCode], T0.[PlannedQty], T0.[CmpltQty], T0.[Project] FROM OWOR T0  INNER JOIN WOR1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T0.[Status] IN ('P','R')

Thanks

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question