05-13-2008 6:06 AM
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
05-13-2008 11:23 AM
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
05-13-2008 6:22 AM
Hi Pratyusha,
Check this table
TDDAT : Maintenance Areas for Tables
TVDIR : View Directory.
Reward if useful,
Regards,
Narasimha
05-13-2008 6:57 AM
05-13-2008 11:16 AM
Hi
TDDAT maintenance area for table.
Rewards Points if useful.
Regards
Nikunj Shah
05-13-2008 11:23 AM
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
05-16-2008 11:39 AM
hi ,
TDDAT : Maintenance Areas for Tables
TVDIR : View Directory.
may be use ful to you
regards
dilip