SAP QSYSVIEWDP table - iSeries: System Catalog View of View Dependencies on Tables details in SAP


SAP QSYSVIEWDP table summary

Object Name: QSYSVIEWDP
Dictionary Type: Structure
Description: iSeries: System Catalog View of View Dependencies on Tables


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

Details
QSYSVIEWDP-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

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

QSYSVIEWDP-TBNAME table field - iSeries: SQL name of the table/view the view is created over

Description: iSeries: SQL name of the table/view the view is created over
Field Name: TBNAME
Data Element: TB_V_NAME
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

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

QSYSVIEWDP-TAB_SCHEMA table field - iSeries: SQL schema name of table or view

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

QSYSVIEWDP-TBTYPE table field - iSeries: Table type

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

QSYSVIEWDP-V_SCHEMA table field - iSeries: SQL schema name of view

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

QSYSVIEWDP-SYS_VNAME table field - iSeries: iSeries system name of view

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

QSYSVIEWDP-SYS_VDNAME table field - iSeries: iSeries system schema name of view

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

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

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