topic Upload the data into Ztable in Application Development and Automation Discussions

Upload the data into Ztable

Former Member — Wed, 22 Aug 2007 17:05:15 GMT

Hi guys this is very very urgent. plz help me.

How to upload the data into ZTABLE(database table) using online or batch input method. the data will be from either presentation server or application server.

regards

venkat

Re: Upload the data into Ztable

Former Member — Wed, 22 Aug 2007 17:13:19 GMT

Hello Venkat,

You can use FM GUI_UPLOAD(.TXT) or ALSM_EXCEL_TO_INTERNAL_TABLE ( XLS File) to get data from file to internal table..

and use insert command or modify command.

here no need to use BDC..

Thanks

Seshu

Re: Upload the data into Ztable

Former Member — Wed, 22 Aug 2007 17:14:34 GMT

Read the data into a internal table eg: itab1( similar in structure to you z table)

data: itab1 type table of <ztable>.

data: wa type <ztable>.

For reading:

Presentation server: use GUI_UPLOAD

Application server: Open Dataset, read dataset and close dataset.

For uploading:

Loop at itab1 into wa

insert into <ztable> values wa.

endloop.

Re: Upload the data into Ztable

Former Member — Wed, 22 Aug 2007 18:02:10 GMT

Hi seshu,

Thank you for your response.

But my question is, I should use Online as well as Batch method to upload the data into that Ztable. those two are radio buttons and whichever has been selected it has to work.