Last Confirmed Operation.
What table and field can I use to find the last confirmed operation for a production order?
Production order: 1001
1. Commission (Status CNF)
2. Drilling (Status CNF)
3. Milling (Status REL PRT)
4. Package (Status REL PRT)
Now, I want to pull a report that shows me the order number and Drilling as the last confirmed operation. Or even better if it shows me order number and the next operation in the sequence.
My goal is to find the last operations confirmed for a list of orders. COOIS gives me list of all operations and shows me the status, and I am not looking for this. I do not want to see all operations.
Your help will me greatly appreciated!