SAP Notification Status has a complex status schema, this step by step tutorial will explain you how to read SAP Notification Status.
In the first part, it will explain the SAP Notification Status Tables and the second part will provide sample and function module to read Notification status in SAP.
Table of Contents
The main SAP Tables for Notifications are QMEL, JSTO and JEST.
QMEL is the SAP Master Data Table for Notification.
Check this post for the SAP PM Main?Tables or this post for SAP QM Maint Tables.
As key, fill the QMEL-QMNUM for the Notification Number.
You have to retrieve Object Number for Status Management?corresponding to?QMEL-OBJNR.
The OBJNR number will look like, depending of your customizing, to [QM+Notification No]
Using the previous QMEL-OBJNR as JSTO-OBJNR, retrieve the Status Profile ( JSTO-STSMA ).
The reference table for STSMA is the TJ20 ( Status Profiles ).
The SAP Standard Table for Status is JEST.
Use the QMEL-OBJNR as JEST-OBJNR to retrieve the list of SAP Notification Status.
If you want to read only active status, make sure you filter by JEST-INACT = ‘ ‘.
The SAP Notification Status will be in JEST-STAT.
For SAP Notifications Status , we have
Once you get the Status and the Status Profile, you can get the descriptions / texts for the SAP Notification Status from the TJ30T using:
The Text for Status can be found in TJ30T-TXT30 field and it is language-dependent.
Remember that TJ30 is the reference table for User Status.
As for SAP Notification User Status, the System Status description can be retrieved from TJ20T with :
TJ20T-STMSA = JSTO-STSMA
TJ20T-STAT ? ? = JSTO-STAT
Without getting your hand dirty with coding, SAP offers some functions to read SAP Notification Status.
Next is two function to help you get the work done
STATUS_CHECK is the standard function to check if a Status is Active or not.
The input is the OBJNR and the STATUS of any object.
The Ouput will be an exception:
ALM_ME_ML_NOTIF_STATUS will help you retrieve all User status details for a single Notification.
The input is the
The Output of this function module will give you the User status in details with texts.
Read more about?Status Management in Notifications
SAP ISU Tables for Technical master data, for Billing Master Data, Billing and invoicing Tables?…
SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd…
Dunning is the business practice of informing a customer of past due payment. Dunning letters…
SAP AP Tcodes & SAP AR Tcodes: House Banks Tcodes, Advance Payments or Down Payments,…
What are the main SAP Payment Terms Tables ? What are the related Tables in…
Work center consists of master data related to routing of products. It contains data related…