• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

WIP - Open Work Orders per Workcenter/ Sequence

cekay90

Member
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!
 

Larry_Jones

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.
 
Top