Table maintainence for table maintained through SE16

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Thanks for the replies.

Any other suggestions?

[Former Member]

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

[Former Member]

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?

[Former Member]

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

[matt]

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

[Former Member]

Another duplicate rejected again...

[Peranandam]

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