Export data to Excel through a ABAP program run in batch mode
The requirement is that a ABAP report should run through background job, which will do the followiing :
1) Collect data from predifined CRM tables ( Activity , Order for example ).
2) Create a Excel file in a Application Server ( physical file server location ) location.
3) Push the data collected in the step 1 to the Excel file.
I have found 2 function modules which does the export to Excel after creating the Excel file. They are :
But it seems that the ABAP report needs to run in the foreground ( correct me if i am wrong ) in order to create the Excel file.
Please can anyone suggest a possible ABAP code to achieve OR how to use these FMs in background mode ?
The excel creation needs to be automated and send to a administrator email id every day, so the need of exporting the data in background mode arises.
Thanks and regards,