Issue with conversion of Solix format data.

[former_member198937]

Hi Friends,

I am facing an issue of conversion of data from solix fromat to binary format.

I have read the data from .XLS file into the solix format with the gui_upload.

Now i want to transfer this data into internal table so that I can process on it .

DATA: lt_data_tab TYPE TABLE OF solix.

CALL METHOD
          cl_gui_frontend_services=>gui_upload
          EXPORTING
            filename                   = v_filename_string
            filetype                     = 'BIN'
            has_field_separator     = space
            read_by_line            = 'X'
            dat_mode                = 'X'
          CHANGING
            data_tab                 = lt_data_tab.

Now I want the data into interal table  lt_data_tab[ ] and below is the format for the same .

TYPES : BEGIN OF ty_refno,
                refno  TYPE char16,     
                key    TYPE string,
                END OF ty_refno.

data : lt_data_tab TYPE STANDARD TABLE OF ty_refno.

Is there is any function fm which can convert the same .

Regards,

[Former Member]

Hi,

why are you using    cl_gui_frontend_services=>gui_upload to import XLS file in internal table?

You shoul use function  ALSM_EXCEL_TO_INTERNAL_TABLE.

regards

Fred

[former_member198937]

Uploading of file is not restricted to .XLS .I am trying to upload any file and I am storing it in format table SOLIX.

Can some guide how to convert the SOLIX date into the actual one.