05-17-2008 10:35 AM
Hi all,
I want to upload data from excel file into Z-table.
Suggest me various ways of doing it with steps.
Thanks in advance,
Regards,
Balaji
05-17-2008 11:03 AM
Hi,
We can use INSERT command or UPDATE command.
Also please refer this link.
https://www.sdn.sap.com/irj/sdn/advancedsearch?query=uploading+ztable&cat=sdn_all
Edited by: Sathya on May 17, 2008 12:11 PM
05-17-2008 11:04 AM
hi check this..
first get the values into the table from the excel file using the function module ....ALSM_EXCEL_TO_INTERNAL_TABLE
and do like this..
loop at itab.
zitab-field1 = itab-field1.
zitab-field2 = itab-field2.
zitab-field3 = itab-field3.
zitab-field4 = itab-field4.
zitab-field5 = itab-field5.
insert ztable.
endloop .
or you can use the use the update statement.. or you can use the bdc for that
regards,
venkat.
05-17-2008 11:05 AM
one way which i can suggest u is that first get tha data from the file into an internal table using wa_upload function module.
then if needed you can split the data from the internal table as needed eg.split at ',' into some other internal table.and then move the corressponding entries from that internal table to ztable.
splitting is not necessary.
please rply back...
05-17-2008 11:06 AM
Hi,
You can define table maintainenace or write a small zprogram as follows:
Get all the data from xcl into internal table using
ALSM_EXCEL_TO_INTERNAL_TABLE
and then use modify statement to modify data base..
Regards,
Nishant