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

SAP QSYSKEYCST table summary

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

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

Details

QSYSKEYCST-CDBNAME table field - iSeries: SQL schema name of a constraint ▼

Description: iSeries: SQL schema name of a constraint
Field Name: CDBNAME
Data Element: CS_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 CDBNAME

QSYSKEYCST-RELNAME table field - iSeries: SQL constraint name ▼

Description: iSeries: SQL constraint name
Field Name: RELNAME
Data Element: RELNAME
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 RELNAME

QSYSKEYCST-TDBNAME table field - iSeries: SQL schema name of table or view ▼

Description: iSeries: SQL schema name of table or view
Field Name: TDBNAME
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 TDBNAME

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

QSYSKEYCST-COL_NAME table field - iSeries: SQL column name ▼

Description: iSeries: SQL column name
Field Name: COL_NAME
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 COL_NAME

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

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

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

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

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

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