SDP Alerts extracts

Hi Experts,

I have to extract the APO SNP database alerts from table "/SAPAPO/AM_ALERT", the table shows object ID details and not material & location details.

I have verified the tables MATKEY, LOCMAP, MATLOC but no luck.

Can you please help in identifying the relation for mapping between object ID with Material & location combination and extraction of data base alerts from table /SAPAPO/AM_AlERT

Thanks in advance.

Regards

Ashwin