Skip to Content
0
Former Member
Dec 03, 2008 at 08:40 PM

Can TXT file with separater ',' be upload to internal TBL using GUI_UPLOAD?

39 Views

hello, experts,

I have a problem with data transfer. I need to upload TXT file to SAP internal table, data in TXT file are separated by ',' and more than one line records are contained in the file. I tried to use FM GUI_UPLOAD as below to upload the file and transfer the data to internal table, however it comes out error. SY-SUBRC is UNKNOW ERROR, error message shows: Cannot interpret date in file.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = FILEPATH

FILETYPE = 'DAT'

HAS_FIELD_SEPARATOR = ','

READ_BY_LINE = 'X'

TABLES

DATA_TAB = TAB_X3

EXCEPTIONS

CONVERSION_ERROR = 1

FILE_OPEN_ERROR = 2

FILE_READ_ERROR = 3

INVALID_TYPE = 4

NO_BATCH = 5

UNKNOWN_ERROR = 6

INVALID_TABLE_WIDTH = 7

GUI_REFUSE_FILETRANSFER = 8

CUSTOMER_ERROR = 9

OTHERS = 10.

Thank you.