Knowledge Base > Automation Engine and Target Systems > SAP > Scheduling Queries in Batch Mode

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. Schedule 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 Job 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.