Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Excel Upload in SRM System

Dear Experts,

                     Am trying to upload excel file(xls) in SRM system using below code but am getting data in Chinese format don't know how to convert into normal format and i used other format like .CSV(Comma del..) but in this am getting data but getting with special characters like (, #) , please help me to upload excel file(xls format) file to internal table.

CALL METHOD CL_GUI_FRONTEND_SERVICES=>GUI_UPLOAD

     EXPORTING

       FILENAME                = L_FHEAD01

       FILETYPE                = 'ASC'

*     HAS_FIELD_SEPARATOR     = '|'

*     HEADER_LENGTH           = 0

*     READ_BY_LINE            = 'X'

       DAT_MODE                = 'X' "SPACE

*     CODEPAGE                = SPACE

*     IGNORE_CERR             = ABAP_TRUE

       REPLACEMENT             = '#'

*     VIRUS_SCAN_PROFILE      =

*  IMPORTING

*     FILELENGTH              =

*     HEADER                  =

     CHANGING

       DATA_TAB                = LT_TRAN

*     ISSCANPERFORMED         = SPACE

     EXCEPTIONS

       FILE_OPEN_ERROR         = 1

       FILE_READ_ERROR         = 2

       NO_BATCH                = 3

       GUI_REFUSE_FILETRANSFER = 4

       INVALID_TYPE            = 5

Former Member
Not what you were looking for? View more on this topic or Ask a question