Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Export data to Excel through a ABAP program run in batch mode

Dear Experts,

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,


Former Member
Not what you were looking for? View more on this topic or Ask a question