2008 Feb 04 8:45 AM
Hi experts ,
I have a requirement to download a file (csv) from my local sytem (say desktop) into an internal table first and then update the contents of the same internal table into the database table.
Can anybody provide me with a sample program for doing the same or at least the name of function modules for the same.
Prompt replies will be rewarded.
TIA
Abhishek
2008 Feb 04 8:48 AM
Use GUI_UPLOAD for uploading the file and put it in the internal table.
Use INSERT statement for changing the data base table.
Check F1 help for the same.
Regards,
Amit
Reward all helpful replies.
2008 Feb 04 8:50 AM
Hi Amit ,
Do you have any sample program showing how to use the INSERT statement.
Thanks and Regards
Abhishek
2008 Feb 04 9:07 AM
Hi Abhishek,
How to use INSERT Statement..
Check this Sample Program..
TABLES:MARA.
DATA:ITAB LIKE MARA OCCURS 0 WITH HEADER LINE.
START-OF-SELECTION.
ITAB-MATNR = '123ABCDA'. .
ITAB-MBRSH = 'C'.
ITAB-MTART = 'FERT' .
ITAB-MEINS = 'KG' .
APPEND ITAB.
ITAB-MATNR = '123ABCDB'. .
ITAB-MBRSH = 'C'.
ITAB-MTART = 'FERT' .
ITAB-MEINS = 'KG' .
APPEND ITAB.
LOOP AT ITAB.
INSERT MARA FROM ITAB.
MODIFY MARA .
ENDLOOP.
2008 Feb 05 8:43 AM
I have given pts to two of the folks as they answered one query each.