topic Re: Table maintainence for table maintained through SE16 in Application Development and Automation Discussions

Table maintainence for table maintained through SE16

Former Member — Thu, 03 Sep 2009 22:53:08 GMT

Hi all,

I have a table which has no table maintainence defined in SM30.The entries are mainatined through Se16.

Now in development system,the table entries are maintained thorugh Se16.However in quality system,the table is non modifiable through Se16.

Now the client wants to have a transaction to maintain entries in the table.

What is the best approproach to achieve that?

Thanks.

Edited by: Matt on Sep 9, 2009 7:30 AM

Re: Table maintainence for table maintained through SE16

Former Member — Fri, 04 Sep 2009 04:26:47 GMT

hi,

The best way to give customer authority to maintain table is by creating transaction code.

Please follow the following step

1) Create transaction code using SE93. provide the name as per naming convention.

2) Choose variant transaction out of the five options.

3) provide transaction SM30 and create a variant with update flag.

4) Add the transaction code to customer's role.

5) Transport to quality.

Regards,

Pradyumna

Re: Table maintainence for table maintained through SE16

Former Member — Fri, 04 Sep 2009 04:36:43 GMT

Hi,

In order to that you wold need the table maintainence generator, once you create the table maintainence generator then you can create a parameter transaction in se93 and assiging viewname as the table name and update = 'X'. Also you can create a small program and call the maintainence in the program using FM view_maintenance_call.

Regards,

Himanshu

Re: Table maintainence for table maintained through SE16

Former Member — Fri, 04 Sep 2009 16:50:40 GMT

Thanks for the replies.

Any other suggestions?

Re: Table maintainence for table maintained through SE16

Former Member — Fri, 04 Sep 2009 17:10:57 GMT

Hi,

Well you can also develop your own module pool to handle table maintainence ,which would not required you to create table maintainence generator. Also since it is a z-table you can write simple prorgam to update the table.

REgards,

Himanshu

Re: Table maintainence for table maintained through SE16

Former Member — Tue, 08 Sep 2009 23:03:29 GMT

Thanks Himanshu for the reply.

However it is a standard table and not a custom one.So i need to find the simplest and quickest way so that entries can be maintained in this table.

Generation of table maintainecne would be core mod(modifyig the std table right?).Is this the recommended way?

Re: Table maintainence for table maintained through SE16

Former Member — Wed, 09 Sep 2009 04:04:09 GMT

Hi,

First of all don't post a thread more than once in the forum, you have posted the same question thrice.

Read the forum rules before posting more.

The topic has been discussed a lot before and its a basic question which can be easily found by a search.

so do care for searching before posting a query.

Regards

Karthik D

Re: Table maintainence for table maintained through SE16

matt — Wed, 09 Sep 2009 05:34:27 GMT

I've rejected the duplicate postings. Please post your questions just the once.

In answer to your question: for the most part, directly updating standard SAP tables is a VERY VERY BAD idea. Far worse than making a modification. By doing so, you could be violating the terms of the license. You risk corrupting your database, and would have to pay SAP lots of money to get it fixed.

So, before proceeding, the really important question is: which table are you wanting to update?

matt

Re: Table maintainence for table maintained through SE16

Former Member — Sat, 12 Sep 2009 08:34:00 GMT

Another duplicate rejected again...

Re: Table maintainence for table maintained through SE16

Peranandam — Wed, 16 Sep 2009 14:15:14 GMT

hi,

create maintanance view for your standard table and generate TMG for the for the newly created maintanance view for maintaining value of standard table