Extract SDP alert data

[Former Member]

Hi,

Does anyone know how to pull DP alert data from the system? I know there is a table /sapapo/am_alert but it does not have characteristic information. I searched online someone recommend using function module /sapapo/ampllp_sdp_alerts. But I am not sure it will give me all the characteristic shown in alert monitor. Any advise is appreciated.

Thanks,

Rick

[satish_waghmare3 · Accepted solution]

Hi Rick

Based on my experience Selection table (S Table) which usually has name like /1APO/S**000**. To find the S table name in your system,  you can access table /SAPAPO/TSAREATE, for your planning area, you can find in the field SELTAB the name of the table containing the single selections, it starts with '/1APO/S'.

This is a selection table and gets created for individual planning area in system.  Read the selection id which has flag "A" (Alert Monitor)  This is the table from which gets the details of Agg levels/selections for which alert is generated.

Besides you can try these SE38 programs to access selection from that table -  /SAPAPO/MCPSH_GEN_SELTAB_SE16 and /SAPAPO/MCPSH_GEN_SELTAB_MGM

Additionally please spend some time on this program /SAPAPO/AMODAL_DELETE to find out where it is reading data related to database alerts. This will help you find out table names other than /SAPAPO/AM_ALERT.

Please do share details upon finding the solution

Thank you

Satish Waghmare

[Former Member · Accepted solution]

Thanks Satish! Your information is very helpful.