List of Tables whose enhancement category as unclassified

[vijay_e]

Is there a way to extract the list of custom tables where the enhancement category is maintained as 'Not Classified'.

[Former Member]

Hi Vijay,

You could write a select query on the database view DD02V where the fields TABNAME like 'Z%' (or 'Y%') and EXCLASS EQ 0.

Thanks,

Sai Kiran.

[jayanthi_jayaraman]

Hi,

You can do that from table DD02L with filter EXCLASS = 0.

[atul_mohanty]

Hi

Retrieve TABNAME (table name) from table DD02L  where TABCLASS = TRANSP (transparent tables) EXCLASS (DD:  Ranking for include and subtype extension) = 0.

If you want Pool table and Cluster table  then add CLUSTER , POOL to the where clause for TABCLASS,