topic Re: Regarding Dataset in Application Development and Automation Discussions

Regarding Dataset

Former Member — Thu, 14 Feb 2008 15:23:55 GMT

HI..

I want sample code on Dataset.

Requirement : I uploaded one excel file into internaltable using FM "ALSM_EXCEL_TO_INTERNAL_TABLE.

Now I want to upload this internal table into Application Server file.

After that I want to get back that data into internal table from Application server file.

How can I do It using DataSet.

Please send me code for my requiremnt and for General Dataset also.

Regards

Sandeep.

Re: Regarding Dataset

Former Member — Thu, 14 Feb 2008 15:32:52 GMT

Try This

DAta : gv_dataset1 TYPE char100.

Note : p_file is the filename.

  gv_dataset1 = p_file.
    OPEN DATASET gv_dataset1 FOR INPUT IN TEXT MODE ENCODING DEFAULT.
    IF sy-subrc NE 0.
*         MESSAGE
    ELSE.
      WHILE ( sy-subrc EQ 0 ).
        READ DATASET gv_dataset1 INTO wa_itab.
        IF NOT wa_itab IS INITIAL.
          APPEND wa_itab TO itab.
        ENDIF.
        CLEAR wa_itab.
      ENDWHILE.
    ENDIF.
    CLOSE DATASET gv_dataset1.