SAP ABAP Table QSYSTABLES (iSeries: System Catalog View of Tables in SAP Data Library)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Basic Data

Table Category	INTTAB	Structure
Structure	QSYSTABLES	Table Relationship Diagram
Short Description	iSeries: System Catalog View of Tables in SAP Data Library

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	TBNAME	☐	TBNAME	AS4TAB	CHAR	30	0	iSeries: SQL Name of Table or View	*
2	TBCREATOR	☐	TBCREATOR	QCHAR10	CHAR	10	0	iSeries: Owner of table or view
3	TBTYPE	☐	TBTYPE	QQC11	CHAR	1	0	iSeries: Table type
4	COLCOUNT	☐	COLCOUNT	QINT4	INT4	10	0	iSeries: Number of columns in table/view/index
5	ROW_LENGTH	☐	ROW_LENGTH	QINT4	INT4	10	0	iSeries: Maximum length of any row in table or view
6	LABELTEXT	☐	TB_LABEL	QCHAR50	CHAR	50	0	iSeries: Label of a table or view
7	REMARKS	☐	REMARKS	QQ1000	CHAR	255	0	iSeries: Long comment of a table, view or table field
8	DBNAME	☐	TAB_SCHEMA	QQTLN	CHAR	10	0	iSeries: SQL schema name of table or view
9	ALTEREDTS	☐	ALTEREDTS	QQTIME	CHAR	26	0	iSeries: Timestamp of last change date
10	SYS_TNAME	☐	SYS_TNAME	QCHAR10	CHAR	10	0	iSeries: iSeries system name of table or view
11	SYS_DNAME	☐	SYS_DNAME	QCHAR10	CHAR	10	0	iSeries: iSeries system name of table/view schema

History

Last changed by/on	SAP	20070813
SAP Release Created in