in which table we can find status of production order.
JEST, JCDS, TJ02
Hope the above answers your query.
If I understood the query in the right way, you can use COOIS only to get the status of Production Order.
Use TJ02 and JEST here you can find all the intarnal statuses related production order.
First go to CAUFV table input the production order get the object number
Input this object number in JEST table and get the system status
Input the system status in TJ02T table ,u will get the production order status
Very helpful...thank you.