SAP table DB6CATTAB (SYSCAT.TABLES)

Field Description Data Type Length Decimals Checktable Data Element
TABSCHEMA CHAR 128 0
TABNAME CHAR 128 0
DEFINER CHAR 128 0
TYPE CHAR 1 0
STATUS CHAR 1 0
BASE_TABSCHEMA CHAR 128 0
BASE_TABNAME CHAR 128 0
ROWTYPESCHEMA CHAR 128 0
ROWTYPENAME CHAR 128 0
CREATE_TIME DBA: ISO conform timestamp with ms precission CHAR 26 0 DB6DATETIM
STATS_TIME DBA: ISO conform timestamp with ms precission CHAR 26 0 DB6DATETIM
COLCOUNT INT4 10 0
TABLEID INT4 10 0
TBSPACEID INT4 10 0
CARD DEC 22 0
NPAGES DEC 22 0
FPAGES DEC 22 0
OVERFLOW DEC 22 0
TBSPACE CHAR 128 0
INDEX_TBSPACE CHAR 128 0
LONG_TBSPACE CHAR 128 0
PARENTS INT4 10 0
CHILDREN INT4 10 0
SELFREFS INT4 10 0
KEYCOLUMNS INT4 10 0
KEYINDEXID INT4 10 0
KEYUNIQUE INT4 10 0
CHECKCOUNT INT4 10 0
DATACAPTURE CHAR 1 0
CONST_CHECKED CHAR 32 0
PMAP_ID INT4 10 0
PARTITION_MODE CHAR 1 0
LOG_ATTRIBUTE CHAR 1 0
PCTFREE INT4 10 0
APPEND_MODE CHAR 1 0
REFRESH CHAR 1 0
REFRESH_TIME DBA: ISO conform timestamp with ms precission CHAR 26 0 DB6DATETIM
LOCKSIZE CHAR 1 0
VOLATILE CHAR 3 0
REMARKS STRG 0 0
ROW_FORMAT CHAR 1 0
PROPERTY CHAR 32 0
STATISTICS_PROFILE STRG 0 0
COMPRESSION CHAR 13 0
ACCESS_MODE CHAR 1 0
CLUSTERED CHAR 30 0
ACTIVE_BLOCKS DEC 22 0
DROPRULE CHAR 1 0
MAXFREESPACESEARCH INT4 10 0
AVGCOMPRESSEDROWSIZE INT2 5 0
AVGROWCOMPRESSIONRATIO DEC 5 2
AVGROWSIZE INT2 5 0
PCTROWSCOMPRESSED DEC 5 0
PCTPAGESSAVED INT4 10 0
SNAPSHOT_TIMESTAMP DBA: ISO conform timestamp with ms precission CHAR 26 0 DB6DATETIM
ROWCOMPMODE STRG 0 0
TABLEORG STRG 0 0