SAP ABAP Table DPR_TS_PHASE_DAT (Phase Data)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PRO-STR (Application Component) Structure
     ⤷ DEVELOPMENT_PROJECTS_PHASE (Package) Project Management - Phases

Basic Data

Table Category	INTTAB	Structure
Structure	DPR_TS_PHASE_DAT	Table Relationship Diagram
Short Description	Phase 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	Phase in External Display
3	.INCLUDE	☐				0	0	Modifiable Phase Attributes
4	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	CGPL_PRIO
5	DURATION	☐	DPR_TV_DURATION		QUAN	4	0	Processing Time
6	CALENDAR_ID	☐	DPR_TV_CALENDAR_ID	WFCID	CHAR	2	0	Calendar	*
7	PHASE_ID	☐	DPR_TV_PHASE_ID		CHAR	24	0	Phase Number
8	PHA_TYPE	☐	DPR_TV_PHA_TYPE	DPR_TYPE	CHAR	15	0	Phase Type	DPR_PHA_TYPE
9	GROUPING	☐	DPR_TV_GROUPING		CHAR	40	0	Grouping
10	SEARCH_FIELD	☐	DPR_TV_SEARCH_FIELD		CHAR	40	0	Search Field
11	DESCRIPTION	☐	DPR_TV_NAME	TEXT40	CHAR	40	0	Project Element Name
12	CONSTRAINT_TYPE	☐	DPR_TV_START_CONSTRAINT	DPR_START_CONSTRAINT	CHAR	1	0	Constraint on Start Date
13	START_DATE_FIX	☐	DPR_TV_START_DATE_FIX		DATS	8	0	Fixed Start Date
14	CONSTR_TYPE_FIN	☐	DPR_TV_FINISH_CONSTRAINT	DPR_FINISH_CONSTRAINT	CHAR	1	0	Constraint on Finish Date
15	FINISH_DATE_FIX	☐	DPR_TV_FINISH_DATE_FIX		DATS	8	0	Fixed Predefined Finish Date
16	STAT_PROFILE_PHA	☐	DPR_TV_STAT_PROFILE_PHA	J_STSMA	CHAR	8	0	Status Profile Template	TJ21
17	PREDEC_PHASE_NUMBER	☐	DPR_TV_OBJECT_GUID_CHAR	SYSUUID_C	CHAR	32	0	Unique Object Key
18	FORECASTED_START	☐	DPR_TV_FORECASTED_START		DATS	8	0	Forecasted Start Date
19	FORECASTED_FINISH	☐	DPR_TV_FORECASTED_FINISH		DATS	8	0	Forecasted Finish Date
20	EXTENDED_ATTRIBUTES	☐	DPR_TS_PHASE_EXTENDED_ATTR		STRU	0	0
21	EA_DUMMY	☐	DPR_TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced Proj. Mgmt Attributes
22	.INCLUDE	☐				0	0
23	.INCLUDE	☐				0	0	Non-Modifiable Phase Attributes
24	GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
25	VERSION_NUMBER	☐	CGPL_TV_VERSION	CGPL_VERSION	CHAR	24	0	Version Number
26	SCHEDULED_START	☐	DPR_TV_SCHEDULED_START		DATS	8	0	Calculated Start Date
27	SCHEDULED_FINISH	☐	DPR_TV_SCHEDULED_FINISH		DATS	8	0	Calculated Finish Date
28	CREATED_BY	☐	DPR_TV_CREATED_BY	XUBNAME	CHAR	12	0	Created By	*
29	CREATED_BY_NAME	☐	DPR_TV_CREATED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Created the Project Element
30	CREATED_ON	☐	DPR_TV_CREATED_ON_DATE		DATS	8	0	Created On
31	CHANGED_BY	☐	DPR_TV_CHANGED_BY	XUBNAME	CHAR	12	0	Last Changed By	*
32	CHANGED_BY_NAME	☐	DPR_TV_CHANGED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Last Changed the Project Element
33	CHANGED_ON	☐	DPR_TV_CHANGED_ON_DATE		DATS	8	0	Changed On
34	SCHEDULED_START_LATE	☐	DPR_TV_SCHEDULED_START_LATE		DATS	8	0	Latest Start Date
35	SCHEDULED_FINISH_LATE	☐	DPR_TV_SCHEDULED_FINISH_LATE		DATS	8	0	Latest Finish Date
36	TOTAL_FLOAT	☐	DPR_TV_TOTAL_FLOAT		QUAN	8	0	Total Float
37	DURATION_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	T006
38	RESCHEDULE	☐	DPR_TV_RESCHEDULE	DPR_BOOLEAN	CHAR	1	0	Rescheduling Required
39	GUID_CHAR	☐	DPR_TV_OBJECT_GUID_CHAR	SYSUUID_C	CHAR	32	0	Unique Object Key
40	.INCLUDE	☐				0	0	Development Projects: Status (External)
41	OBJNR	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
42	ISTAT	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status	*
43	ESTAT	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
44	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
45	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
46	TXT04	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
47	TXT30	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
48	STATTXT	☐	DPR_TV_STATUS_TXT		STRG	0	0	Concatenated Status Text of an Object
49	PHA_TYPE_TEXT	☐	DPR_TV_PHA_TYPE_TEXT	DPR_TEXT	CHAR	40	0	Phase Type Text
50	RELEASE_DATE	☐	DPR_TV_RELEASE_DATE	DATS	DATS	8	0	Release Date
51	CALENDER_TEXT	☐	SC_TXTFAC	TEXT40	CHAR	40	0	Factory calendar name
52	THRESHOLD_TEXT	☐	EVE_TV_THRESHOLD_DESCRIPTION	EVE_DESCRIPTION	CHAR	40	0	Threshold Value Description
53	SEVERITY_TEXT	☐	EVE_TV_SEVERITY_DESCRIPTION	EVE_DESCRIPTION	CHAR	40	0	Severity of Threshold Value Description
54	DURATION_UNIT_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
55	.INCLU-INT	☐				0	0	Phase Attributes (Internal)
56	GUIDINT	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
57	EXTERNAL_IDINT	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
58	.INCLUDE	☐				0	0	Project Planning: Projects and Activities Include Structure
59	PROJECT_GUIDINT	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
60	OBJECT_TYPEINT	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
61	PRIORITYINT	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	CGPL_PRIO
62	ACTUALSTARTINT	☐	CGPL_ACTUALSTART	BCOS_TSTMP	DEC	15	0	Actual Start Date
63	ACTUALFINISHINT	☐	CGPL_ACTUALFINISH	BCOS_TSTMP	DEC	15	0	Actual Finish Date
64	PLANSTARTINT	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
65	PLANFINISHINT	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
66	COMPLETIONINT	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
67	MILESTONEINT	☐	CGPL_MILESTONE	CHAR1	CHAR	1	0	Milestone indicator
68	CONSTRAINT_TYPEINT	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
69	CONSTRAINT_TIMEINT	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
70	CREATED_BYINT	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
71	CREATED_ONINT	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
72	CREATED_IN_BWINT	☐	CGPL_CREATED_BW	CHAR1	CHAR	1	0	Transfer Object to BW
73	CHANGED_BYINT	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
74	CHANGED_ONINT	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
75	UPDATED_IN_BWINT	☐	CGPL_UPDATED_BW	CHAR1	CHAR	1	0	Current Object in BW
76	BWIDENTIFIERINT	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
77	PLANGROUPINT	☐	CGPL_SEM_PLGRP		CHAR	4	0	Planning Profile Group
78	LATEST_STARTINT	☐	CGPL_LATEST_START	BCOS_TSTMP	DEC	15	0	Latest start
79	LATEST_FINISHINT	☐	CGPL_LATEST_FINISH	BCOS_TSTMP	DEC	15	0	Latest finish date
80	TOTAL_FLOATINT	☐	CGPL_TOTAL_FLOAT	CGPL_FLOAT	DEC	8	2	Total Float
81	DURATIONINT	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
82	DURATION_UNITINT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
83	CALENDAR_IDINT	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
84	CONSTR_TYPE_FININT	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
85	CONSTR_TIME_FININT	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
86	APPLICATIONINT	☐	CGPL_APPLICATION_TYPE	CGPL_APPLICATION_TYPE	CHAR	3	0	Application in Project Planning	*
87	FORECAST_STARTINT	☐	CGPL_FORECAST_START	BCOS_TSTMP	DEC	15	0	Forecast Start
88	FORECAST_FINISHINT	☐	CGPL_FORECAST_FINISH	BCOS_TSTMP	DEC	15	0	Forecast Finish
89	.INCLUDE	☐				0	0	Include for Processing Status
90	PROC_STATUS_OWNINT	☐	DPR_TV_PROC_STATUS_OWN	DPR_PROC_STATUS	CHAR	2	0	Object Processing Status
91	PROC_STATUS_SUPINT	☐	DPR_TV_PROC_STATUS_SUP	DPR_PROC_STATUS	CHAR	2	0	Processing Status of Higher-Level Object
92	.INCLUDE	☐				0	0	Include for Phase Attributes
93	PHASE_IDINT	☐	DPR_TV_PHASE_ID		CHAR	24	0	Phase Number
94	VERSION_NUMBERINT	☐	CGPL_TV_VERSION	CGPL_VERSION	CHAR	24	0	Version Number
95	PHA_TYPEINT	☐	DPR_TV_PHA_TYPE	DPR_TYPE	CHAR	15	0	Phase Type	DPR_PHA_TYPE
96	GROUPINGINT	☐	DPR_TV_GROUPING		CHAR	40	0	Grouping
97	SEARCH_FIELDINT	☐	DPR_TV_SEARCH_FIELD		CHAR	40	0	Search Field
98	RELEASED_ONINT	☐	DPR_TV_TIMESTAMP	BCOS_TSTMP	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit)
99	RESCHEDULEINT	☐	DPR_TV_RESCHEDULE	DPR_BOOLEAN	CHAR	1	0	Rescheduling Required
100	STAT_PROFILE_PHAINT	☐	DPR_TV_STAT_PROFILE_PHA	J_STSMA	CHAR	8	0	Status Profile Template	*
101	SCHEDULE_INDINT	☐	PPM_SCHEDULE_INDICATOR	PPM_SCHEDULE_INDICATOR	CHAR	1	0	Status of Scheduling Data
102	SCHED_BEHAVIOURINT	☐	DPR_TV_SCHED_BEHAVIOUR	DPR_SCHEDULE_BEHAVIOUR	CHAR	1	0	Scheduling Behavior
103	.INCLUDE	☐				0	0	Include for Extended Attributes of Phase
104	EA_DUMMYINT	☐	DPR_TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced Proj. Mgmt Attributes
105	.INCLUDE	☐				0	0
106	STATUS	☐	DPR_TT_STATUS_EXT		TTYP	0	0
107	TEXTS	☐	DPR_TT_TEXT_EXT		TTYP	0	0
108	APPROVALS	☐	DPR_TT_APPROVAL_DAT		TTYP	0	0
109	CHECKLIST_REFERENCES	☐	DPR_TT_CHECKLIST_REFERENCE_DAT		TTYP	0	0
110	DOCUMENTS	☐	DPR_TT_DOCUMENT_DAT		TTYP	0	0
111	OBJECT_LINKS	☐	DPR_TT_OBJLINK_DAT		TTYP	0	0
112	PARTICIPANT_LINKS	☐	DPR_TT_ENTITY_LINK_DAT		TTYP	0	0
113	TASKS	☐	DPR_TT_TASK_DAT		TTYP	0	0
114	COLLABORATIONS	☐	DPR_TT_COLL_LINK_DAT		TTYP	0	0
115	CHECKLISTS	☐	DPR_TT_CHECKLIST_DAT		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DPR_TS_PHASE_DAT	DURATION_UNIT	T006	MSEHI
2	DPR_TS_PHASE_DAT	PHA_TYPE	DPR_PHA_TYPE	PHA_TYPE	REF	1	CN
3	DPR_TS_PHASE_DAT	PHA_TYPEINT	DPR_PHA_TYPE	PHA_TYPE	REF	1	CN
4	DPR_TS_PHASE_DAT	PRIORITY	CGPL_PRIO	PRIORITY	KEY	1	CN
5	DPR_TS_PHASE_DAT	PRIORITYINT	CGPL_PRIO	PRIORITY	KEY
6	DPR_TS_PHASE_DAT	STAT_PROFILE_PHA	TJ21	STSMA	REF	1	CN

History

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