Restricting maintenance of tables

[Former Member]

We need to create a custom transaction code do do mass maintenance on a view. Users must not be able to maintain tables using SE16. How can this be done?

[Former Member]

hi

if u have a table with table maintenance maintained to it and not interested

to give SE16 tcode access to the users then what u can do is

create a transaction code fro that table and give that Tcode access to the users

for this go to SE93 enter the transaction name and click on Create

it will ask for Transaction Type there select Transaction with Parameters RB

under start object tab.

Regards

[Former Member]

Hi Alex,

you can create a parameter transaction for this.

Go to SE93, givve a Z tocde and click on create.

Then select the radio button Parameter transaction and press enter.

You can give the module pool program and screen as the Table maintanace program name and screen numbers ( Program which is geneated while doing the table maintanace)

There the transaction code you can give as SM30 and check the box skip first screen.

At the bottom, Pass the name of the screen field as UPDATE and value as X.

Run this transaction which will take you directly to the table maintance where users can maintain the data.

Regards.

Sai

[Former Member]

Hi Sai,

Your suggestion of "module pool program and screen as the Table maintanace" should help me. I still have two clarifications here if you could help -

1) How do I know what the name of the module pool is and

2) Can the module pool be edited (we will definitely require this)

Thanks

[Former Member]

u can add you custom code in different EVENTS of the table maintanance generator.

Go To SE54-> enter your table main. gen. and Chosse Environment-> events.

select the event as per your need and write your code there in the ABAP editor provided.