User Status Table in SAP PP


User Status Table in SAP PP

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.


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.

You can find more information about SAP  PP  in this  SAP PP Link



Unogeeks is the No.1 IT Training Institute for SAP  PP Training. Anyone Disagree? Please drop in a comment

You can check out our other latest blogs on  SAP  PP here – SAP PP Blogs

You can check out our Best In Class SAP PP Details here – SAP PP Training

 Follow & Connect with us:


For Training inquiries:

Call/Whatsapp: +91 73960 33555

Mail us at:

Our Website ➜

Follow us:






Leave a Reply

Your email address will not be published. Required fields are marked *