Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Table Maintenance - remove ability to delete records?

mike_reader3
Active Participant
0 Kudos

I have created a table maintenance for one of my Z* tables. There is a z* transaction assigned to this (through SE93). I would like to take away the ability to delete records when they run the transaction to maintain this table.

Anyone know of a way to do this? Is there a way to grey out the delete button?

Thanks

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

Sorry..I forgot the user has to Add also..

Ok..Try this..

Go to SE51...give the program SAPL + Function group name...The one which you used to create the table maintenance..

Give the screen number..

Press change..

Before the module LISTE_INITIALISIEREN..

Create a module..MODULE zmodule.

in the module add the the following code..

DATA: s_VIMEXCLFUN type VIMEXCLFUN.

* remove the delete button.
s_VIMEXCLFUN-function = 'DELE'.

APPEND s_VIMEXCLFUN TO excl_cua_funct.

Thanks

Naren

8 REPLIES 8

Former Member
0 Kudos

Hi,

Create a maintenance view in SE11..There in the "maintenance status" tab there is radio button to say "Read and change"

And then generate the table maintenance for the maintenance view...

Thanks

Naren

0 Kudos

I do not see this option anywhere in SE11?

former_member188685
Active Contributor
0 Kudos

you can control with the help of Authorizations. Assign the Authorization object to that table maintenance and can block the users to use that option.

former_member188685
Active Contributor
0 Kudos

And also you can control this by creating a custom program and inside that call the function

VIEW_MAINTENANCE_CALL

in this there is a table parameter EXCL_CUA_FUNCT , for this append the DELETE button function code this way you can Exclude that option.

Former Member
0 Kudos

Hi,

Here are the steps..

Go to SE11..choose the radio button view..

give a z name..ZMAINT_VIEW.

Press create..

Choose the radio button maintenance view..

Press enter..

Give the table name as your z table and short description..

in that screen..there is a tab for "Maint. Status"...choose the tab...

There you can find the settings to make it Read and change only..

Thanks

Naren

0 Kudos

I have that working now ... however, I need to make it so that the user can

Add

Edit

but not Delete, non of the options seem to let me do that?

Former Member
0 Kudos

Hi,

Sorry..I forgot the user has to Add also..

Ok..Try this..

Go to SE51...give the program SAPL + Function group name...The one which you used to create the table maintenance..

Give the screen number..

Press change..

Before the module LISTE_INITIALISIEREN..

Create a module..MODULE zmodule.

in the module add the the following code..

DATA: s_VIMEXCLFUN type VIMEXCLFUN.

* remove the delete button.
s_VIMEXCLFUN-function = 'DELE'.

APPEND s_VIMEXCLFUN TO excl_cua_funct.

Thanks

Naren

0 Kudos

Thanks that works like I need to to ... points were awarded!