topic upload flat file in Application Development and Automation Discussions

upload flat file

Former Member — Thu, 24 Jan 2008 09:48:43 GMT

hello experts,

how will i upload flat file structure with header and line items?

i will upload this both from application server and file from PC.

please help me with this.

thank you very much.

-march-

Former Member — Thu, 24 Jan 2008 10:03:19 GMT

Hi,

For uploading file from ur PC (presentation server) u can use FM "GUI_UPLOAD"

For uploading file from application server u can use

syntax: OPEN DATASET

**Reward useful answers

Regards,

Vaibhav

Former Member — Thu, 24 Jan 2008 10:03:55 GMT

Hi March,

Use CG3Z Transaction , This transaction is used for upload files.

Plzz reward if it is useful,

Mahi.

Former Member — Thu, 24 Jan 2008 10:08:44 GMT

do you have sample code for this?

how will i define the internal tables to be used in storing the uploaded file?

thank you.

Former Member — Thu, 24 Jan 2008 12:19:05 GMT

Hi,

To upload file from PC :

**Internal table matching columns in XLS

DATA: BEGIN OF itab OCCURS 0,

field1(10) TYPE c,

field2(10) TYPE c,

END OF itab.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = 'E:\Vaibhav\PivotTableEg.xls'

TABLES

data_tab = itab

IF sy-subrc <> 0.

ENDIF.