on 05-30-2016 3:54 PM
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
Hi Ashwin,
the alerts are saved in //AM_ALERT with reference to its selection (ID). Normally it's a generated selection ID which decrypts the alert ID and provides you the filled characteristics. Usually only the characteristics are filled dependent on the aggregation level which has been maintained at batch job level.
Please scan your system for a table with the following name //S00*. Each MPOS has it's own selection table.
regards Peter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
4 | |
3 | |
2 | |
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.