WIP - Open Work Orders per Workcenter/ Sequence


Hello everybody!
For the Shop Floor Control context, how would you determine the amount of open work orders per workcenter (Business Unit)?
I am working on a SQL to get a daily report. For now I would guess I would check in F4801 for orders where status <90 and then reference to F31122Z1 where the order actually is.
Do you have any suggestion?
I found a report nr (R31802) but I can't work with that. I just have a SQL connection.

I am grateful for every help!


Legendary Poster
Table F3112 has the Routing Operations for a WO.
Whether or not you can determine if a Operation is complete depends on the business processes / setup in your organization.