Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

create dataset

Former Member
0 Kudos
1,217

Hello folks,

I have a quick question:

I need to create a dataset file and save it on my desktop. Then read data from a table and store it in my dataset file.

How can I do this?

Please advise and rewards will be given appropriately.

Ol.

7 REPLIES 7

former_member194669
Active Contributor
0 Kudos
165

Hi,

Use fm GUI_UPLOAD and GUI_DOWNLOAD.

Search this forum with key word "GUI_UPLOAD and GUI_DOWNLOAD" for sample code.

aRs

Former Member
0 Kudos
165

Hi,

You can create the DATASETS in the Appliaction server only, we can not create the datasets in the Presentation server(Desktop), you can create the files in the Presentation server, but every time it will be over write you can not add the data, but in the Application server you can update the data with the latest data, or you can add the records to the fiel which is already existed

Regards

Sudheer

Former Member
0 Kudos
165

Hi,

For storing data to your desktop you can use GUI_DOWNLOAD.

You can read data from database and store it in internal table. Pass the internal table to the function module. Specify the path where you want to download.

This will download to your desktop.

Reward if helpful.

former_member235056
Active Contributor
0 Kudos
165

Hi,

Basic form

READ DATASET dsn INTO f.

Addition

... LENGTH len

Effect

Reads a record from the sequential file specified in dsn (a field or a literal) and stores it in the field f (usually a field string).

Binary mode (addition IN BINARY MODE in the OPEN DATASET statement:

Read from file in length of field f .

Text mode (addition IN TEXT MODE in the OPEN statement):

Read a line.

If the specified file is not open, READ DATASET attempts to open the file dsn ( IN BINARY MODE FOR INPUT or with the specifications of the last OPEN command for this file). Any errors result in the termination of the program.

To read all the records in a file, you are recommended to place READ DATASET in a DO loop that you leave with EXIT .

The return code value is set as follows:

SY-SUBRC = 0 Record read from file.

SY_SUBRC = 4 End of file reached.

Example

Define the field string REC :

DATA: BEGIN OF REC,

TEXT(30),

NUMBER TYPE I,

END OF REC.

Read the file "/usr/test":

DO.

READ DATASET '/usr/test' INTO REC.

IF SY-SUBRC <> 0.

EXIT.

ENDIF.

WRITE: / REC-TEXT, REC-NUMBER.

ENDDO.

Notes

You can use TRANSFER to output records to a sequential dataset.

The format of file names depends largely on the operating system. You can access portable programs by using the function module FILE_GET_NAME which returns the physical name for a given logical file name.

Addition

... LENGTH len

Effect

Stores the length of the record read from the file in the field len .

Pls reward all helpful points.

Regards,

Ameet

Former Member
0 Kudos
165

use the FM gui_download to get the data into your presentation server from the application server and gui_upload for vice-versa.

go to www.se37.com for the documentation regarding any FM.

regards,

srinivas

<b>*reward for useful answers*</b>

Former Member
0 Kudos
165