SAP QSYSCOLUMN table - iSeries: System Catalog View of Table Fields (SYSCOLUMNS) details in SAP

SAP QSYSCOLUMN table summary

Object Name: QSYSCOLUMN
Dictionary Type: Structure
Description: iSeries: System Catalog View of Table Fields (SYSCOLUMNS)

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

Details

QSYSCOLUMN-NAME table field - iSeries: SQL column name ▼

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

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

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

QSYSCOLUMN-COLNO table field - iSeries: Ordinal position of field in the table ▼

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

QSYSCOLUMN-COLTYPE table field - iSeries: Table field data type ▼

Description: iSeries: Table field data type
Field Name: COLTYPE
Data Element: COLTYPE
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: QCHAR8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COLTYPE

QSYSCOLUMN-LENGTH table field - iSeries: Table field length ▼

Description: iSeries: Table field length
Field Name: LENGTH
Data Element: LENGTH
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 LENGTH

QSYSCOLUMN-SCALE table field - iSeries: Table field numeric scale ▼

Description: iSeries: Table field numeric scale
Field Name: SCALE
Data Element: NUM_SCALE
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 SCALE

QSYSCOLUMN-NULLS table field - iSeries: Table field is nullable ▼

Description: iSeries: Table field is nullable
Field Name: NULLS
Data Element: NULLS
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 NULLS

QSYSCOLUMN-UPDATES table field - iSeries: Table field is updatable ▼

Description: iSeries: Table field is updatable
Field Name: UPDATES
Data Element: UPDATES
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 UPDATES

QSYSCOLUMN-REMARKS table field - iSeries: Long comment of a table, view or table field ▼

Description: iSeries: Long comment of a table, view or table field
Field Name: REMARKS
Data Element: REMARKS
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: QQ1000
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REMARKS

QSYSCOLUMN-Q_DEFAULT table field - iSeries: Table field has default ▼

Description: iSeries: Table field has default
Field Name: Q_DEFAULT
Data Element: HASDEFAULT
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 Q_DEFAULT

QSYSCOLUMN-Q_LABEL table field - iSeries: Table field column heading ▼

Description: iSeries: Table field column heading
Field Name: Q_LABEL
Data Element: COL_LABEL
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 Q_LABEL

QSYSCOLUMN-STORAGE table field - iSeries: Table field storage requirement ▼

Description: iSeries: Table field storage requirement
Field Name: STORAGE
Data Element: STORAGE
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 STORAGE

QSYSCOLUMN-QPRECISION table field - iSeries: Table field numeric precision ▼

Description: iSeries: Table field numeric precision
Field Name: QPRECISION
Data Element: PRECISION
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 QPRECISION

QSYSCOLUMN-Q_CCSID table field - iSeries: Table field CCSID ▼

Description: iSeries: Table field CCSID
Field Name: Q_CCSID
Data Element: CCSID
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 Q_CCSID

QSYSCOLUMN-DBNAME table field - iSeries: SQL schema name of table or view ▼

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

QSYSCOLUMN-DFTVALUE table field - iSeries: Table field default value ▼

Description: iSeries: Table field default value
Field Name: DFTVALUE
Data Element: DFTVALUE
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 DFTVALUE

QSYSCOLUMN-CHARLEN table field - iSeries: Maximum length of a character column ▼

Description: iSeries: Maximum length of a character column
Field Name: CHARLEN
Data Element: CHARLEN
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 CHARLEN

QSYSCOLUMN-CHARBYTE table field - iSeries: Table field no. of character bytes ▼

Description: iSeries: Table field no. of character bytes
Field Name: CHARBYTE
Data Element: CHARBYTE
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 CHARBYTE

QSYSCOLUMN-RADIX table field - iSeries: Table field RADIX, precision of numeric fie ▼

Description: iSeries: Table field RADIX, precision of numeric fie
Field Name: RADIX
Data Element: RADIX
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 RADIX

QSYSCOLUMN-DATPRC table field - iSeries: Table fields date/time precision ▼

Description: iSeries: Table fields date/time precision
Field Name: DATPRC
Data Element: DATPRC
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 DATPRC

QSYSCOLUMN-LABELTEXT table field - iSeries: Table field lable text ▼

Description: iSeries: Table field lable text
Field Name: LABELTEXT
Data Element: LABELTEXT
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 LABELTEXT

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

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

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