SAP Table QSYSTABLES
iSeries: System Catalog View of Tables in SAP Data Library
QSYSTABLES (iSeries: System Catalog View of Tables in SAP Data Library) 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 QSYSTABLES to other SAP tables.
QSYSTABLES table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| TBNAME | iSeries: SQL Name of Table or View | TBNAME | CHAR | 30 | 0 | |||
| TBCREATOR | iSeries: Owner of table or view | TBCREATOR | CHAR | 10 | 0 | |||
| TBTYPE | iSeries: Table type | TBTYPE | CHAR | 1 | 0 | |||
| COLCOUNT | iSeries: Number of columns in table/view/index | COLCOUNT | INT4 | 10 | 0 | |||
| ROW_LENGTH | iSeries: Maximum length of any row in table or view | ROW_LENGTH | INT4 | 10 | 0 | |||
| LABELTEXT | iSeries: Label of a table or view | TB_LABEL | CHAR | 50 | 0 | |||
| REMARKS | iSeries: Long comment of a table, view or table field | REMARKS | CHAR | 255 | 0 | |||
| DBNAME | iSeries: SQL schema name of table or view | TAB_SCHEMA | CHAR | 10 | 0 | |||
| ALTEREDTS | iSeries: Timestamp of last change date | ALTEREDTS | CHAR | 26 | 0 | |||
| SYS_TNAME | iSeries: iSeries system name of table or view | SYS_TNAME | CHAR | 10 | 0 | |||
| SYS_DNAME | iSeries: iSeries system name of table/view schema | SYS_DNAME | CHAR | 10 | 0 | |||
