topic Re: OPEN DATASET in Application Development and Automation Discussions

OPEN DATASET

Former Member — Mon, 07 Jul 2008 13:17:04 GMT

What is the difference between downloading data using GUI_Download and using Open dataset ?

What exactly needs to be done to download data from sap tables and store it on an application server ?

Re: OPEN DATASET

Former Member — Mon, 07 Jul 2008 13:18:31 GMT

Gui_download is used for download data to presentation server.

while open dataset is using for application server downloading.

Amit.

Re: OPEN DATASET

Former Member — Mon, 07 Jul 2008 13:20:00 GMT

Hi,

Check this links:

http://help.sap.com/saphelp_erp2005/helpdata/en/79/c554a3b3dc11d5993800508b6b8b11/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/EN/fc/eb3ca6358411d1829f0000e829fbfe/content.htm

http://help.sap.com/saphelp_40b/helpdata/ru/34/55cad198482bc0e10000009b38f91f/content.htm

Regards

Adil

Edited by: Syed Abdul Adil on Jul 7, 2008 3:22 PM

Re: OPEN DATASET

bpawanchand — Mon, 07 Jul 2008 13:22:01 GMT

GUI_DOWNLOAD is a FM which downloads the data to the presentation server.But when it comes to OPEN DATA SET you are trying to open a file which is stored on the application server.

to store the data od SAP tables of the application server all you have to do is read the data into a internal table and use OPEN DATA SET statement to open a file on application server and use TRANSFER statement to store the contents of the internal table data to teh file created on application server and CLOSE DATASET

Regards

Pavan

Edited by: Pavan Bhamidipati on Jul 7, 2008 3:22 PM

Re: OPEN DATASET

Former Member — Mon, 07 Jul 2008 13:22:48 GMT

Open dataset is to get the data from Application Server to SAP. and GUI_DOWNLOAD is to download the data from SAP to Presentation server.

Re: OPEN DATASET

Former Member — Mon, 07 Jul 2008 13:27:42 GMT

Hi Shreya,

GUI_DOWNLOAD - this is used to download data from a table into a file in the presentation server.

OPEN DATASET - This is used to download or upload from a table into a file in the application server.

Hope this helps you.

Regards,

Chandra Sekhar

Re: OPEN DATASET

Former Member — Mon, 07 Jul 2008 13:29:23 GMT

hi....

gui_upload is used to upload the file from local pc whereas open dataset is used to upload or download the file on the application server.

thats the main difference.

Re: OPEN DATASET

Former Member — Mon, 07 Jul 2008 13:36:48 GMT

Hello,

data: itab type table of mara with header line.

select * from mara into itab where matnr in s_matnr.

OPEN DATASET p_ofile FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

loop at itab.

transfer itab.

endloop.

close dataset.

Here we are sending data to application server with the file name p_ofile. U can see the file in AL11.

Regards,

Subbu