Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Upload to Excel option in Table maintenence View

Former Member
0 Kudos
590

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.

9 REPLIES 9

Former Member
0 Kudos
212

This message was moderated.

former_member438956
Active Participant
0 Kudos
212

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.

0 Kudos
212

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
0 Kudos
212

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

0 Kudos
212

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
0 Kudos
212

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.

0 Kudos
212

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
0 Kudos
212

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

0 Kudos
212

Hi Tatvagna ,

could You describe Your solution?

Which events? Could You share the code?

Regards,

--

Przemysław