SAP ABAP Table QSYSVIEWDP (iSeries: System Catalog View of View Dependencies on Tables)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Basic Data

Table Category	INTTAB	Structure
Structure	QSYSVIEWDP	Table Relationship Diagram
Short Description	iSeries: System Catalog View of View Dependencies on Tables

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	V_NAME	☐	V_NAME	VIEWNAME	CHAR	30	0	iSeries: SQL view name	*
2	V_CREATOR	☐	TBCREATOR	QCHAR10	CHAR	10	0	iSeries: Owner of table or view
3	TBNAME	☐	TB_V_NAME	AS4TAB	CHAR	30	0	iSeries: SQL name of the table/view the view is created over	*
4	TBCREATOR	☐	TBCREATOR	QCHAR10	CHAR	10	0	iSeries: Owner of table or view
5	TAB_SCHEMA	☐	TAB_SCHEMA	QQTLN	CHAR	10	0	iSeries: SQL schema name of table or view
6	TBTYPE	☐	TB_V_TYPE	QQC11	CHAR	1	0	iSeries: Table type
7	V_SCHEMA	☐	VIEWSCHEMA	QQTLN	CHAR	10	0	iSeries: SQL schema name of view
8	SYS_VNAME	☐	SYS_VNAME	QCHAR10	CHAR	10	0	iSeries: iSeries system name of view
9	SYS_VDNAME	☐	SYS_VDNAME	QCHAR10	CHAR	10	0	iSeries: iSeries system schema name of view
10	SYS_TNAME	☐	SYS_TNAME	QCHAR10	CHAR	10	0	iSeries: iSeries system name of table or view
11	SYS_DNAME	☐	SYS_DNAME	QCHAR10	CHAR	10	0	iSeries: iSeries system name of table/view schema

History

Last changed by/on	SAP	20070813
SAP Release Created in