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 an SAP job. Use the Form view or write the following function directly into the Process tab:
R3_ACTIVATE_REPORT REP='RSCRMREPORT_BAPI'
Now change to the SAP page and enter the copied BatchID in the Job Name field. For more information, see SAP ABAP, Java and PI.
This Job object can now be integrated in your processing (e.g. in Schedules (JSCH)) and will process the query at the point in time you define.
Note: It is an SAP peculiarity that the batch monitor does not display all query executions but only the last one.
See also: