Schedule a SAP Query

To create the SAP Query, go to SQ01. 
Use SQ02 to create a program name for your query (Menu Query-> More Functions -> Display Report Name)
To schedule the SQP Query (use program name from previous step), use SM36 or SM36WIZ (WIZ – wizard where the conditions can be defined).
Output of the scheduled job can also be sent via email, Goto Exec. In Target, there is a recipient list button next to that in SM36, user name can be provided there.

As a alternate approach, you could also create a report that produces the same result as a query and this can be scheduled

Leave a Reply

Your email address will not be published. Required fields are marked *