SAP Table DB6CATTAB
DB6 complete SYSCAT.TABLES table structure
DB6CATTAB (DB6 complete SYSCAT.TABLES table structure) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link DB6CATTAB to other SAP tables.
DB6CATTAB table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| 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 | DB6DATETIM | CHAR | 26 | 0 | |||
| STATS_TIME | DBA: ISO conform timestamp with ms precission | DB6DATETIM | CHAR | 26 | 0 | |||
| 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 | DB6DATETIM | CHAR | 26 | 0 | |||
| 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 | DB6DATETIM | CHAR | 26 | 0 | |||
| ROWCOMPMODE | STRG | 0 | 0 | |||||
| TABLEORG | STRG | 0 | 0 | |||||
