URGENT: Extraction of APO SDP Database Alerts

[Former Member]

Hi,

I have to extract the APO SNP databse alerts (SDP). can anyone please let me how to extrct them. any standard datasources ? any tables i can get the details from.

does the standard infosource 0ICH_ALERT_MON &

datasource 0ICH_ALERT_REPORT_DS can be used for extracting these alerts ?

regards

Bhavani Prasad

[Former Member]

Hello Bhavani,

You can use the below sample code for extracting alerts or as somanth said u can fetch it from /sapapo/amalert table.

Regards,

Siva.

DATA : l_plver TYPE /sapapo/amoplver,

l_vfrom TYPE /sapapo/c_vfrom,

l_vto TYPE /sapapo/c_vto,

lt_amoappl_profid TYPE /sapapo/amoappl_profid_tab,

ls_profid LIKE LINE OF lt_amoappl_profid,

l_alert_manager TYPE REF TO /sapapo/alert_manager.

DATA gt_alert_tab TYPE /sapapo/alert_tab.

• Assgin the version, from and to date

l_plver = '000'.

l_vfrom = '19700101000020'.

l_vto = '20371231235949'.

• Assgin the profile id's

ls_profid-applid = 'SD'.

ls_profid-profid = 'PN_SNP_ALERT'.

APPEND ls_profid TO lt_amoappl_profid.

CREATE OBJECT l_alert_manager.

REFRESH gt_alert_tab.

• read the alerts from the data base

CALL METHOD l_alert_manager->read_alerts

EXPORTING

plver = l_plver

vfrom = l_vfrom

vto = l_vto

t_appl_profid = lt_amoappl_profid

pllp_switch = 'X'

IMPORTING

t_alerts = gt_alert_tab

EXCEPTIONS

profile_not_found = 1.

IF sy-subrc = 1.

RAISE profile_not_found.

ENDIF.

[Former Member]

Hi Somanth & Sivaprakash,

Thank you very much for the replies and the information did helped me. I have already found the /SAPAPO/AM_ALERT. but the challenge i was facing is, in the table /SAPAPO/AM_ALERT there are objects ID's which i have to match them for APO Product & APO Location. i have cross looked into MATKEY, LOCMAP, MATLOC tables and i could not find corresponding entries in them. so i was not able to identify Product & Location..

can you please let me know a away to find them. May be a function module ?

Thank you & appreciate the help very much

Best regards

Bhavani Prasad

Message was edited by:

Bhavani Prasad

[Former Member]

Hi Bhavani!!

Did you solve the issue? I've got the same request!!

I see the alerts and the date in which generated on the /sapapo/am_alert, but I can not find the MATID or the LOCID (I need to identify the product and the location)!!

Can anybody help me??

Thanks a lot!!

Maria

[somnath_manna]

Hi Bhavani,

SDP Database Alerts are stored in database table /SAPAPO/AM_ALERT. You should be able to extract relevant alert information from this table.

I am not sure about the infosource and datasource mentioned by you - but they seem to be for the ICH application.

Thanks,

Somnath