topic Table Maintenance using Excel in Application Development and Automation Discussions

Table Maintenance using Excel

Former Member — Mon, 09 Feb 2009 09:58:15 GMT

Folks,

I have created table maintenance on custom table. Now I want to use Excel while uploading data using transaction SM30.

So let me know - is it possible to use excel upload on SM30?

Re: Table Maintenance using Excel

former_member195383 — Mon, 09 Feb 2009 10:04:26 GMT

I dont think it is possible through SM30. How ever you can write a program to upload the excel to the table .This can be done through BDC .

Re: Table Maintenance using Excel

Former Member — Mon, 09 Feb 2009 10:04:47 GMT

HI,

yes, u can upload table maintance using exel . try to write upload using recording technique to reduce manuval errors.

are you need to upload xl file with out bdc program if that its not possible.

regds:

rajesh.k

Re: Table Maintenance using Excel

Former Member — Mon, 09 Feb 2009 10:47:37 GMT

Hi,

I thick it would not be possible to upload data from excel through SM30 into table maintenance.

Regards

Pinaki

Re: Table Maintenance using Excel

Former Member — Mon, 09 Feb 2009 11:01:49 GMT

Dear,

Simple technique is,

1.Upload excel sheet into initernal table.

2.Update the internal table data to ztable.

Thanks and Regards

Re: Table Maintenance using Excel

Former Member — Mon, 09 Feb 2009 12:30:57 GMT

hi,

it is not possible excel sheet using SM30 ..u need to write program for uploading excel sheeet..

Thanks

durga.K

Re: Table Maintenance using Excel

Former Member — Mon, 09 Feb 2009 12:46:41 GMT

Hi,

It may not be possible to give data from excel directly in SM30. But you can do by:

System~~> Services~~> Fast Entry--> Recording

Record the transaction and then pocess the recording with the menu path Fast Entry --> Process

or by writing an appropriate BDC program.

Re: Table Maintenance using Excel

Former Member — Tue, 10 Feb 2009 10:36:46 GMT

Thanks folks for your reply.

But I don't want to write BDC, I feel Excel upload is not possible on SM30.

Thanks once again.

Re: Table Maintenance using Excel

Former Member — Wed, 11 Feb 2009 10:54:46 GMT

hiii,

it is not possible to upload excel in sm30,it is possible only in bdc.

In sm30 (table maintenanace) we can upload multiple records of fields.

with regards,

sumanth reddy