‎2010 Jan 27 6:31 PM
Hi friends, i need help with this simple problem. I made and upload of TXT file separated by tab and now I'm trying to split the fields into an internal table, but does't work:
First, table after upload:
BRBR#BRBA#AE-EQPC-02#99999#8085#1#29/11/2012My program:
CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
filename = p_path
filetype = 'ASC'
read_by_line = 'X'
TABLES
data_tab = it_upload
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.
loop at it_upload into wa_upload.
at FIRST.
continue.
endat.
split wa_upload at '#' into wa_datatab-werks
wa_datatab-lgort
wa_datatab-matnr
wa_datatab-lote_o
wa_datatab-lote_d
wa_datatab-qtde
wa_datatab-valid.
APPEND wa_datatab to it_datatab.
endloop.
ENDIF.In result of split, only first field is transported to wa_datatab-werks and others fields area blank.
Thanks for any help!
‎2010 Jan 27 6:40 PM
data: lv_tab type ABAP_CHAR1 value CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB.
split wa_upload at lv_tab into wa_datatab-werks
wa_datatab-lgort
wa_datatab-matnr
wa_datatab-lote_o
wa_datatab-lote_d
wa_datatab-qtde
wa_datatab-valid.
APPEND wa_datatab to it_datatab.
‎2010 Jan 27 6:40 PM
data: lv_tab type ABAP_CHAR1 value CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB.
split wa_upload at lv_tab into wa_datatab-werks
wa_datatab-lgort
wa_datatab-matnr
wa_datatab-lote_o
wa_datatab-lote_d
wa_datatab-qtde
wa_datatab-valid.
APPEND wa_datatab to it_datatab.
‎2010 Jan 27 6:48 PM