topic Re: Table Maintenance Authorization in Application Development and Automation Discussions

Table Maintenance Authorization

Former Member — Thu, 17 Jan 2008 11:22:40 GMT

Hi All,

Have a Nice Day !!!

I have one zabc table having 10 fields. On this table I also have table maintenance . With Z t-code end-users can maintain this table . But I want to restrict the user for modify (change ) and delete access . But at the same time user should have display, copy and new entry access .

Is this possible ?

Thanks in advance .

Regards,

Pankaj

Re: Table Maintenance Authorization

Former Member — Thu, 17 Jan 2008 11:26:46 GMT

while creating a table , choose Data Browser/Table View Maint. field with the option 'table maintance allowed with restiction'.

hope it helps.

rewards if useful.

Re: Table Maintenance Authorization

Former Member — Thu, 17 Jan 2008 11:39:10 GMT

Hi,

In the table maintenance generator u can specify Authorization Group. from this u can restrict the users.

there give standard auth. object or u can create new authorization object from SU21 transaction.

take the help from ur basis for giving the authorization.

Rewards points if helpful.

Regards,

Srinivas Ch

Re: Table Maintenance Authorization

former_member404244 — Thu, 17 Jan 2008 11:56:33 GMT

Hi,

what u can do is goto SE11->give the table name and press change button->now in th next screen,in the menu slect UTILITIES->TABLE MAINTAINENCE GENERATOR->Now u will get the table maintainence generator screen.

Copy the standard Interface into individual interface (Environment->Modification->User Interface)

Disable the function code (DELE) AND (EDIT) of user interface EULG for the program SAPL<UR ZTABLENAME> .

Now ur function codes will be disabled and user cannot delete nor edit..

Regards,

Nagaraj

Re: Table Maintenance Authorization

Former Member — Thu, 17 Jan 2008 12:41:13 GMT

Hi Pankaj,

IF you want to restrist the end user to change or delete the records in ztable i suggest you to create one module pool program.

Develop one screen using table control and keep one buttono on screen named CREATE so that the user can only create the entries in ztable this is easier method.

<b>reward points if useful </b>

Regards,

sunil kairam.

Re: Table Maintenance Authorization

Former Member — Fri, 18 Jan 2008 06:43:42 GMT

Hi Nagaraj ,

Thanks a lot . Problem is solved .

Thanks once again.

Regards,

Pankaj .

Re: Table Maintenance Authorization

former_member404244 — Fri, 18 Jan 2008 06:46:31 GMT

Hi,

U don't mentioned points ....anyways nice to note that ur query is solved..

Regards,

Nagaraj