Table for table maintenance

[Former Member]

Hi SDN's,

Which table gives the information if a Z table has table maintenance or not?

Which means i need the list of all Z tables which do not have a table maintenance generated?

Regards

Pratyusha

[Former Member]

Hi Pratyusha,

Check this table

TDDAT : Maintenance Areas for Tables

TVDIR : View Directory.

Reward if useful,

Regards,

Narasimha

[manubhutani]

TVDIR- AREA

Please reward points

[Former Member]

Hi

TDDAT maintenance area for table.

Rewards Points if useful.

Regards

Nikunj Shah

[Former Member]

Hi,

For checking if table maintenance is allowed:

You can query the table DD02L for TABNAME = Z* where MAINFLAG = 'X' (Display/Maintenance Allowed) or SPACE (Display/Maintenance Allowed with Restrictions).

If you want to check if there is a table maintenance is actually defined:

Query the table TVDIR with TABNAME = Z* (Both Z Tables and Z Views)

Regards

Kiran Sure

[Former Member]

hi ,

TDDAT : Maintenance Areas for Tables

TVDIR : View Directory.

may be use ful to you

regards

dilip