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 :

a) XXL_FULL_API

b) MS_EXCEL_OLE_STANDARD_DAT

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,

Sudipta

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