SAP ABAP Table QSYSINDEXS (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	QSYSINDEXS	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	NAME	☐	IDX_NAME	DBINDEX	CHAR	18	0	iSeries: SQL index name
2	IDXCREATOR	☐	IXCREATOR	QCHAR10	CHAR	10	0	iSeries: Owner of index
3	TBNAME	☐	TBNAME	AS4TAB	CHAR	30	0	iSeries: SQL Name of Table or View	*
4	TBCREATOR	☐	TBCREATOR	QCHAR10	CHAR	10	0	iSeries: Owner of table or view
5	TAB_SCHEMA	☐	TAB_SCHEMA	QQTLN	CHAR	10	0	iSeries: SQL schema name of table or view
6	IS_UNIQUE	☐	IS_UNIQUE	QQC11	CHAR	1	0	iSeries: Unique rule of index
7	COLCOUNT	☐	IX_COLCNT	QINT4	INT4	10	0	iSeries: Number of columns in index key
8	IDX_SCHEMA	☐	IDX_SCHEMA	QQTLN	CHAR	10	0	iSeries: SQL schema name of index
9	SYS_IXNAME	☐	SYS_IXNAME	QCHAR10	CHAR	10	0	iSeries: iSeries system index name
10	SYS_IDNAME	☐	SYS_IDNAME	QCHAR10	CHAR	10	0	iSeries: iSeries system index schema name
11	SYS_TNAME	☐	SYS_TNAME	QCHAR10	CHAR	10	0	iSeries: iSeries system name of table or view
12	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