2007 Aug 22 6:05 PM
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
2007 Aug 22 6:13 PM
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
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
2007 Aug 22 6:13 PM
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
2007 Aug 22 7:02 PM
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.
2007 Aug 22 6:14 PM
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.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |