Demystifying User Statuses in SAP PP: A Look Behind the Scenes

In the complex world of SAP Production Planning (PP), tracking production order progress requires a multifaceted approach. System statuses provide a core layer of information, but user statuses add another dimension of control and customization. But where is this user status information stored? There isn’t a single dedicated “User Status Table” in SAP PP.

Let’s delve into how user statuses function and the tables involved in accessing them:

Understanding User Statuses

User statuses allow authorized personnel to assign custom statuses to production orders beyond the standard system statuses. This enables functionalities like:

• Flagging priority orders
• Indicating production hold-ups
• Marking specific processing stages

These statuses are defined within a Status Profile (accessed through customizing transaction OPJH) and linked to the production order via the object number (OBJNR) in table AUFK.

Finding the User Status:

Here’s where it gets interesting: user statuses aren’t directly stored in a single table. To retrieve them, you’ll need to navigate a chain of tables:

1. AUFK: Enter the production order number (AUFNR) and retrieve the corresponding object number (OBJNR).
2. JEST: With the OBJNR from AUFK, look up the production order data in JEST. Here, the “STAT” field holds the key. Statuses starting with “I” denote system statuses, while those beginning with “E” indicate user statuses.
3. JCDS: Finally, use the user status code (from JEST) in the JCDS table. This table stores details about user status changes, including the user who set the status, the date and time of change, and the transaction code used (e.g., CO02 for change order).

Additional Insights:

• JCDS can return multiple entries for a single production order if the user status is changed numerous times. Sorting by the “CHGNR” field (change number) in descending order and filtering out duplicates will give you the most recent status change information.
• To understand the meaning of the user status code, refer to table TJ30T. This table links user status codes to their descriptions based on the status profile used.

Conclusion

While there’s no single “User Status Table” in SAP PP, understanding the interplay between AUFK, JEST, and JCDS empowers you to unlock the world of user statuses. This information provides valuable insights into production order progress and helps you identify bottlenecks or areas requiring attention.