Uploading XL file using call Transaction and running in back ground

[Former Member]

Hi all,

I am updating the T-code VA01 using call TRansaction method ....

i am uploading the file is XL file for that i m using the FM ALSM_EXCEL_TO_INTERNAL_TABLE.

But if execute my program in the back ground This FM is giving Dump because it can not Execute in Back GRound...

Plz let me know any FM to upload data from Excel file Both from foreground and back ground....

Plz let me know ASAP..

Thanks,

Suresh

[Former Member]

HI...,,

When u run any program in Background, it will not have any contacts with the presentation server.... You cannot upload a presentation server file..

But u can use the Application server file...

SO first store this excel file's data in Application server using the transaction CG3Z and then use the Open data set and read dataset to upload the application server file !!!

reward all helpful answers !!

regards,

sai ramesh

[Former Member]

hi ,

can you give any sample code how to do .. plz its really help full to me ....

Thanks,

Suresh

[Former Member]

Hi

U should convert that file in CSV format and move it to Server SAP path, so change your program in order to use the statament OPEN DATASET (to the file), READ DATASET (to the record) and CLOSE DATASET (to close the file) instead of that fm.

Max

[Former Member]

Hi suresh,

Visit the following link.

Change the program for an upload by doing the same for ws_upload.

http://www.sap-img.com/abap/download-in-background-in-excel-format.htm

Hope this helps!

*Reward if useful

regards,

Naveenan.