topic Re: Uploading excel file in SAP from background processing in Application Development and Automation Discussions

Uploading excel file in SAP from background processing

Former Member — Thu, 07 Jul 2011 09:43:11 GMT

Dear All

I have a large excel file to be uploaded in SAP. I would like to know if there is any FM that can read this FM in background and then take it for further processing.

As of now I came across all the FM that processes excel only in foreground.

Issue that I am facing is that because of huge size of this excel, there are memory dump. Which I want to avoid.

So could you suggest some ways.

Amol

Re: Uploading excel file in SAP from background processing

Former Member — Thu, 07 Jul 2011 09:46:16 GMT

Hi,

how about:

exporting in excel to csv format and uploading this file onto the application server. Change the coding of the given report to "open dataset, read dataset, ..."

Kind Regards,

Dirk

Re: Uploading excel file in SAP from background processing

former_member201275 — Thu, 07 Jul 2011 14:52:02 GMT

here is answer u r looking for:

Re: Uploading excel file in SAP from background processing

sjeevan — Sat, 09 Jul 2011 03:34:56 GMT

Can you try writing the program for foreground like normally you do and set up a background job to execute your program by saving the variant of the program with the path of the file in it?

The sample code for front end excel upload is here

http://www.sap-img.com/abap/upload-direct-excel.htm