on 01-29-2015 2:31 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I solved following Satish suggestion.
Running program /SAPAPO/MCPSH_GEN_SELTAB_SE16 I found the table for "translating" the field OBJECT_ID3 of /SAPAPO/AM_ALERT. It is a table for selections (SE16 => /1APO/S340000273 in our system) and it records the selection of the alert stored on /SAPAPO/AM_ALERT.
Thank to Satish!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rick,
You will get overall alert profile details in table /sapapo/amsg_prf against the user id , once you have SETID with you, pass it to function module /SAPAPO/AMON_ALERTS_BY_PSET,which will give you Alert Details in pt_alerts importing table in internal format.You need to convert the internal format into external format which we can see in AMON1 by assigning dynamic structure specific to AOT and AT_ID.
You can refer standard program /SAPAPO/AMON_MAIL_BROADCAST to check logic.
Let me know if you come across any issues.
Regards,
Saurabh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
For the benefits of the others consultants, please indicate the good or the helpful answer!
Thanks, Marius
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rick,
Did you try Set Sending of Alerts t.code /SAPAPO/AMONMSG?
Thanks, Marius
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.