Procedure to extract data from SAPAPO/AM_ALERT

[Former Member]

Hi,

I need to extract DB alerts and report on them.I know that they are stored in the database table SAPAPO/AM_ALERT. What is the procedure to extract this information to APO-BW?

Thanks.

[Former Member · Accepted solution]

Hi Raj,

You can follow the below steps for creating the generic extractor in APO .

1) In Source System, go to SE11 and create a table, then go to RSO2 to create datasource.

2) Specify the name of the datasource in the field of RSO2 and hit Create.

3) Give the Application component and description.

4) In View/Table field field specify the Ztable name.

5) Then click Save.

6) It will take you to the extract structure screen.

7) If you want to hide/select any of the field you can do that here, otherwise press enter.

😎 Change the package of the datasource and specify the transport request number to it.

9) Test the extractor in RSA3.

Regards,

Siva.

[Former Member]

Can some body help me please?

Is creation of generic extractors possible in APO? I can create a generic extractor giving table as reference. But I am not sure if I can do it in APO.

Thanks.