cancel
Showing results for 
Search instead for 
Did you mean: 

Tables and Function modules to build a report using SRT_MONI interface data for sending mail alert

11-25-2024 7:50 PM
sankar1781 Participant
2720 views 1 comments
0 Likes
SAP Managed Tags
Labels
'abap'SRT_MONIWeb ServicesWebServiceUtilities
Subscribe

Hi Experts,

My requirement is to send an alert (send an email notification) to business users if the interface ended with error status (including all type of errors) available in SRT_MONI. 

The PI (CPI) response back to SAP system was successful and the webservice data has ended into an error due to incorrect data or the data doesn't exist in the SAP system (DB). For example: Company code or Sales organization doesn't exist.

Therefore, business needs notification for these error result interface data along with the Payload data /the original XML file.

To achieve this, we planned to build a report program to list out all the error resulted interface data as an output which are sent as an email notification to the business users (along with the XML file/payload data) information. 

To build the report program, we have the data stored in the table SRT_MMASTER. Using this data we need to fetch or get the Payload information and the XML file details so we can convert into xstring and send it as an attachment file. 

Please share the associated tables and the Function modules to fetch the above required data. 

If you have any other possible solution to send an alert for the above requirement, please let me know and that would be highly appreciated. 

Note:

SXMB_GET_MESSAGE_PAYLOAD  (No result when provided Message ID from the table SRT_MMASTER)

SXMB_GET_MESSAGE_LIST (No result when provided Message ID from the table SRT_MMASTER)

SRT_MONI_GET_CALL_DETAIL (codes are commented and of no use)

Thank you.

0 Likes

Accepted Solutions (0)

Answers (0)