cancel
Showing results for 
Search instead for 
Did you mean: 

Scheduling automatic excel exports from Solman

0 Kudos

At 8am daily, I run a saved search for RFC's on Solman and click on the little 'export to excel' button. My goal is to automate this.

With the automation, the downloaded excel sheet should be ready every morning. Is there a way to accomplish this?

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

richard_pietsch
Active Contributor
0 Kudos

Hi,
I would try creating a Z-report, which executes the saved search (guess it should work using CL_CRM_BOL_DQUERY_SERVICE, e.g. method LOAD_QUERY_TEMPLATE) and that creates a file you store in a path or send via email. Keep your processing options (name/id of saved search, email receiver etc) as report variant and schedule this report to run daily.
Regards, Richard