Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Table for table maintenance

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

5 REPLIES 5

Former Member
0 Kudos

Hi Pratyusha,

Check this table

TDDAT : Maintenance Areas for Tables

TVDIR : View Directory.

Reward if useful,

Regards,

Narasimha

manubhutani
Active Contributor
0 Kudos

TVDIR- AREA

Please reward points

Former Member
0 Kudos

Hi

TDDAT maintenance area for table.

Rewards Points if useful.

Regards

Nikunj Shah

Former Member
0 Kudos

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
0 Kudos

hi ,

TDDAT : Maintenance Areas for Tables

TVDIR : View Directory.

may be use ful to you

regards

dilip