Skip to Content
0

List of tables with TABLE Maintenance Dialog

Jan 05, 2017 at 04:49 PM

85

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Yogesh Ruwali Jan 05, 2017 at 09:22 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.

0