SAP Table DB2CATTAB
Info on Tables from DB2 Catalog Table SYSIBM.SYSTABLES
DB2CATTAB (Info on Tables from DB2 Catalog Table SYSIBM.SYSTABLES) 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 DB2CATTAB to other SAP tables.
DB2CATTAB table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| NAME | DB2 table name | DB2TABNAME | CHAR | 18 | 0 | |||||||||||
| CREATOR | DB2 creator name | DB2CREATOR | CHAR | 8 | 0 | |||||||||||
| TYPE | Type of DB2 table | DB2TABTYP | CHAR | 1 | 0 |
Possible values
|
||||||||||
| DBNAME | Database name | DB2DBNAME | CHAR | 8 | 0 | |||||||||||
| TSNAME | Name of the tablespace | DB2TSNAME | CHAR | 8 | 0 | |||||||||||
| RECLENGTH | Maximum length (in bytes) of any record in the table | DB2RECLEN | INT4 | 10 | 0 | |||||||||||
| CARDF | Total number of rows in the table | DB2CARDF | FLTP | 16 | 16 | |||||||||||
