topic download data onto presentation server in Application Development and Automation Discussions

download data onto presentation server

Former Member — Thu, 29 May 2008 09:08:57 GMT

Hello experts,

I am trying to download data onto presentation server(shared folder) from internal table. Also this report need to be run in background mode. so download should be done in background.

i tried to download using function module. but it didnt work.

is there any way to download internal table data in background mode onto shared folder???

any sample code???

Re: download data onto presentation server

Former Member — Thu, 29 May 2008 09:12:30 GMT

use:

open dataset...

chk these 2 links:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/9831750a-0801-0010-1d9e-f8c64efb2bd2

/people/monalisa.biswal/blog/2007/06/28/download-in-background

regards,

madhu

Re: download data onto presentation server

Former Member — Thu, 29 May 2008 09:12:53 GMT

Hi !

What are you trying to do ?

Fill an internal table from a file, or use an internal table to create a file on the server ?

Re: download data onto presentation server

Former Member — Thu, 29 May 2008 09:15:23 GMT

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/9831750a-0801-0010-1d9e-f8c64efb2bd2

/people/monalisa.biswal/blog/2007/06/28/download-in-background

http://sapabap.iespana.es/sap/info/rfcexec/rfcexec_e.htm

Re: download data onto presentation server

Former Member — Thu, 29 May 2008 09:16:40 GMT

the data populated in the internal table.

i am trying to download the internal table data into the file on shared folder.

i think file will be created dynamically.

Re: download data onto presentation server

vinod_vemuru2 — Thu, 29 May 2008 09:17:11 GMT

Hi Saurab,

Best way is to download the data to application server using OPEN DATASET, TRANSFER and CLOSE DATASET commands and then use CG3Y transaction to download to local PC.

Function modules will not work in back ground mode.

There is one way sugested in SDN by some one in foreground mode also. But this needs setting to be done in SAP and Local PC.

Thanks,

Vinod.

Re: download data onto presentation server

Former Member — Thu, 29 May 2008 09:21:00 GMT

You can loop on the internal table and execute for each line of it a write dataset statement (see the help for "open dataset" and "write dataset").

Regards,

Eric.

Re: download data onto presentation server

Former Member — Thu, 29 May 2008 09:24:50 GMT

thanks for reply.

any sample code on open dataset???

i tried this one also but nothing is downloaded...not even file get created.

Re: download data onto presentation server

Former Member — Thu, 29 May 2008 09:29:43 GMT

Check out the sample code.

MOVE : 'Sr. No.' TO IT_EXCEL_LAYOUT-SLNO ,

'Veh Regn No.' TO IT_EXCEL_LAYOUT-HERST ,

'Notfn No.' TO IT_EXCEL_LAYOUT-QMNUM ,

'Notfn Dt' TO IT_EXCEL_LAYOUT-QERDAT ,

'Serv Ord No.' TO IT_EXCEL_LAYOUT-AUFNR ,

APPEND IT_EXCEL_LAYOUT.

**********<Records to be transported>

LOOP AT ifinal.

MOVE: ifinal-SLNO TO IT_EXCEL_LAYOUT-SLNO ,

ifinal-HERST TO IT_EXCEL_LAYOUT-HERST ,

ifinal-QMNUM TO IT_EXCEL_LAYOUT-QMNUM ,

ifinal-QERDAT TO IT_EXCEL_LAYOUT-QERDAT ,

ifinal-AUFNR TO IT_EXCEL_LAYOUT-AUFNR ,

APPEND IT_EXCEL_LAYOUT.

ENDLOOP.

*******

DATA:BEGIN OF IT_EXCEL OCCURS 0,

FLD(1023),

END OF IT_EXCEL.

LOOP AT IT_EXCEL_LAYOUT.

CONCATENATE: IT_EXCEL_LAYOUT-SLNO ','

IT_EXCEL_LAYOUT-HERST ','

IT_EXCEL_LAYOUT-QMNUM ','

IT_EXCEL_LAYOUT-QERDAT ','

IT_EXCEL_LAYOUT-AUFNR ','

INTO IT_EXCEL-FLD.

APPEND IT_EXCEL.

ENDLOOP.

DATA:w_filename LIKE CFFILE-FILENAME.

CONCATENATE '<filename> '.csv' INTO w_filename.

OPEN DATASET w_filename FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

IF SY-SUBRC = 0.

LOOP AT IT_EXCEL.

TRANSFER IT_EXCEL TO w_filename.

ENDLOOP.

ENDIF.

CLOSE DATASET w_filename.

Regards,

swarup