SAP ABAP Table DPR_TS_DX_ROLE (Excel Upload: Role Data)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PRO-EXT-API (Application Component) BAPI Interface for cProjects
     ⤷ DEVELOPMENT_PROJECTS_API (Package) API for Project Management

Basic Data

Table Category	INTTAB	Structure
Structure	DPR_TS_DX_ROLE	Table Relationship Diagram
Short Description	Excel Upload: Role 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	PROJECT_NUMBER	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
2	.INCLUDE	☐				0	0	API: Attributes of a Role
3	PARENT_GUID	☐	DPR_TV_OBJECT_GUID_CHAR	SYSUUID_C	CHAR	32	0	Unique Object Key
4	SORT_NUMBER	☐	DPR_TV_SORT_NUMBER		NUMC	5	0	Sort Number
5	ROLE_TYPE	☐	DPR_TV_PARTICIPANT_ROLE	DPR_PARTICIPANT_ROLE	CHAR	15	0	Role Type for Projects	DPR_PART_ROLE
6	WORK_EFFORT	☐	DPR_TV_EFFORT	DPR_WORK	QUAN	9	2	Demand or Assigned Effort
7	WORK_UNIT	☐	DPR_TV_EFFORT_UNIT	MEINS	UNIT	3	0	Unit for Demand or Effort	*
8	WORK_UNIT_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
9	PARTNER_ROLE	☐	DPR_TV_BU_ROLE	BU_RLTYP	CHAR	6	0	BP Role	*
10	VACANT	☐	DPR_TV_VACANT	DPR_BOOLEAN	CHAR	1	0	Vacant Checkbox of Role
11	VACANCY_CONTACT	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
12	RATE	☐	DPR_TV_RATE	DPR_RATE_TYPE	CHAR	15	0	Cost Rate/Revenue Rate for Project Costing	*
13	REVENUE_RATE	☐	DPR_TV_REVENUE_RATE_MANUAL	PREIS	CURR	11	2	Different Revenue
14	REVENUE_RATE_DEF	☐	DPR_TV_REVENUE_VALUE	PREIS	CURR	11	2	Revenues per Activity Unit
15	CURRENCY	☐	WAERS_CURC	WAERS	CUKY	5	0	Currency Key	*
16	COST_RATE	☐	DPR_TV_COST_RATE_MANUAL	PREIS	CURR	11	2	Different Costs
17	COST_RATE_DEF	☐	DPR_TV_COST_VALUE	PREIS	CURR	11	2	Cost per Activity Unit
18	CURRENCY_COST	☐	WAERS_CURC	WAERS	CUKY	5	0	Currency Key	*
19	ACTUAL_WORK	☐	DPR_TV_ACT_WORK_EXT	DPR_WORK	QUAN	9	2	Confirmation
20	ACTUAL_WORK_UNIT	☐	DPR_TV_ACT_WRK_UNIT	MEINS	UNIT	3	0	Confirmation Unit	*
21	ACTUAL_WORK_UNIT_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
22	BEGIN_DATE	☐	DPR_TV_BEGDATE	DATS	DATS	8	0	Valid-From Date
23	END_DATE	☐	DPR_TV_ENDDATE	DATS	DATS	8	0	Valid-To Date
24	CALCULATED_BEGIN	☐	DPR_TV_SCHEDULED_START		DATS	8	0	Calculated Start Date
25	CALCULATED_END	☐	DPR_TV_SCHEDULED_FINISH		DATS	8	0	Calculated Finish Date
26	EXTERNAL_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
27	PARTICIPANT_ID	☐	DPR_TV_PART_ID	CHAR24	CHAR	24	0	Role ID
28	ROLE_TYPE_TEXT	☐	DPR_TV_PARTICIPANT_ROLE_TEXT	DPR_TEXT	CHAR	40	0	Name of Role Type
29	VERSION_NUMBER	☐	CGPL_TV_VERSION	CGPL_VERSION	CHAR	24	0	Version Number
30	C_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
31	CAND_IN_WORKLIST	☐	DPR_TV_CANDIDATE_IN_WORKLIST	DPR_BOOLEAN	CHAR	1	0	Role Is Displayed in Candidate Manager's Worklist
32	TIME_UNIT	☐	MSEHI	MEINS	UNIT	3	0	Unit of Measurement	*
33	TIME_UNIT_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
34	DESCRIPTION	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
35	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
36	STATTXT	☐	DPR_TV_STATUS_TXT		STRG	0	0	Concatenated Status Text of an Object
37	ROLE_FUNCTION_ID	☐	DPR_TV_ROLE_FUNCTION_ID	DPR_ROLE_FUNCTION_ID	CHAR	15	0	ID of Role Function	*
38	LOCATION	☐	DPR_TV_LOCATION	DPR_LOCATION	CHAR	4	0	Location	*
39	URGENCY	☐	DPR_TV_URGENCY	DPR_URGENCY	CHAR	2	0	Urgency
40	AREA	☐	DPR_TV_AREA	DPR_AREA	CHAR	4	0	Area	*
41	AREA_TEXT	☐	DPR_TV_AREA_TEXT	TEXT30	CHAR	30	0	Area Text
42	SM_ORGUNIT_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
43	SM_ORGUNIT_SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
44	SM_ORGUNIT_STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
45	CM_ORGUNIT_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
46	CM_ORGUNIT_SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
47	CM_ORGUNIT_STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
48	SM_USER	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
49	CM_USER	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
50	.INCLUDE	☐				0	0	Include for Enhanced Attribute: Role (Participant)
51	EA_DUMMY	☐	DPR_TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced Proj. Mgmt Attributes
52	.INCLUDE	☐				0	0
53	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DPR_TS_DX_ROLE	ROLE_TYPE	DPR_PART_ROLE	PARTICIPANT_ROLE

History

Last changed by/on	SAP	20141109
SAP Release Created in	500_702