topic Re: problem in using 'EXCEL_OLE_STANDARD_DAT' in Application Development and Automation Discussions

problem in using 'EXCEL_OLE_STANDARD_DAT'

Former Member — Mon, 25 Jun 2007 14:33:17 GMT

I was told that since, we want to run the report on the job scheduler in the background, we can't use this function 'EXCEL_OLE_STANDARD_DAT' ,because it'll run on the presentation layer. Is there any other function module which does the same function

plz help urgent.......

Re: problem in using 'EXCEL_OLE_STANDARD_DAT'

RichHeilman — Mon, 25 Jun 2007 14:36:40 GMT

You will need to write your file to the application server layer if running in the background. No other function module which uses the frontend will help.

Regards,

Rich Heilman

Re: problem in using 'EXCEL_OLE_STANDARD_DAT'

Former Member — Mon, 25 Jun 2007 14:43:48 GMT

Use Below Syntax to download at UNIX Layer

Download internal table to Application server file(Unix)

DATA: e_file like rlgrap-filename value '/usr/sap/tmp/file.txt'.

open dataset e_file for output in text mode.

lOOP AT it_datatab......

transfer it_datatab to e_file.

ENDLOOP.

close dataset e_file.

Thanks

Seshu