topic Re: Uploading data in Application Development and Automation Discussions

Uploading data

Former Member — Tue, 12 Feb 2008 07:40:51 GMT

Hi gurus,

I want upload flatfile data into ztable.How can i do it?after uploading that should be triggerd to CORK tcode.........pls........help me with sample code..........

Thank you in advance

Re: Uploading data

former_member404244 — Tue, 12 Feb 2008 07:44:57 GMT

Hi,

Declare the internal table like the structure of ztable and then use GUI_UPLOAD FM to uplaod data to ur internal table and finally update ur ztable with the internal table

update ztable from table itab.

if sy-subrc eq 0.

commit work.

endif.

Regards,

Nagaraj

Re: Uploading data

Former Member — Tue, 12 Feb 2008 07:45:52 GMT

Hi,

use function module 'gui_upload'

data:

begin of ztable occurs 10,

tab type c length 200,

end of ztable.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = 'ur file path'

FILETYPE = 'ASC'
HAS_FIELD_SEPARATOR = ' '

tables

data_tab = ztable

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Plzz reward points if it helps.

Re: Uploading data

Former Member — Tue, 12 Feb 2008 07:47:37 GMT

To upload a flatfile u can use FM 'GUI_UPLOAD'. Here is the sample code.

DATA: i_file like rlgrap-filename value 'C:/tmp/file.txt'.

DATA: begin of it_datatab occurs 0,

row(500) type c,

end of it_datatab.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = i_file

filetype = 'ASC'

TABLES

data_tab = it_datatab "ITBL_IN_RECORD[]

EXCEPTIONS

file_open_error = 1

OTHERS = 2.

Regards

Gaurav

Re: Uploading data

Former Member — Tue, 12 Feb 2008 07:47:52 GMT

Hi Ramkrishna,

No need to write a program to upload data into a z table. Instead you can use tools like SCATT. Use the following idiots guide to SCATT: http://www.qsands.com/QSandS_CATT_Step_By_Step.pdf

Reward if useful

rgds,

Harikrishna

Re: Uploading data

Former Member — Tue, 12 Feb 2008 07:48:36 GMT

Hi that greate answer,but aster uploading that i need to trigger CORK Tcode ...how it is?pls

Re: Uploading data

Former Member — Tue, 12 Feb 2008 08:01:42 GMT

After uploading the file .... instead of Tcode CORK to create Process Order confirmation, you can use the fm 'BAPI_PROCORD_CREATE' passing the parameters from internal table

Regards

Gaurav