PM Notification Status

[Former Member]

I have an MII application which displays PM type M1 Notifications. The notifications have been approved or rejected on SAP. I need to be able to detect and display the status of a notification but the information is not returned in the notification detail. Does anyone know how I can get the notification status through MII? I am using MII version 12.1, Netweaver CE 7.1 EHP1 and SAP ECC 6.0.

I am using RFC "RFC_READ_TABLE" with table VIQMEL to return the list of notifications within a given time period and then RFC "BAPI_ALM_NOTIF_GET_DETAIL" to return the detail for each one.

[Former Member · Accepted solution]

Hi Richard,

hope you are doing well. The table VIQMELST have the STAT (Key which informs you of the current status of an object, like I0072). In the table TJ02T you will find the clear description to the each

STAT as Description. Take a look on it and let me know.

BR and Regards to UK.

Pedro Iglesias

[Former Member · Accepted solution]

Hi Pedro

Many thanks for your reply. This does indeed give me the system status and I can see the values from the table. However a notification has two status values, the second being the user status, and it is this status which is used to reject the notification. The system status (STAT) value seems to remain the same whether a notification is unapproved or rejected. I had a look on VIQMELST but I cannot see an obvious user status field. Any idea where this is held and how I can access it?

Best Regards

Richard.

[Former Member · Accepted solution]

Hi Richard,

OK so you are looking for USTAT. From your VIQMEL take the column OBJNR. Query the table JCDS

with the condition OBJNR from the VIQMEL. The result are a list with USTAT and STAT. To get the

description of the USTAT you can use the table TJ30T. Hope this will help you.

Let me know.

BR

Pedro Iglesias

[Former Member · Accepted solution]

Hi Pedro

Many thanks. On my test environment I can now get the JCDS info using OBJNR and can use the STAT field contents to look up TXT04 short status description on TJ30T. However, this returns multiple entries. There appears to be another key called STSMA, which has an identifier to indicate which type of status it is. The ones which seem appropriate are PMNOT001 and PMNOT002. Do you know which of these I should be using (since they both contain the value 'REJ')? The only remaining thing then is to find out the authorization I need to read JCDS and TJ30T. Do you know how I can find that?

BR

Richard.

[Former Member · Accepted solution]

Hi Richard,

the table JSTO will return you the STSMA back. Please provide as criterion the OBJNR.

BR.

Pedro Iglesias

[Former Member · Accepted solution]

Hi Pedro,

Many thanks again. I now have an MII transaction which returns the User status for each Notification. I am currently reading this under my test user, which has access to all RFC calls but in Production I must request the correct authorization for reading these tables. I currently have a role which has Activity "Display" and Authorization Group "&NC&, CA". Do you know how I find the authorization for reading these 3 additional tables or should I raise that as a separate question?

BR

Richard.

[agentry_src · Accepted solution]

Hi Richard,

Once you complete the topic for the original question, you should award points, close the current thread and open a new one for the next topic.  I would recommend that you include the link to the previous thread for review purposes.  And thanks for asking the question so I could provide direction for others who might read this thread. 

Regards, Mike (the moderator).

[Former Member]

Hi,

you can try FM:   AIP9_STATUS_READ