In your Business Warehouse (BW) system, you can create query extracts by using the RSCRM_BAPI transaction. The result of such a query is either stored in a table or in a file. Your AE system allows you to schedule your queries regularly or upon request.
Procedure
- Log on to your BW system and call the RSCRM_BAPI transaction. Select the query that you want to automate with your AE system, and set it to be scheduled once. Open the batch monitor and copy the unique batch ID of your query.
- Create an SAP job. Use the Form view or write the following function directly to the Process page of this job:
- You can now integrate your Job object in your automatic processing, for example, by using a Schedule object. The Schedule object then processes your query at the point in time that you define. For details, see Schedules (JSCH).
R3_ACTIVATE_REPORT REP='RSCRMREPORT_BAPI'
Switch to the SAP page and enter the batch ID that you have copied in the Job Name field. For details, see SAP ABAP, Java and PI.
Note: SAP behavior has the batch monitor display only the last query execution.
See also: