cancel
Showing results for 
Search instead for 
Did you mean: 

List of tables with TABLE Maintenance Dialog

0 Kudos

I am trying to make sure that no-one can edit a table via SE16/SE16N, especially the Z tables and can only do so using SM30/SM31 where access can be restricted by assigning an authorization object.

Is there a table or a query which can give me a list of tables for which table maintenance is defined for SM30/SM31.

I can get a list of tables from DD02L for which Maintenance is allowed, now I want to compare it with tables for which there is a maintenance dialog. I have 1200+ entries, checking manually using SM30 will be a pain.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

So I was able to figure out, the table is TVDIR. I am closing this question.

AlfredoMurguía
Explorer
0 Kudos

Hi Yoguesh. I am looking the same as you. Unfortunatelly, I found tables that are modifiable via sm30 but are not included in table TVDIR. So far, what i did is extract DD02L views, then run table DD25V and find the tables associated to those views, then enter those DD02L to see if those are modifieble. Hope it helps.

Answers (0)