SAP ABAP Table DPR_TS_CTRLPLAN_H_DAT (Control Plan Data)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PRO-CPL (Application Component) Control Plan
     ⤷ DEVELOPMENT_PROJECTS_CTRL_PLAN (Package) Project Management - Control Plans

Basic Data

Table Category	INTTAB	Structure
Structure	DPR_TS_CTRLPLAN_H_DAT	Table Relationship Diagram
Short Description	Control Plan Data

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	IS_TEMPLATE	☐	DPR_TV_IS_TEMPLATE	CHAR1	CHAR	1	0	Template (Yes/No)
2	.INCLUDE	☐				0	0	Control Plan Header Attributes (External)
3	.INCLUDE	☐				0	0	Control Plan Header Attributes (Modifiable)
4	EXTERNAL_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
5	DESCRIPTION	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
6	.INCLUDE	☐				0	0	Control Plan Def. Attributes (Not Modifiable Externally)
7	GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
8	LAST_CHANGE_DATE	☐	DPR_TV_LAST_CHANGE_DATE		DATS	8	0	Date of Last Change
9	LAST_CHANGE_TIME	☐	DPR_TV_LAST_CHANGE_TIME		TIMS	6	0	Last Changed at
10	.INCLUDE	☐				0	0	Project Planning: Projects and Activities Include Structure
11	PROJECT_GUID	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
12	OBJECT_TYPE	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
13	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	CGPL_PRIO
14	ACTUALSTART	☐	CGPL_ACTUALSTART	BCOS_TSTMP	DEC	15	0	Actual Start Date
15	ACTUALFINISH	☐	CGPL_ACTUALFINISH	BCOS_TSTMP	DEC	15	0	Actual Finish Date
16	PLANSTART	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
17	PLANFINISH	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
18	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
19	MILESTONE	☐	CGPL_MILESTONE	CHAR1	CHAR	1	0	Milestone indicator
20	CONSTRAINT_TYPE	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
21	CONSTRAINT_TIME	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
22	CREATED_BY	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
23	CREATED_ON	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
24	CREATED_IN_BW	☐	CGPL_CREATED_BW	CHAR1	CHAR	1	0	Transfer Object to BW
25	CHANGED_BY	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
26	CHANGED_ON	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
27	UPDATED_IN_BW	☐	CGPL_UPDATED_BW	CHAR1	CHAR	1	0	Current Object in BW
28	BWIDENTIFIER	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
29	PLANGROUP	☐	CGPL_SEM_PLGRP		CHAR	4	0	Planning Profile Group
30	LATEST_START	☐	CGPL_LATEST_START	BCOS_TSTMP	DEC	15	0	Latest start
31	LATEST_FINISH	☐	CGPL_LATEST_FINISH	BCOS_TSTMP	DEC	15	0	Latest finish date
32	TOTAL_FLOAT	☐	CGPL_TOTAL_FLOAT	CGPL_FLOAT	DEC	8	2	Total Float
33	DURATION	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
34	DURATION_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
35	CALENDAR_ID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
36	CONSTR_TYPE_FIN	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
37	CONSTR_TIME_FIN	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
38	APPLICATION	☐	CGPL_APPLICATION_TYPE	CGPL_APPLICATION_TYPE	CHAR	3	0	Application in Project Planning	*
39	FORECAST_START	☐	CGPL_FORECAST_START	BCOS_TSTMP	DEC	15	0	Forecast Start
40	FORECAST_FINISH	☐	CGPL_FORECAST_FINISH	BCOS_TSTMP	DEC	15	0	Forecast Finish
41	.INCLUDE	☐				0	0	CP: Links with a Role
42	VERSION_NUMBER	☐	CGPL_TV_VERSION	CGPL_VERSION	CHAR	24	0	Version Number
43	TEMPLATE_ADMIN	☐	DPR_TV_TEMPLATE_ADMIN	SYSUUID	RAW	16	0	Template Responsible
44	TEMPLATE_GUID	☐	DPR_TV_ENTITY_GUID	DPR_ENTITY_GUID	RAW	16	0	Application Object GUID (Entity with Conversion Exit)
45	LAST_CHANGED_ON	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
46	LAST_CHANGED_BY	☐	DPR_TV_CHANGED_BY	XUBNAME	CHAR	12	0	Last Changed By	*
47	USE_QM_CHAR	☐	DPR_TV_CP_USE_QM_CHAR	DPR_CP_ACTIVE	CHAR	1	0	Master Insp. Characs in Quality Planning from an SAP System
48	GUID_CHAR	☐	DPR_TV_OBJECT_GUID_CHAR	SYSUUID_C	CHAR	32	0	Unique Object Key
49	CREATED_BY_NAME	☐	DPR_TV_CREATED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Created the Project Element
50	CHANGED_BY_NAME	☐	DPR_TV_CHANGED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Last Changed the Project Element
51	.INCLU-INT	☐				0	0	Control Plan Definition Attributes (Internal)
52	GUIDINT	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
53	EXTERNAL_IDINT	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
54	.INCLUDE	☐				0	0	Project Planning: Projects and Activities Include Structure
55	PROJECT_GUIDINT	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
56	OBJECT_TYPEINT	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
57	PRIORITYINT	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	CGPL_PRIO
58	ACTUALSTARTINT	☐	CGPL_ACTUALSTART	BCOS_TSTMP	DEC	15	0	Actual Start Date
59	ACTUALFINISHINT	☐	CGPL_ACTUALFINISH	BCOS_TSTMP	DEC	15	0	Actual Finish Date
60	PLANSTARTINT	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
61	PLANFINISHINT	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
62	COMPLETIONINT	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
63	MILESTONEINT	☐	CGPL_MILESTONE	CHAR1	CHAR	1	0	Milestone indicator
64	CONSTRAINT_TYPEINT	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
65	CONSTRAINT_TIMEINT	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
66	CREATED_BYINT	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
67	CREATED_ONINT	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
68	CREATED_IN_BWINT	☐	CGPL_CREATED_BW	CHAR1	CHAR	1	0	Transfer Object to BW
69	CHANGED_BYINT	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
70	CHANGED_ONINT	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
71	UPDATED_IN_BWINT	☐	CGPL_UPDATED_BW	CHAR1	CHAR	1	0	Current Object in BW
72	BWIDENTIFIERINT	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
73	PLANGROUPINT	☐	CGPL_SEM_PLGRP		CHAR	4	0	Planning Profile Group
74	LATEST_STARTINT	☐	CGPL_LATEST_START	BCOS_TSTMP	DEC	15	0	Latest start
75	LATEST_FINISHINT	☐	CGPL_LATEST_FINISH	BCOS_TSTMP	DEC	15	0	Latest finish date
76	TOTAL_FLOATINT	☐	CGPL_TOTAL_FLOAT	CGPL_FLOAT	DEC	8	2	Total Float
77	DURATIONINT	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
78	DURATION_UNITINT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
79	CALENDAR_IDINT	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
80	CONSTR_TYPE_FININT	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
81	CONSTR_TIME_FININT	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
82	APPLICATIONINT	☐	CGPL_APPLICATION_TYPE	CGPL_APPLICATION_TYPE	CHAR	3	0	Application in Project Planning	*
83	FORECAST_STARTINT	☐	CGPL_FORECAST_START	BCOS_TSTMP	DEC	15	0	Forecast Start
84	FORECAST_FINISHINT	☐	CGPL_FORECAST_FINISH	BCOS_TSTMP	DEC	15	0	Forecast Finish
85	.INCLUDE	☐				0	0	CP: Links with a Role
86	VERSION_NUMBERINT	☐	CGPL_TV_VERSION	CGPL_VERSION	CHAR	24	0	Version Number
87	TEMPLATE_ADMININT	☐	DPR_TV_TEMPLATE_ADMIN	SYSUUID	RAW	16	0	Template Responsible
88	TEMPLATE_GUIDINT	☐	DPR_TV_ENTITY_GUID	DPR_ENTITY_GUID	RAW	16	0	Application Object GUID (Entity with Conversion Exit)
89	LAST_CHANGED_ONINT	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
90	LAST_CHANGED_BYINT	☐	DPR_TV_CHANGED_BY	XUBNAME	CHAR	12	0	Last Changed By	*
91	USE_QM_CHARINT	☐	DPR_TV_CP_USE_QM_CHAR	DPR_CP_ACTIVE	CHAR	1	0	Master Insp. Characs in Quality Planning from an SAP System
92	TEXTS	☐	DPR_TT_TEXT_EXT		TTYP	0	0
93	VERSIONS	☐	DPR_TT_CTRLPLAN_V_DAT		TTYP	0	0
94	OBJECT_LINKS	☐	DPR_TT_OBJLINK_DAT		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DPR_TS_CTRLPLAN_H_DAT	PRIORITY	CGPL_PRIO	PRIORITY	KEY
2	DPR_TS_CTRLPLAN_H_DAT	PRIORITYINT	CGPL_PRIO	PRIORITY	KEY

History

Last changed by/on	SAP	20141109
SAP Release Created in	200