SAP ABAP Table AGS_TD_QGATE_V (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	AGS_TD_QGATE_V	Table Relationship Diagram
Short Description	Generated Table for View

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	PROJECT	☑	PROJECT_ID	PROJECT_ID	CHAR	10	0	Project name
2	MILESTONE	☑	PROJMILESTONE	SYCHAR32	CHAR	32	0	Project Administration Milestone ID
3	SYSTEM_ROLE	☑	SMSY_ROLE	SMSY_ROLE	CHAR	1	0	System Role
4	SYSTEM_ROLE_TEXT	☐	SMSY_DESCRIPTION	SMSY_DESCRIPTION	CHAR	80	0	General Description
5	CYCLE_ID	☐	AGS_TD_CYCLE_ID	SYSUUID	RAW	16	0	AGS: Project cycle ID
6	STATUS	☐	AGS_TD_CYCLE_STATUS	AGS_TD_CYCLE_STATUS	CHAR	1	0	AGS: Maintenance cycle status
7	CYCLE_NAME	☐	AGS_TD_CYCLE_NAME	AGS_TD_CYCLE_NAME	CHAR	30	0	AGS: Maintenance cycle name
8	CYCLE_ORDER	☐	INT4	INT4	INT4	10	0	Natural number
9	QGATE_TYPE	☐	AGS_TD_QGATE_ID	AGS_TD_QGATE_ID	CHAR	20	0	Available Q-Gates	AGS_TD_QGATE_TYP
10	PHASE	☐	AGS_TD_PHASE_ID	AGS_TD_PHASE_ID	CHAR	20	0	Identifier of phases (10 char Namespace + 10 chars)	AGS_TD_PHASE_TYP
11	PHASE_ORDER	☐	INT4	INT4	INT4	10	0	Natural number
12	QGATE_STATUS	☐	AGS_TD_QGATE_STATUS	AGS_TD_QGATE_STATUS	CHAR	1	0	Overall status of a Q-Gate
13	MILESTONE_TYPE	☐	AGS_TD_MILESTONE_TYPE	AGS_TD_MILESTONE_TYPE	CHAR	1	0	Defines, if a milestone is a Q-Gate

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AGS_TD_QGATE_V	PHASE	AGS_TD_PHASE_TYP	PHASE_ID
2	AGS_TD_QGATE_V	QGATE_TYPE	AGS_TD_QGATE_TYP	QGATE_TYPE

History

Last changed by/on	SAP	20100705
SAP Release Created in