Scheduling Queries in Batch Mode

The transaction RSCRM_BAPI can be used to create queries for your BW system. The result is stored either in a table or a file. Use AE to make queries either regularly or upon request.

In the first step, log on to the BW system and call the transaction RSCRM_BAPI. ScheduleStartet in periodischen Abständen aktivierbare Objekte. Auch ein eigener Objekttyp in der Automation Engine. the query to be automated with AE once. Each query has its own batch ID. Open the batch monitor and copy this number.

Now create a SAP job in your AE system. Use the Form tab or write the following function directly into the Process tab:

R3_ACTIVATE_REPORT REP='RSCRMREPORT_BAPI'

Now change to the SAP tab and enter the copied BatchID in the field JobVerarbeitung auf einem Zielsystem. Auch ein eigener Objekttyp in der Automation Engine. name.

This Job object can now be integrated in your processing (e.g. in a Schedule object) and will process the query at the point in time you define.

It is a SAP peculiarity that the batch monitor does not display all query executions but only the last one.