SAP ABAP Table /RPM/TS_ROLE_DEMAND (Consolidated role demand)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PFM (Application Component) Portfolio Management
     ⤷ /RPM/INTEGRATION (Package) xRPM Integration Components

Basic Data

Table Category	INTTAB	Structure
Structure	/RPM/TS_ROLE_DEMAND	Table Relationship Diagram
Short Description	Consolidated role demand

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	.INCLUDE	☐				0	0	Role Attributes (Internal)
2	GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
3	EXTERNAL_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
4	.INCLUDE	☐				0	0	Project Planning: Projects and Activities Include Structure
5	PROJECT_GUID	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
6	OBJECT_TYPE	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
7	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	CGPL_PRIO
8	ACTUALSTART	☐	CGPL_ACTUALSTART	BCOS_TSTMP	DEC	15	0	Actual Start Date
9	ACTUALFINISH	☐	CGPL_ACTUALFINISH	BCOS_TSTMP	DEC	15	0	Actual Finish Date
10	PLANSTART	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
11	PLANFINISH	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
12	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
13	MILESTONE	☐	CGPL_MILESTONE	CHAR1	CHAR	1	0	Milestone indicator
14	CONSTRAINT_TYPE	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
15	CONSTRAINT_TIME	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
16	CREATED_BY	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
17	CREATED_ON	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
18	CREATED_IN_BW	☐	CGPL_CREATED_BW	CHAR1	CHAR	1	0	Transfer Object to BW
19	CHANGED_BY	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
20	CHANGED_ON	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
21	UPDATED_IN_BW	☐	CGPL_UPDATED_BW	CHAR1	CHAR	1	0	Current Object in BW
22	BWIDENTIFIER	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
23	PLANGROUP	☐	CGPL_SEM_PLGRP		CHAR	4	0	Planning Profile Group
24	LATEST_START	☐	CGPL_LATEST_START	BCOS_TSTMP	DEC	15	0	Latest start
25	LATEST_FINISH	☐	CGPL_LATEST_FINISH	BCOS_TSTMP	DEC	15	0	Latest finish date
26	TOTAL_FLOAT	☐	CGPL_TOTAL_FLOAT	CGPL_FLOAT	DEC	8	2	Total Float
27	DURATION	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
28	DURATION_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
29	CALENDAR_ID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
30	CONSTR_TYPE_FIN	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
31	CONSTR_TIME_FIN	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
32	APPLICATION	☐	CGPL_APPLICATION_TYPE	CGPL_APPLICATION_TYPE	CHAR	3	0	Application in Project Planning	*
33	FORECAST_START	☐	CGPL_FORECAST_START	BCOS_TSTMP	DEC	15	0	Forecast Start
34	FORECAST_FINISH	☐	CGPL_FORECAST_FINISH	BCOS_TSTMP	DEC	15	0	Forecast Finish
35	.INCLUDE	☐				0	0	Include for Processing Status
36	PROC_STATUS_OWN	☐	DPR_TV_PROC_STATUS_OWN	DPR_PROC_STATUS	CHAR	2	0	Object Processing Status
37	PROC_STATUS_SUP	☐	DPR_TV_PROC_STATUS_SUP	DPR_PROC_STATUS	CHAR	2	0	Processing Status of Higher-Level Object
38	.INCLUDE	☐				0	0	Role Attributes
39	SORT_NUMBER	☐	DPR_TV_SORT_NUMBER		NUMC	5	0	Sort Number
40	VERSION_NUMBER	☐	CGPL_TV_VERSION	CGPL_VERSION	CHAR	24	0	Version Number
41	PARTICIPANT_ROLE	☐	DPR_TV_PARTICIPANT_ROLE	DPR_PARTICIPANT_ROLE	CHAR	15	0	Role Type for Projects	DPR_PART_ROLE
42	BEG_TMSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
43	END_TMSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
44	WORK_EFFORT	☐	DPR_TV_EFFORT	DPR_WORK	QUAN	9	2	Demand or Assigned Effort
45	WORK_UNIT	☐	DPR_TV_EFFORT_UNIT	MEINS	UNIT	3	0	Unit for Demand or Effort	*
46	C_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
47	PARTNER_ROLE	☐	DPR_TV_BU_ROLE	BU_RLTYP	CHAR	6	0	BP Role	*
48	VACANT	☐	DPR_TV_VACANT	DPR_BOOLEAN	CHAR	1	0	Vacant Checkbox of Role
49	CAND_IN_WORKLIST	☐	DPR_TV_CANDIDATE_IN_WORKLIST	DPR_BOOLEAN	CHAR	1	0	Role Is Displayed in Candidate Manager's Worklist
50	STAT_PROFILE_PRT	☐	DPR_TV_STAT_PROFILE_PRT	J_STSMA	CHAR	8	0	Status Profile Template	*
51	VC_BUPA_GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
52	RATE	☐	DPR_TV_RATE	DPR_RATE_TYPE	CHAR	15	0	Cost Rate/Revenue Rate for Project Costing	*
53	REVENUE_RATE	☐	DPR_TV_REVENUE_RATE_MANUAL	PREIS	CURR	11	2	Different Revenue
54	CURRENCY	☐	WAERS_CURC	WAERS	CUKY	5	0	Currency Key	*
55	COST_RATE	☐	DPR_TV_COST_RATE_MANUAL	PREIS	CURR	11	2	Different Costs
56	CURRENCY_COST	☐	WAERS_CURC	WAERS	CUKY	5	0	Currency Key	*
57	TIME_UNIT	☐	DPR_TV_TIME_UNIT_MANUAL	MEINS	UNIT	3	0	Activity Unit for Deviating Costs and Revenues	*
58	ACT_WORK_EFFORT	☐	DPR_TV_ACT_WORK	DPR_WORK_LONG	QUAN	16	3	Confirmation (Insternal Display)
59	ACT_WORK_UNIT	☐	DPR_TV_ACT_WRK_UNIT	MEINS	UNIT	3	0	Confirmation Unit	*
60	ACT_WRK_UNIT_EXT	☐	DPR_TV_ACT_WRK_UNIT	MEINS	UNIT	3	0	Confirmation Unit	*
61	CONF_GUID	☐	DPR_TV_CONF_GUID		RAW	16	0	GUID of a Confirmation Document
62	CONCRETE_ROLE	☐	DPR_TV_CONCRETE_ROLE	CHAR1	CHAR	1	0	Shadow Role (= Concrete Role)
63	PARTICIPANT_ID	☐	DPR_TV_PART_ID	CHAR24	CHAR	24	0	Role ID
64	URGENCY	☐	DPR_TV_URGENCY	DPR_URGENCY	CHAR	2	0	Urgency
65	ROLE_FUNCTION_ID	☐	DPR_TV_ROLE_FUNCTION_ID	DPR_ROLE_FUNCTION_ID	CHAR	15	0	ID of Role Function	DPR_ROLE_FUNC
66	LOCATION	☐	DPR_TV_LOCATION	DPR_LOCATION	CHAR	4	0	Location	DPR_LOCATION
67	STAFF_PERCENT	☐	DPR_TV_STAFF_PERCENT	NUMC3	NUMC	3	0	Percent Staffed
68	.INCLUDE	☐				0	0	Include for Enhanced Attribute: Role (Participant)
69	EA_DUMMY	☐	DPR_TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced Proj. Mgmt Attributes
70	.INCLUDE	☐				0	0
71	.INCLUDE	☐				0	0
72	.INCLUDE	☐				0	0	Distribution of Role
73	ALLOCATION_UNIT	☐	DPR_TV_ALLOCATION_UNIT	MEINS	UNIT	3	0	Distribution Unit	*
74	PERIODTYPE	☐	DPR_TV_PERIOD_TYPE	DPR_PERIOD_TYPE	NUMC	2	0	Period Type (Weekly/Monthly/Generic Interval)
75	DIST_DATA	☐	DPR_TT_PART_DIST_ADT_DATA		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/RPM/TS_ROLE_DEMAND	LOCATION	DPR_LOCATION	LOCATION	REF
2	/RPM/TS_ROLE_DEMAND	PARTICIPANT_ROLE	DPR_PART_ROLE	PARTICIPANT_ROLE
3	/RPM/TS_ROLE_DEMAND	PRIORITY	CGPL_PRIO	PRIORITY	KEY
4	/RPM/TS_ROLE_DEMAND	ROLE_FUNCTION_ID	DPR_ROLE_FUNC	ROLE_FUNC_ID	REF

History

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