OPEN DATASET

[Former Member]

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 ?

[Former Member]

Gui_download is used for download data to presentation server.

while open dataset is using for application server downloading.

Amit.

[Former Member]

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

[bpawanchand]

HI

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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