topic Re: Table for table maintenance in Application Development and Automation Discussions

Table for table maintenance

Former Member — Tue, 13 May 2008 05:06:36 GMT

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

Re: Table for table maintenance

Former Member — Tue, 13 May 2008 05:22:03 GMT

Hi Pratyusha,

Check this table

TDDAT : Maintenance Areas for Tables

TVDIR : View Directory.

Reward if useful,

Regards,

Narasimha

Re: Table for table maintenance

manubhutani — Tue, 13 May 2008 05:57:00 GMT

TVDIR- AREA

Please reward points

Re: Table for table maintenance

Former Member — Tue, 13 May 2008 10:16:47 GMT

TDDAT maintenance area for table.

Rewards Points if useful.

Regards

Nikunj Shah

Re: Table for table maintenance

Former Member — Tue, 13 May 2008 10:23:56 GMT

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

Re: Table for table maintenance

Former Member — Fri, 16 May 2008 10:39:21 GMT

hi ,

TDDAT : Maintenance Areas for Tables

TVDIR : View Directory.

may be use ful to you

regards

dilip