Open Production order report against project code?

[former_member275969]

Hi Friends

I need a report open production orders against project .

Regards

Reddy

[former_member1022930]

you can use ZLP10 report

you only need plant number and run the program.

[kothandaraman_nagarajan · Accepted solution]

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