Skip to Content
0
Nov 27, 2012 at 01:27 PM

inserting email id for vendors using xk02...but error with internal table in pulling data

53 Views

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

Attachments

sssa.png (64.6 kB)