Upload flat file into a custom table

[Former Member]

hi,

can anyone provide me with a sample code to upload file (comma delimited) into a custom table?

[Former Member]

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = 'd:\myfile.txt'

TABLES

DATA_TAB = rawdata

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

CALL FUNCTION 'TEXT_CONVERT_CSV_TO_SAP'

EXPORTING

I_FIELD_SEPERATOR = ';'

I_LINE_HEADER =

I_TAB_RAW_DATA = rawdata

I_FILENAME = 'd:\myfile1.txt'

TABLES

I_TAB_CONVERTED_DATA = itab

EXCEPTIONS

CONVERSION_FAILED = 1

OTHERS = 2

PLEASE AWARD POINTS FOR HELPFUL ANSWERS AND CLOSE THE THREAD IF IT IS ANSWERED

REGARDS,

MOAZAM HAI

[Former Member]

Hi Jaideep,

You can move the data in the flat file into an Internal Table using the Function Module

'Gui_Upload'.

Once you have the data in the Internal table you can move the data into the custom table .

Kindly reward if helpful.

Regards,

Vijay

[Former Member]

Hi,

Use GUI_UPLOAD function module and get the data into an internal table and use MODIFY statement to populate data into Ztable.

[Former Member]

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = 'd:\myfile.txt'

TABLES

DATA_TAB = rawdata

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

CALL FUNCTION 'TEXT_CONVERT_CSV_TO_SAP'

EXPORTING

I_FIELD_SEPERATOR = ';'

I_LINE_HEADER =

I_TAB_RAW_DATA = rawdata

I_FILENAME = 'd:\myfile1.txt'

TABLES

I_TAB_CONVERTED_DATA = itab

EXCEPTIONS

CONVERSION_FAILED = 1

OTHERS = 2

PLEASE AWARD POINTS FOR HELPFUL ANSWERS AND CLOSE THE THREAD IF IT IS ANSWERED

REGARDS,

MOAZAM HAI