SAP QSYSCST table - iSeries: System Catalog View of Constraints (SYSCST) details in SAP

SAP QSYSCST table summary

Object Name: QSYSCST
Dictionary Type: Structure
Description: iSeries: System Catalog View of Constraints (SYSCST)

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

Details

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

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

QSYSCST-CONST_TYPE table field - iSeries: Constraint type ▼

Description: iSeries: Constraint type
Field Name: CONST_TYPE
Data Element: CONST_TYPE
Data Type: CHAR
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: QCHAR11
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONST_TYPE

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

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

QSYSCST-ISDEFER table field - iSeries: Constraint checking can be deferred (Yes/No) ▼

Description: iSeries: Constraint checking can be deferred (Yes/No)
Field Name: ISDEFER
Data Element: ISDEFER
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: QCHAR3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISDEFER

QSYSCST-INITDEFER table field - iSeries: Constraint defined as initially deferred (Yes/No) ▼

Description: iSeries: Constraint defined as initially deferred (Yes/No)
Field Name: INITDEFER
Data Element: INITDEFER
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: QCHAR3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INITDEFER

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

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