Upload to Excel option in Table maintenence View

[Former Member]

Hello Gurus,

I have a Z table, for which we have created a table maintenence view generated and then we've attached a Z taransaction code to the same.

So if the user want, he can go to this transaction and add/edit/delete table entries right then and there.

But now the user wants a upload from excel utility/option from the same screen.

I have read somewhere on SDN that we can create custom routines and attach it to table maintenence generator, but i donno how to do it.

Can anyone please guide me or point me to some links...it would be very helpful.

Thanks in advance.

Cheers,

Tatvagna Shah.

[Former Member]

This message was moderated.

[former_member438956]

Hii,

There is no option in table maintenance generator to upload data from excel sheet. u can write a BDC routine or LSMW to achive the same or copy paste the data from excel sheet to R/3 screen but only 22 records at a time from excel sheet.

Regards,

Anil N.

[Former Member]

Thanks a lot to Both Chintan and Anil.

But this is a two-step maintenence view...so cannot copy paste directly..

We are still considering the option of writing a BDC or direct update program, as this is a Z table.

Cheers,

Tatvagna.

[Former Member]

Why write BDC? Just simply upload the data directly form the excel to your z-table

[former_member873340]

I dont understand y a BDC is needed for this update.

Just write a zreport wherein you upload the excel to an internal table and update the same to the Z table.

<b>Chintan_SAP : Please dont ask for points in SDN, it is banned according to the rules of posting.</b>

Regards,

Gowri

[Former Member]

Write a zreport which calls the function module text_convert_xls_to_sap to upload an excel file to an internal table .

update the dbtab using internal table.

[Former Member]

HI ALL,

Recently I faced the same issue, I had to upload 1300 records into the table using table maintenance, First I thought of wiritng a Z program, but realised that it is not acceptable to client, because if the table is uploaded in testing servor or production servor, we have to trasport the program,and this this will only increase no of programs in the produiction servor and this many of these one are required for one time only, because we may require to create table miantenace for many z tables has a whole for the complete project.

My suggestion is to upload the data from excel by pasting (if possible) or manually.

Please correct me if I am wrong.

Thanks,

Vengal Rao.

[Former Member]

Thanks to all....and to update on the solution, I was able to upload using excel by creating some events in Maintenance generator.

[Former Member]

Hi Tatvagna ,

could You describe Your solution?

Which events? Could You share the code?

Regards,

--

Przemysław