SAP ABAP Table DPR_TS_PROJECT_INT (Project Definition Attributes (Internal))

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	DPR_TS_PROJECT_INT	Table Relationship Diagram
Short Description	Project Definition Attributes (Internal)

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	GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
2	EXTERNAL_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
3	.INCLUDE	☐				0	0	Project Planning: Projects and Activities Include Structure
4	PROJECT_GUID	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
5	OBJECT_TYPE	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
6	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	CGPL_PRIO
7	ACTUALSTART	☐	CGPL_ACTUALSTART	BCOS_TSTMP	DEC	15	0	Actual Start Date
8	ACTUALFINISH	☐	CGPL_ACTUALFINISH	BCOS_TSTMP	DEC	15	0	Actual Finish Date
9	PLANSTART	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
10	PLANFINISH	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
11	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
12	MILESTONE	☐	CGPL_MILESTONE	CHAR1	CHAR	1	0	Milestone indicator
13	CONSTRAINT_TYPE	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
14	CONSTRAINT_TIME	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
15	CREATED_BY	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
16	CREATED_ON	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
17	CREATED_IN_BW	☐	CGPL_CREATED_BW	CHAR1	CHAR	1	0	Transfer Object to BW
18	CHANGED_BY	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
19	CHANGED_ON	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
20	UPDATED_IN_BW	☐	CGPL_UPDATED_BW	CHAR1	CHAR	1	0	Current Object in BW
21	BWIDENTIFIER	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
22	PLANGROUP	☐	CGPL_SEM_PLGRP		CHAR	4	0	Planning Profile Group
23	LATEST_START	☐	CGPL_LATEST_START	BCOS_TSTMP	DEC	15	0	Latest start
24	LATEST_FINISH	☐	CGPL_LATEST_FINISH	BCOS_TSTMP	DEC	15	0	Latest finish date
25	TOTAL_FLOAT	☐	CGPL_TOTAL_FLOAT	CGPL_FLOAT	DEC	8	2	Total Float
26	DURATION	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
27	DURATION_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
28	CALENDAR_ID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
29	CONSTR_TYPE_FIN	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
30	CONSTR_TIME_FIN	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
31	APPLICATION	☐	CGPL_APPLICATION_TYPE	CGPL_APPLICATION_TYPE	CHAR	3	0	Application in Project Planning	*
32	FORECAST_START	☐	CGPL_FORECAST_START	BCOS_TSTMP	DEC	15	0	Forecast Start
33	FORECAST_FINISH	☐	CGPL_FORECAST_FINISH	BCOS_TSTMP	DEC	15	0	Forecast Finish
34	.INCLUDE	☐				0	0	Include for Processing Status
35	PROC_STATUS_OWN	☐	DPR_TV_PROC_STATUS_OWN	DPR_PROC_STATUS	CHAR	2	0	Object Processing Status
36	PROC_STATUS_SUP	☐	DPR_TV_PROC_STATUS_SUP	DPR_PROC_STATUS	CHAR	2	0	Processing Status of Higher-Level Object
37	.INCLUDE	☐				0	0	Include for Project Definition Attributes
38	PROJECT_ID	☐	DPR_TV_PROJECT_ID	CGPL_EXTID	CHAR	24	0	Project Number
39	VERSION_NUMBER	☐	CGPL_TV_VERSION	CGPL_VERSION	CHAR	24	0	Version Number
40	PRO_CATEGORY	☐	DPR_TV_PRO_CATEGORY	DPR_PROJECT_CATEGORY	CHAR	1	0	Project Category	DPR_PRO_CATEG
41	PRO_TYPE	☐	DPR_TV_PRO_TYPE	DPR_TYPE	CHAR	15	0	Project Type	DPR_PRO_TYPE
42	CAUSE	☐	DPR_TV_CAUSE	DPR_CAUSE	CHAR	15	0	Reason for Project	DPR_CAUSE
43	GROUPING	☐	DPR_TV_GROUPING		CHAR	40	0	Grouping
44	SEARCH_FIELD	☐	DPR_TV_SEARCH_FIELD		CHAR	40	0	Search Field
45	MASTER_LANGUAGE	☐	DPR_TV_MASTER_LANGUAGE	LANGU	LANG	1	0	Text Language
46	TEMPLATE_ADMIN	☐	DPR_TV_TEMPLATE_ADMIN	SYSUUID	RAW	16	0	Template Responsible	*
47	TEMPLATE_GUID	☐	DPR_TV_ENTITY_GUID	DPR_ENTITY_GUID	RAW	16	0	Application Object GUID (Entity with Conversion Exit)	DPR_PROJECT
48	RELEASED_ON	☐	DPR_TV_TIMESTAMP	BCOS_TSTMP	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit)
49	RESCHEDULE	☐	DPR_TV_RESCHEDULE	DPR_BOOLEAN	CHAR	1	0	Rescheduling Required
50	SCHEDULE_IND	☐	PPM_SCHEDULE_INDICATOR	PPM_SCHEDULE_INDICATOR	CHAR	1	0	Status of Scheduling Data
51	SCHEDULE_TYPE	☐	DPR_TV_SCHEDULE_TYPE	DPR_SCHEDULE_TYPE	CHAR	1	0	Scheduling Type
52	SCHED_BEHAVIOUR	☐	DPR_TV_SCHED_BEHAVIOUR	DPR_SCHEDULE_BEHAVIOUR	CHAR	1	0	Scheduling Behavior
53	SUMMARY_TASKS	☐	DPR_TV_SUMMARY_TASKS	BOOLE	CHAR	1	0	Task Nodes Are Summary Tasks
54	PERIODTYPE	☐	DPR_TV_PERIOD_TYPE	DPR_PERIOD_TYPE	NUMC	2	0	Period Type (Weekly/Monthly/Generic Interval)
55	ALLOCATION_UNIT	☐	DPR_TV_ALLOCATION_UNIT	MEINS	UNIT	3	0	Distribution Unit	*
56	LOCATION	☐	DPR_TV_LOCATION	DPR_LOCATION	CHAR	4	0	Location	*
57	CUSTOMER	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
58	SOLD_TO_PARTY	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
59	LAST_CHANGED_ON	☐	DPR_TV_TIMESTAMP	BCOS_TSTMP	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit)
60	LAST_CHANGED_BY	☐	DPR_TV_LAST_CHANGED_BY	USNAM	CHAR	12	0	User Who Changed Project Data Last
61	SORT_OVERALL	☐	DPR_TV_SORT_OVERALL	CHAR1	CHAR	1	0	Sort Mode
62	.INCLUDE	☐				0	0	Key Combination for Responsible Organization
63	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	*
64	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
65	RESP_ORG_UNIT	☐	DPR_TV_RESP_ORGANIZATION	HROBJID	NUMC	8	0	Organization Responsible	*
66	STAT_PROFILE_PRO	☐	DPR_TV_STAT_PROFILE_PRO	J_STSMA	CHAR	8	0	Status Profile Template	*
67	ACT_WORK_EFFORT	☐	DPR_TV_ACT_WORK	DPR_WORK_LONG	QUAN	16	3	Confirmation (Insternal Display)
68	ACT_WORK_UNIT	☐	DPR_TV_UNIT	MEINS	UNIT	3	0	Unit	*
69	ACT_WRK_UNIT_EXT	☐	DPR_TV_UNIT	MEINS	UNIT	3	0	Unit	*
70	CONF_GUID	☐	DPR_TV_CONF_GUID		RAW	16	0	GUID of a Confirmation Document
71	ACTUAL2PLAN	☐	DPR_TV_ACTUAL2PLAN	DPR_ACTUAL2PLAN	CHAR	1	0	Overwrite Planned Dates by Actual Dates
72	.INCLUDE	☐				0	0	Include for Extended Attributes of Project Definition
73	EA_DUMMY	☐	DPR_TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced Proj. Mgmt Attributes
74	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DPR_TS_PROJECT_INT	CAUSE	DPR_CAUSE	CAUSE	REF
2	DPR_TS_PROJECT_INT	PRIORITY	CGPL_PRIO	PRIORITY	KEY
3	DPR_TS_PROJECT_INT	PRO_CATEGORY	DPR_PRO_CATEG	PRO_CATEGORY	REF	1	CN
4	DPR_TS_PROJECT_INT	PRO_TYPE	DPR_PRO_TYPE	PRO_TYPE	REF	1	CN
5	DPR_TS_PROJECT_INT	TEMPLATE_GUID	DPR_PROJECT	GUID	REF	1	CN

History

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