Uploading a Ztable

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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...

[Former Member]

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