Where is QM notification "status" stored in the database?

[Former Member]

I would like to see the value of status. In which database table is stored?

Thank you very much.

[Former Member · Accepted solution]

Table JCDS holds the status codes and TJ02T contains the text for the

status code.

When reading the JCDS table, object id for notifications will be QM +

notification number. Be sure to sort your results by udate and utime to

find the latest status for the order because this table contains all

status' ever applied to the order.

Also

Status are stored in table JEST. Connection is found by field OBJNR which is in QM case simply QM and the notification number. But in QMEL you should find field OBJNR. From JEST you can go further in TJ30 for user status or in TJ02 for system status

[former_member534662]

You can use FM 'AIP9_STATUS_READ'. Here you can get both

1) System Status for notification

2) User status

Logic: Pass OBJNR of QMEL ( Quality Notification ) to above FM

[Private_Member_230497]

Hello,

those two function modules maybe helpful:

STATUS_TEXT_EDIT

STATUS_TEXT_EDIT_LONG

Best regards,

Veit