topic Re: Table maintenance Generator + Tcode for SM30 in Application Development and Automation Discussions

Table maintenance Generator + Tcode for SM30

Former Member — Tue, 27 Jul 2010 11:19:49 GMT

Hi,

I have created a table maintenance generator for a Z table. Then I created a transaction from SE93 for SM30 and passing table name as parameter.

My requirement is that the user should only be able to delete records from the Z table. It should not allow to insert or modify records.

When I execute the transaction created above it is allowing to insert, modify and delete records from Z table.

How to solve this issue? Please help.

Thanks in advance....

Regards,

Sriram

Re: Table maintenance Generator + Tcode for SM30

Former Member — Tue, 27 Jul 2010 11:27:58 GMT

Hi Sriram,

In Tcode SE55 you can change the maintenance dialog via Environment --> Modification --> User Interface

Hope it helps,

Tom.

Re: Table maintenance Generator + Tcode for SM30

Former Member — Tue, 27 Jul 2010 11:43:08 GMT

Hi Tom,

Thanks very much for your reply. When I go to user interface everything seems to be greyed out. When I click the change mode it is going to menu painter but it is not showing anything in status.

Regards,

Sriram

Re: Table maintenance Generator + Tcode for SM30

Former Member — Tue, 27 Jul 2010 12:13:49 GMT

Hi Sriram,

On the screen for user unterface, the choice between standard or individual interface is greyed out, but on the bottom of the screen you find a button Std. <-> Ind. With this button you can switch between standard and individual interface.

When you press the edit button you get the menu painter. Here you can change status ZULG, in which you can deactivate whatever function you want deactivated.

Hope this helps.

Tom.

Edited by: T. Burger on Jul 27, 2010 2:14 PM

Re: Table maintenance Generator + Tcode for SM30

Former Member — Tue, 27 Jul 2010 12:25:09 GMT

Hi Sri Ram,

In SE55, just provide the table name and select the function list & click on change. Then remove the function code that you do not want.

For your requirement, may be you have tio remove the below function code,

NEWL - New record

ANZG - EDIT

KOPE - COPY

If you have any issue in doing the same, please let us know.

Regards,

Selva K.

Re: Table maintenance Generator + Tcode for SM30

Former Member — Wed, 28 Jul 2010 07:00:04 GMT

Hi Tom,

Thanks again. When I get into menu painter and edit status ZULG I get evrything in German. After I save and get into the transaction all menu shown in German. How to show that in English.

Thanks & Regards,

Sriram

Re: Table maintenance Generator + Tcode for SM30

Former Member — Wed, 28 Jul 2010 10:54:16 GMT

Hi Sriram,

I don't know why your language has changed to German. When I change status ZULG, the language remains English.

To see what happens I have created new maintenance screens and I went into the Modification --> User Interface.

On the next screen I pressed Copy User Interface and after that I got a warning about diferent languages. I just pressed enter. Now the popup screen gives me the possibility to change the interface. I went straight into change mode, without switching to individual interface. I changed status ZULG (everything is in German), activated the status and returned to SE55.

When I start SM30 , all texts are in German.

Because this is not what you and I want, I started again, I deleted my table maintance and created it again. Went into the modification of user interface again and again copied the user interface. Now I went into change mode and I looked at my user interface (in display mode) and all texts are in German. Went back to the strat screen of the menu painter, ACTIVATED THE USER INTERFACE and now, when I change the status ZULG, all texts are in English.

So, all you need to do is activate the user interface before you change it.

When you have a 2-screen table maintenance (an overview and a detail screen), you might want to change status ZUDG as well.

Kind regards, I hope you succeed this time around.

Tom.

Re: Table maintenance Generator + Tcode for SM30

Former Member — Wed, 28 Jul 2010 11:14:35 GMT

Hi Tom,

Thanks a lot. Problem got solved.

Regards,

Sriram