SAP QSYSINDEXS table - iSeries: System Catalog View of Tables in SAP Data Library details in SAP

SAP QSYSINDEXS table summary

Object Name: QSYSINDEXS
Dictionary Type: Structure
Description: iSeries: System Catalog View of Tables in SAP Data Library

Field list for QSYSINDEXS table on an S/4 SAP system

Details

QSYSINDEXS-NAME table field - iSeries: SQL index name ▼

Description: iSeries: SQL index name
Field Name: NAME
Data Element: IDX_NAME
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: DBINDEX
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

QSYSINDEXS-IDXCREATOR table field - iSeries: Owner of index ▼

Description: iSeries: Owner of index
Field Name: IDXCREATOR
Data Element: IXCREATOR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QCHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IDXCREATOR

QSYSINDEXS-TBNAME table field - iSeries: SQL Name of Table or View ▼

Description: iSeries: SQL Name of Table or View
Field Name: TBNAME
Data Element: TBNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: AS4TAB
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TBNAME

QSYSINDEXS-TBCREATOR table field - iSeries: Owner of table or view ▼

Description: iSeries: Owner of table or view
Field Name: TBCREATOR
Data Element: TBCREATOR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QCHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TBCREATOR

QSYSINDEXS-TAB_SCHEMA table field - iSeries: SQL schema name of table or view ▼

Description: iSeries: SQL schema name of table or view
Field Name: TAB_SCHEMA
Data Element: TAB_SCHEMA
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QQTLN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TAB_SCHEMA

QSYSINDEXS-IS_UNIQUE table field - iSeries: Unique rule of index ▼

Description: iSeries: Unique rule of index
Field Name: IS_UNIQUE
Data Element: IS_UNIQUE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: QQC11
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IS_UNIQUE

QSYSINDEXS-COLCOUNT table field - iSeries: Number of columns in index key ▼

Description: iSeries: Number of columns in index key
Field Name: COLCOUNT
Data Element: IX_COLCNT
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QINT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COLCOUNT

QSYSINDEXS-IDX_SCHEMA table field - iSeries: SQL schema name of index ▼

Description: iSeries: SQL schema name of index
Field Name: IDX_SCHEMA
Data Element: IDX_SCHEMA
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QQTLN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IDX_SCHEMA

QSYSINDEXS-SYS_IXNAME table field - iSeries: iSeries system index name ▼

Description: iSeries: iSeries system index name
Field Name: SYS_IXNAME
Data Element: SYS_IXNAME
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QCHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SYS_IXNAME

QSYSINDEXS-SYS_IDNAME table field - iSeries: iSeries system index schema name ▼

Description: iSeries: iSeries system index schema name
Field Name: SYS_IDNAME
Data Element: SYS_IDNAME
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QCHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SYS_IDNAME

QSYSINDEXS-SYS_TNAME table field - iSeries: iSeries system name of table or view ▼

Description: iSeries: iSeries system name of table or view
Field Name: SYS_TNAME
Data Element: SYS_TNAME
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QCHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SYS_TNAME

QSYSINDEXS-SYS_DNAME table field - iSeries: iSeries system name of table/view schema ▼

Description: iSeries: iSeries system name of table/view schema
Field Name: SYS_DNAME
Data Element: SYS_DNAME
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QCHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SYS_DNAME

View list of all SAP tables(S4H/ECC)

Select data from SAP table