Load .cvs into ZTABLE

[Former Member]

Hi all,

I want to upload a local CVS-file into a ZTABLE. How can I do this the easiest way?

Thanks and regards,

Stefan

[Former Member]

Hi all,

I want to upload a local CVS-file into a ZTABLE. How can I do this the easiest way?

Thanks and regards,

Stefan

[Former Member]

1) upload .csv file into internal table(using gui_upload function)

2) insert value of internal table into ztable

[Former Member]

Hi,

upload that CSV file to itab using GUI_UPLOAD or some FM.

use Modify ZTABle From ITAB.

this is simpler one.

Regards

vijay

[Former Member]

Hi Stefan,

You can upload data from presentation server to an internal table using gui_upload. Use gui_download to download from internal table to flat file.

Use fm ALSM_EXCEL_TO_INTERNAL_TABLE to upload data frm excel.

Use function module GUI_UPLOAD for .csv

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = 'C:\test.csv'

FILETYPE = 'ASC'

TABLES

DATA_TAB = 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.

Regards,

Anjali

[shiva_kumar6]

how i should upload the flat file into ztable can u send the full code

[Former Member]

HI!!

Check this post.

Regards,

Susmitha

Award points for useful answers.

[Former Member]

HI

GOOD

GO THROUGH THIS LINK

http://www.hiva.be/docs/rapport/R895.pdf

THANKS

MRUTYUN