Restricting delete access for a Z SAP table

[Former Member]

I have created one z table in sap, i need to restrict the user from deleting the entires but the user can insert or update the entires.

So could anyone help me in how to restrict the delete access on z sap table.

[JozsefSzikszai]

hi Sridhar,

create the maintenance view in SE11 and modify the automatically created function afterwards.

hope this helps

ec

[Former Member]

Hi ,

Can u be elaborate

[Former Member]

hi,

in program splsvim gui status eulg is the one which gets generated when u generate your maintenance screen through table maintenance generator.

copy the following code this code will hide the delete button on the table maintanence screen.

REPORT ZVIEW.

DATA: i_excl_cua_funct LIKE vimexclfun OCCURS 0 WITH HEADER LINE.

• deactivate menu bar option

i_excl_cua_funct-function = 'DELE'.

APPEND i_excl_cua_funct.

• call view

CALL FUNCTION 'VIEW_MAINTENANCE_CALL'

EXPORTING

action = 'U'

generate_maint_tool_if_missing = 'X'

view_name = 'ZTEST' "this is the table name

TABLES

excl_cua_funct = i_excl_cua_funct.

plz reward points if it helps rgds

[Former Member]

hi,

there is no program with the name splsvim.

[Former Member]

hi,

go to se38 give SAPLSVIM its a function pool program

wht i did was i created a ztable say 'ztest'.then i generated one step maintenance screen for it.the above mentioned program contains gui status which gets generated when we activate the maintenance screen.

now u create a report & copy paste this code:

REPORT ZVIEW.

DATA: i_excl_cua_funct LIKE vimexclfun OCCURS 0 WITH HEADER LINE.

i_excl_cua_funct-function = 'DELE'.

APPEND i_excl_cua_funct.

• call view

CALL FUNCTION 'VIEW_MAINTENANCE_CALL'

EXPORTING

action = 'U'

generate_maint_tool_if_missing = 'X'

view_name = 'ZTEST'

TABLES

excl_cua_funct = i_excl_cua_funct.

whenu will generate this report THE DELETE ICON wont be visible. so u can just make a transaction code for this report & give it to your user.

i hope this helps

rgds

[Former Member]

give some auhorization checks to that

[Former Member]

hi,

in program SAPLSVIM , from Gui status ---> eulg we get the function code for the delete button which is in application toolbar ( function code is 'DELE').& then this function code is used in the report.

hope it helps.

rgds