Skip to Content
avatar image
Former Member

List of tables with TABLE Maintenance Dialog

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jan 05, 2017 at 09:22 PM

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

    Add comment
    10|10000 characters needed 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.