topic Re: Table maintanace generator in Application Development and Automation Discussions

Table maintanace generator

Former Member — Thu, 22 Feb 2007 16:33:49 GMT

Hi All,

I have a requirement like I need to from a maintenance view of custom table i.e. Ztable I need to remove the Delete button from application tool bar? Is there any way to achieve this thing so that user can’t able to delete the existing records in the data base? if any sample code is there r where i need to do the modification in the function group related to this table maintenance view.

Thanks In Advance

Re: Table maintanace generator

Former Member — Thu, 22 Feb 2007 16:37:32 GMT

Hi,

You can create a maintenance view in SE11 for the custom table..

GO to SE11

Give a view name ZVIEW_TABLE.

Press create..

In the popup choose maintenance view..

In the table/join conditions tab give the table name..

In the view flds tab give the fields that you want..

<b>In the Maint. status tab Choose the radio button "Read and change"</b>

Save and generate the view..

Now in the menu..UTILTIES -> TABLE MAINTENANCE GENERATOR..

Generate the TM..

After generating go to SM30..

Give the view name..

You will not get the delete button...

Thanks,

Naren

Re: Table maintanace generator

Former Member — Thu, 22 Feb 2007 16:44:48 GMT

thanq for u r replay Mr Narendran

but i was already created the table maintenance generator and i am able to view that in SM30 transaction my problem is when user go to change mode i need to restricts him not to change existing records for this i am planning to degrade the delete button. is there any way to do this.

Re: Table maintanace generator

Former Member — Thu, 22 Feb 2007 16:56:14 GMT

Hi,

If you don't want to create another TM, then you can give an error message in PAI if the user presses the delete button..I am not sure how to suppress the delete button other than using MAINTENANCE VIEW...

Thanks,

Naren

Re: Table maintanace generator

Former Member — Thu, 22 Feb 2007 17:08:38 GMT

I think you can probably do this with authorizations.

Rob

Re: Table maintanace generator

Former Member — Fri, 23 Feb 2007 09:43:37 GMT

There are two options:

1. Database view.

While creating the view, choose "database view" instead of maintenance view. This is used on for display purposes and not for changing or delete.

2. Or in the maintenance view, you can use events like before save event "01", which you can use to check for action = 'X' , which means "Delete". And restrict such actions by giving an error message & setting vim_abort_Saving = 'X'.

Re: Table maintanace generator

Former Member — Fri, 23 Feb 2007 09:59:36 GMT

Best way is to use

option "read and change" form the tab "Maint.Status" in the maintenance view.

This allow only to "Read and Change" but not delete.

Re: Table maintanace generator

Former Member — Fri, 23 Feb 2007 10:00:49 GMT

After you change to "read and change" do not forget to re-generate the maintenance view in "Expert Mode".

Re: Table maintanace generator

Former Member — Mon, 26 Feb 2007 09:02:51 GMT

hi..

hava a look on this tcode SE54.

this may be helpful, i think.

shamim.