SAP ABAP Table DPR_TS_PART_PRT (Project Participant Data)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PRO-RES (Application Component) Resources
     ⤷ DEVELOPMENT_PROJECTS_TEAM (Package) Project Management - Team/Participants/Roles

Basic Data

Table Category	INTTAB	Structure
Structure	DPR_TS_PART_PRT	Table Relationship Diagram
Short Description	Project Participant 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	Role Attributes (External)
3	.INCLUDE	☐				0	0	Role Attributes
4	GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
5	VERSION_NUMBER	☐	CGPL_TV_VERSION	CGPL_VERSION	CHAR	24	0	Version Number
6	SCHEDULED_START	☐	DPR_TV_SCHEDULED_START		DATS	8	0	Calculated Start Date
7	SCHEDULED_FINISH	☐	DPR_TV_SCHEDULED_FINISH		DATS	8	0	Calculated Finish Date
8	COST_RATE_DEF	☐	DPR_TV_COST_VALUE	PREIS	CURR	11	2	Cost per Activity Unit
9	REVENUE_RATE_DEF	☐	DPR_TV_REVENUE_VALUE	PREIS	CURR	11	2	Revenues per Activity Unit
10	WORK_UNIT_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
11	TIME_UNIT_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
12	ACT_WRK_UNIT_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
13	CONCRETE_ROLE	☐	DPR_TV_CONCRETE_ROLE	CHAR1	CHAR	1	0	Shadow Role (= Concrete Role)
14	AREA	☐	DPR_TV_AREA	DPR_AREA	CHAR	4	0	Area	*
15	AREA_TEXT	☐	DPR_TV_AREA_TEXT	TEXT30	CHAR	30	0	Area Text
16	.INCLUDE	☐				0	0	Development Projects: Status (External)
17	OBJNR	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
18	ISTAT	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status	*
19	ESTAT	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
20	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
21	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
22	TXT04	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
23	TXT30	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
24	STATTXT	☐	DPR_TV_STATUS_TXT		STRG	0	0	Concatenated Status Text of an Object
25	.INCLUDE	☐				0	0	Role Attributes
26	SORT_NUMBER	☐	DPR_TV_SORT_NUMBER		NUMC	5	0	Sort Number
27	PARTICIPANT_ROLE	☐	DPR_TV_PARTICIPANT_ROLE	DPR_PARTICIPANT_ROLE	CHAR	15	0	Role Type for Projects	DPR_PART_ROLE
28	BEG_TMSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
29	END_TMSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
30	WORK_EFFORT	☐	DPR_TV_EFFORT	DPR_WORK	QUAN	9	2	Demand or Assigned Effort
31	WORK_UNIT	☐	DPR_TV_EFFORT_UNIT	MEINS	UNIT	3	0	Unit for Demand or Effort	*
32	C_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
33	PARTNER_ROLE	☐	DPR_TV_BU_ROLE	BU_RLTYP	CHAR	6	0	BP Role	*
34	VACANT	☐	DPR_TV_VACANT	DPR_BOOLEAN	CHAR	1	0	Vacant Checkbox of Role
35	CAND_IN_WORKLIST	☐	DPR_TV_CANDIDATE_IN_WORKLIST	DPR_BOOLEAN	CHAR	1	0	Role Is Displayed in Candidate Manager's Worklist
36	STAT_PROFILE_PRT	☐	DPR_TV_STAT_PROFILE_PRT	J_STSMA	CHAR	8	0	Status Profile Template	*
37	VC_BUPA_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
38	RATE	☐	DPR_TV_RATE	DPR_RATE_TYPE	CHAR	15	0	Cost Rate/Revenue Rate for Project Costing	*
39	REVENUE_RATE	☐	DPR_TV_REVENUE_RATE_MANUAL	PREIS	CURR	11	2	Different Revenue
40	CURRENCY	☐	WAERS_CURC	WAERS	CUKY	5	0	Currency Key	*
41	COST_RATE	☐	DPR_TV_COST_RATE_MANUAL	PREIS	CURR	11	2	Different Costs
42	CURRENCY_COST	☐	WAERS_CURC	WAERS	CUKY	5	0	Currency Key	*
43	TIME_UNIT	☐	DPR_TV_TIME_UNIT_MANUAL	MEINS	UNIT	3	0	Activity Unit for Deviating Costs and Revenues	*
44	ACT_WRK_EFFORT_EXT	☐	DPR_TV_ACT_WORK_EXT	DPR_WORK	QUAN	9	2	Confirmation
45	ACT_WRK_UNIT_EXT	☐	DPR_TV_ACT_WRK_UNIT	MEINS	UNIT	3	0	Confirmation Unit	*
46	CONF_GUID	☐	DPR_TV_CONF_GUID		RAW	16	0	GUID of a Confirmation Document
47	.INCLUDE	☐				0	0	Include for Enhanced Attribute: Role (Participant)
48	EA_DUMMY	☐	DPR_TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced Proj. Mgmt Attributes
49	.INCLUDE	☐				0	0
50	.INCLUDE	☐				0	0
51	EXTERNAL_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
52	BEG_DATE	☐	BEGDA	DATUM	DATS	8	0	Start Date
53	END_DATE	☐	ENDDA	DATUM	DATS	8	0	End Date
54	DESCRIPTION	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
55	PARTICIPANT_ROLE_TEXT	☐	DPR_TV_PARTICIPANT_ROLE_TEXT	DPR_TEXT	CHAR	40	0	Name of Role Type
56	PARTICIPANT_ID	☐	DPR_TV_PART_ID	CHAR24	CHAR	24	0	Role ID
57	ROLE_FUNCTION_ID	☐	DPR_TV_ROLE_FUNCTION_ID	DPR_ROLE_FUNCTION_ID	CHAR	15	0	ID of Role Function	DPR_ROLE_FUNC
58	LOCATION	☐	DPR_TV_LOCATION	DPR_LOCATION	CHAR	4	0	Location	*
59	URGENCY	☐	DPR_TV_URGENCY	DPR_URGENCY	CHAR	2	0	Urgency
60	.INCLU-INT	☐				0	0	Role Attributes (Internal)
61	GUIDINT	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
62	EXTERNAL_IDINT	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
63	.INCLUDE	☐				0	0	Project Planning: Projects and Activities Include Structure
64	PROJECT_GUIDINT	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
65	OBJECT_TYPEINT	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
66	PRIORITYINT	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	CGPL_PRIO
67	ACTUALSTARTINT	☐	CGPL_ACTUALSTART	BCOS_TSTMP	DEC	15	0	Actual Start Date
68	ACTUALFINISHINT	☐	CGPL_ACTUALFINISH	BCOS_TSTMP	DEC	15	0	Actual Finish Date
69	PLANSTARTINT	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
70	PLANFINISHINT	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
71	COMPLETIONINT	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
72	MILESTONEINT	☐	CGPL_MILESTONE	CHAR1	CHAR	1	0	Milestone indicator
73	CONSTRAINT_TYPEINT	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
74	CONSTRAINT_TIMEINT	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
75	CREATED_BYINT	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
76	CREATED_ONINT	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
77	CREATED_IN_BWINT	☐	CGPL_CREATED_BW	CHAR1	CHAR	1	0	Transfer Object to BW
78	CHANGED_BYINT	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
79	CHANGED_ONINT	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
80	UPDATED_IN_BWINT	☐	CGPL_UPDATED_BW	CHAR1	CHAR	1	0	Current Object in BW
81	BWIDENTIFIERINT	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
82	PLANGROUPINT	☐	CGPL_SEM_PLGRP		CHAR	4	0	Planning Profile Group
83	LATEST_STARTINT	☐	CGPL_LATEST_START	BCOS_TSTMP	DEC	15	0	Latest start
84	LATEST_FINISHINT	☐	CGPL_LATEST_FINISH	BCOS_TSTMP	DEC	15	0	Latest finish date
85	TOTAL_FLOATINT	☐	CGPL_TOTAL_FLOAT	CGPL_FLOAT	DEC	8	2	Total Float
86	DURATIONINT	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
87	DURATION_UNITINT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
88	CALENDAR_IDINT	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
89	CONSTR_TYPE_FININT	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
90	CONSTR_TIME_FININT	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
91	APPLICATIONINT	☐	CGPL_APPLICATION_TYPE	CGPL_APPLICATION_TYPE	CHAR	3	0	Application in Project Planning	*
92	FORECAST_STARTINT	☐	CGPL_FORECAST_START	BCOS_TSTMP	DEC	15	0	Forecast Start
93	FORECAST_FINISHINT	☐	CGPL_FORECAST_FINISH	BCOS_TSTMP	DEC	15	0	Forecast Finish
94	.INCLUDE	☐				0	0	Include for Processing Status
95	PROC_STATUS_OWNINT	☐	DPR_TV_PROC_STATUS_OWN	DPR_PROC_STATUS	CHAR	2	0	Object Processing Status
96	PROC_STATUS_SUPINT	☐	DPR_TV_PROC_STATUS_SUP	DPR_PROC_STATUS	CHAR	2	0	Processing Status of Higher-Level Object
97	.INCLUDE	☐				0	0	Role Attributes
98	SORT_NUMBERINT	☐	DPR_TV_SORT_NUMBER		NUMC	5	0	Sort Number
99	VERSION_NUMBERINT	☐	CGPL_TV_VERSION	CGPL_VERSION	CHAR	24	0	Version Number
100	PARTICIPANT_ROLEINT	☐	DPR_TV_PARTICIPANT_ROLE	DPR_PARTICIPANT_ROLE	CHAR	15	0	Role Type for Projects	DPR_PART_ROLE
101	BEG_TMSTMPINT	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
102	END_TMSTMPINT	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
103	WORK_EFFORTINT	☐	DPR_TV_EFFORT	DPR_WORK	QUAN	9	2	Demand or Assigned Effort
104	WORK_UNITINT	☐	DPR_TV_EFFORT_UNIT	MEINS	UNIT	3	0	Unit for Demand or Effort	*
105	C_OBJIDINT	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
106	PARTNER_ROLEINT	☐	DPR_TV_BU_ROLE	BU_RLTYP	CHAR	6	0	BP Role	*
107	VACANTINT	☐	DPR_TV_VACANT	DPR_BOOLEAN	CHAR	1	0	Vacant Checkbox of Role
108	CAND_IN_WORKLISTINT	☐	DPR_TV_CANDIDATE_IN_WORKLIST	DPR_BOOLEAN	CHAR	1	0	Role Is Displayed in Candidate Manager's Worklist
109	STAT_PROFILE_PRTINT	☐	DPR_TV_STAT_PROFILE_PRT	J_STSMA	CHAR	8	0	Status Profile Template	*
110	VC_BUPA_GUIDINT	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
111	RATEINT	☐	DPR_TV_RATE	DPR_RATE_TYPE	CHAR	15	0	Cost Rate/Revenue Rate for Project Costing	*
112	REVENUE_RATEINT	☐	DPR_TV_REVENUE_RATE_MANUAL	PREIS	CURR	11	2	Different Revenue
113	CURRENCYINT	☐	WAERS_CURC	WAERS	CUKY	5	0	Currency Key	*
114	COST_RATEINT	☐	DPR_TV_COST_RATE_MANUAL	PREIS	CURR	11	2	Different Costs
115	CURRENCY_COSTINT	☐	WAERS_CURC	WAERS	CUKY	5	0	Currency Key	*
116	TIME_UNITINT	☐	DPR_TV_TIME_UNIT_MANUAL	MEINS	UNIT	3	0	Activity Unit for Deviating Costs and Revenues	*
117	ACT_WORK_EFFORTINT	☐	DPR_TV_ACT_WORK	DPR_WORK_LONG	QUAN	16	3	Confirmation (Insternal Display)
118	ACT_WORK_UNITINT	☐	DPR_TV_ACT_WRK_UNIT	MEINS	UNIT	3	0	Confirmation Unit	*
119	ACT_WRK_UNIT_EXTINT	☐	DPR_TV_ACT_WRK_UNIT	MEINS	UNIT	3	0	Confirmation Unit	*
120	CONF_GUIDINT	☐	DPR_TV_CONF_GUID		RAW	16	0	GUID of a Confirmation Document
121	CONCRETE_ROLEINT	☐	DPR_TV_CONCRETE_ROLE	CHAR1	CHAR	1	0	Shadow Role (= Concrete Role)
122	PARTICIPANT_IDINT	☐	DPR_TV_PART_ID	CHAR24	CHAR	24	0	Role ID
123	URGENCYINT	☐	DPR_TV_URGENCY	DPR_URGENCY	CHAR	2	0	Urgency
124	ROLE_FUNCTION_IDINT	☐	DPR_TV_ROLE_FUNCTION_ID	DPR_ROLE_FUNCTION_ID	CHAR	15	0	ID of Role Function	DPR_ROLE_FUNC
125	LOCATIONINT	☐	DPR_TV_LOCATION	DPR_LOCATION	CHAR	4	0	Location	DPR_LOCATION
126	STAFF_PERCENTINT	☐	DPR_TV_STAFF_PERCENT	NUMC3	NUMC	3	0	Percent Staffed
127	.INCLUDE	☐				0	0	Include for Enhanced Attribute: Role (Participant)
128	EA_DUMMYINT	☐	DPR_TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced Proj. Mgmt Attributes
129	.INCLUDE	☐				0	0
130	.INCLUDE	☐				0	0
131	TEXTS	☐	DPR_TT_TEXT_EXT		TTYP	0	0
132	BUPA_LINKS	☐	DPR_TT_BUPA_LINK_PRT		TTYP	0	0
133	BUPA_FAVOS	☐	DPR_TT_BUPA_FAVO_PRT		TTYP	0	0
134	SKILLS	☐	DPR_TT_SKILL_PRT		TTYP	0	0
135	ENTITY_LINKS	☐	DPR_TT_ENTITY_LINK_PRT		TTYP	0	0
136	DOCUMENTS	☐	DPR_TT_DOCUMENT_PRT		TTYP	0	0
137	PART_DIST	☐	DPR_TT_PART_DIST_PRT		TTYP	0	0
138	BUPA_DIST	☐	DPR_TT_BUPA_DIST_PRT		TTYP	0	0
139	OBJECT_LINKS	☐	DPR_TT_OBJLINK_PRT		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DPR_TS_PART_PRT	LOCATIONINT	DPR_LOCATION	LOCATION	REF
2	DPR_TS_PART_PRT	PARTICIPANT_ROLE	DPR_PART_ROLE	PARTICIPANT_ROLE
3	DPR_TS_PART_PRT	PARTICIPANT_ROLEINT	DPR_PART_ROLE	PARTICIPANT_ROLE
4	DPR_TS_PART_PRT	PRIORITYINT	CGPL_PRIO	PRIORITY	KEY
5	DPR_TS_PART_PRT	ROLE_FUNCTION_ID	DPR_ROLE_FUNC	ROLE_FUNC_ID
6	DPR_TS_PART_PRT	ROLE_FUNCTION_IDINT	DPR_ROLE_FUNC	ROLE_FUNC_ID	REF

History

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