SAP QSYSKEYS table - iSeries: System Catalog View of Constraints Columns details in SAP

SAP QSYSKEYS table summary

Object Name: QSYSKEYS
Dictionary Type: Structure
Description: iSeries: System Catalog View of Constraints Columns

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

Details

QSYSKEYS-IDX_NAME table field - iSeries: SQL index name ▼

Description: iSeries: SQL index name
Field Name: IDX_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 IDX_NAME

QSYSKEYS-IXCREATOR table field - iSeries: Owner of index ▼

Description: iSeries: Owner of index
Field Name: IXCREATOR
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 IXCREATOR

QSYSKEYS-COLNAME table field - iSeries: SQL column name ▼

Description: iSeries: SQL column name
Field Name: COLNAME
Data Element: COL_NAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: FDNAME
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COLNAME

QSYSKEYS-COL_POS table field - iSeries: Ordinal position of field in the table ▼

Description: iSeries: Ordinal position of field in the table
Field Name: COL_POS
Data Element: ORD_POS
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 COL_POS

QSYSKEYS-COL_SEQ table field - iSeries: Position of column within the key/index ▼

Description: iSeries: Position of column within the key/index
Field Name: COL_SEQ
Data Element: COL_SEQ
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COL_SEQ

QSYSKEYS-ORDERING table field - iSeries: Order of the column in the index ▼

Description: iSeries: Order of the column in the index
Field Name: ORDERING
Data Element: ORDERING
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 ORDERING

QSYSKEYS-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

QSYSKEYS-SYS_CNAME table field - iSeries: iSeries system column name ▼

Description: iSeries: iSeries system column name
Field Name: SYS_CNAME
Data Element: SYS_CNAME
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_CNAME

QSYSKEYS-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

QSYSKEYS-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

View list of all SAP tables(S4H/ECC)

Select data from SAP table