Skip to Content

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

problem with GUI_UPLOAD

Hey Folks,

I need to convert the excel data into inernal table

types : begin of ty_data,

matnr type matnr,

exbwr type exbwr,

text type c,

end of ty_data.

This is my excel file.

6249 10 prabhas

6249 56 Dude

6249 57 Rockstar

6249 80 Babu

6249 90 Bhaiyya

6249 250 Munna

6249 35 Rocky

6249 75 Hero

6249 789 Prankster

-


data : filename type string.

filename = p_file.

call function 'GUI_UPLOAD'

exporting

filename = filename

FILETYPE = 'ASC'

  • HAS_FIELD_SEPARATOR = ' '

  • HEADER_LENGTH = 0

  • READ_BY_LINE = 'X'

  • DAT_MODE = ' '

  • IMPORTING

  • FILELENGTH =

  • HEADER =

tables

data_tab = it_data

  • EXCEPTIONS

  • FILE_OPEN_ERROR = 1

  • FILE_READ_ERROR = 2

  • NO_BATCH = 3

  • GUI_REFUSE_FILETRANSFER = 4

  • INVALID_TYPE = 5

  • NO_AUTHORITY = 6

  • UNKNOWN_ERROR = 7

  • BAD_DATA_FORMAT = 8

  • HEADER_NOT_ALLOWED = 9

  • SEPARATOR_NOT_ALLOWED = 10

  • HEADER_TOO_LONG = 11

  • UNKNOWN_DP_ERROR = 12

  • ACCESS_DENIED = 13

  • DP_OUT_OF_MEMORY = 14

  • DISK_FULL = 15

  • DP_TIMEOUT = 16

  • OTHERS = 17

.

if sy-subrc <> 0.

  • MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

  • WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

endif.

when I m using this FM i m getting the error as Bad_DATA_FORMAT i have also checked the FM ALSM_EXCEL_INTERNAL_TABLE but both seems not to be working in my case. Can somebody tell me where its gong wrong.

Thanks

Rock

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