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. ScheduleDémarre des objets activables à intervalles périodiques. Egalement un type d'objet distinct dans l'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 JobTraitement sur un système cible. Egalement un type d'objet distinct dans l'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.