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

SAP QSYSTABLES table summary

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

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

Details

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

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

QSYSTABLES-TBTYPE table field - iSeries: Table type ▼

Description: iSeries: Table type
Field Name: TBTYPE
Data Element: TBTYPE
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 TBTYPE

QSYSTABLES-COLCOUNT table field - iSeries: Number of columns in table/view/index ▼

Description: iSeries: Number of columns in table/view/index
Field Name: COLCOUNT
Data Element: COLCOUNT
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

QSYSTABLES-ROW_LENGTH table field - iSeries: Maximum length of any row in table or view ▼

Description: iSeries: Maximum length of any row in table or view
Field Name: ROW_LENGTH
Data Element: ROW_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 ROW_LENGTH

QSYSTABLES-LABELTEXT table field - iSeries: Label of a table or view ▼

Description: iSeries: Label of a table or view
Field Name: LABELTEXT
Data Element: TB_LABEL
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: QCHAR50
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LABELTEXT

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

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

QSYSTABLES-ALTEREDTS table field - iSeries: Timestamp of last change date ▼

Description: iSeries: Timestamp of last change date
Field Name: ALTEREDTS
Data Element: ALTEREDTS
Data Type: CHAR
length (Dec): 26(0)
Check table:
Conversion Routine:
Domain Name: QQTIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ALTEREDTS

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

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