topic Sample Program using Data Set in Application Development and Automation Discussions

Sample Program using Data Set

Former Member — Wed, 24 Sep 2008 05:10:21 GMT

Hi All,

currently I am working for Data Migration, and i need to copy my flat file to Application Server.

How to write a program to do this using Data Sets..

Regards,

Anil.

Re: Sample Program using Data Set

bpawanchand — Wed, 24 Sep 2008 05:14:09 GMT

OPEN DATASET p_file FOR INPUT IN TEXT MODE ENCODING DEFAULT.
  DO.
    READ DATASET p_file INTO wa_account.
    IF sy-subrc <> 0.
      EXIT.
    ELSE.
      APPEND wa_account TO t_account.
    ENDIF.                             " If sy-subrc <> 0.
  ENDDO.                               " DO
  CLOSE DATASET p_file.

OPEN DATASET p_file FOR INPUT---> this line is for reading the data set

OPEN DATASET p_file FOR OUTPUT --> this is to write data to the data set

instead of READ you need to use TRANSFER statement to write the data to the data set after opening the file in OUPTUT mode.

after transferring the data CLOSE the DATASET.

to upload the data from flat file use GUI_UPLOAD FM pass the table

Regards

Pavan

Re: Sample Program using Data Set

GauthamV — Wed, 24 Sep 2008 05:15:18 GMT

hi,

before asking basic questions search in SCN u will get lot of posts.

u can use CG3Y,CG3Z transactions to upload and download files to application server.

or u can use open dataset,closed dataset concept.

Re: Sample Program using Data Set

Former Member — Wed, 24 Sep 2008 05:15:45 GMT

What about F1 on read Data set??SAP says somthing or completely dumb?