Upload the data into Ztable

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.