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

SAP QSYSVIEWS table summary

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

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

Details

QSYSVIEWS-V_NAME table field - iSeries: SQL view name ▼

Description: iSeries: SQL view name
Field Name: V_NAME
Data Element: V_NAME
Data Type: CHAR
length (Dec): 30(0)
Check table: *
Conversion Routine:
Domain Name: VIEWNAME
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field V_NAME

QSYSVIEWS-V_CREATOR table field - iSeries: Owner of table or view ▼

Description: iSeries: Owner of table or view
Field Name: V_CREATOR
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 V_CREATOR

QSYSVIEWS-SEQ_NO table field - iSeries: Sequence no. of this row; will allways be 1 ▼

Description: iSeries: Sequence no. of this row; will allways be 1
Field Name: SEQ_NO
Data Element: SEQ_NO
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 SEQ_NO

QSYSVIEWS-CHECK_OPT table field - iSeries: Check option used on view ▼

Description: iSeries: Check option used on view
Field Name: CHECK_OPT
Data Element: CHECK_OPT
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 CHECK_OPT

QSYSVIEWS-VIEW_DEF table field - iSeries: Part of view definition, if possible ▼

Description: iSeries: Part of view definition, if possible
Field Name: VIEW_DEF
Data Element: VIEW_DEF
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 VIEW_DEF

QSYSVIEWS-UPDATES table field - iSeries: View is updatable ▼

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

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

Description: iSeries: SQL schema name of view
Field Name: DBNAME
Data Element: VIEWSCHEMA
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

QSYSVIEWS-SYS_TNAME table field - iSeries: iSeries system name of view ▼

Description: iSeries: iSeries system name of view
Field Name: SYS_TNAME
Data Element: SYS_VNAME
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

QSYSVIEWS-SYS_DNAME table field - iSeries: iSeries system schema name of view ▼

Description: iSeries: iSeries system schema name of view
Field Name: SYS_DNAME
Data Element: SYS_VDNAME
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