hi i am trying to update the vendors with email ids. so i have used fm gui_upload and just executed to see how it is pulling data to internal table
but i got error as below with a # and lifnr is taking some part of the emailid as lifnr = 3190#wji@...can u help me please.
types : begin of itab,
lifnr type rf02k-lifnr,
REMARK type adrt-remark,
end of itab.
data : t_itab type table of itab with header line.
data: wa_itab type itab.
*Target table
data : t_bdcdata type standard table of bdcdata,
wa_bdcdata like line of t_bdcdata.
data: MSG LIKE BDCMSGCOLL,
T_MSG LIKE TABLE OF MSG,
MESSAGE(72) TYPE C.
CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
FILENAME = 'C:\Users\suri\Documents\suri1.txt'
FILETYPE = 'ASC'
HAS_FIELD_SEPARATOR = ' '
* HEADER_LENGTH = 0
READ_BY_LINE = 'X'
* DAT_MODE = ' '
* CODEPAGE = ' '
* IGNORE_CERR = ABAP_TRUE
* REPLACEMENT = '#'
* CHECK_BOM = ' '
* VIRUS_SCAN_PROFILE =
* NO_AUTH_CHECK = ' '
* IMPORTING
* FILELENGTH =
* HEADER =
TABLES
DATA_TAB = t_itab
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.
* Implement suitable error handling here
ENDIF.
**_
loop at t_itab into wa_itab.
write : / wa_itab-lifnr,
wa_itab-remark.
endloop.
regards
suri