SAP ABAP View RPM_USER_ROLES (Database view for Roles via user authorization)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PFM (Application Component) Portfolio Management
     ⤷ PRP_RESOURCE_MANAGER (Package) Resource Manager Fast Entry Screen Processing

Basic Data

View Type	D	Database View
Database View	RPM_USER_ROLES
Short Description	Database view for Roles via user authorization
Root table	ACO_USER	Object-Related Authorizations for a User

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ACO_USER	ACO_USER
2	CGPL_TASK
3	DPR_PART

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ACO_USER	OBJECT_ID	JL	EQ				0	0
2	CGPL_TASK	PROJECT_GUID	JR	EQ			AND	0	0
3	ACO_USER	OBJECT_ID	JL	EQ				0	0
4	DPR_PART	GUID	JR	EQ			AND	0	0
5	ACO_USER	TYPE		EQ	'MTG'		AND	0	0
6	ACO_USER	ACTIVITY		EQ	'StaffMan'		OR	0	0
7	ACO_USER	ACTIVITY		EQ	'CandMan'		OR	0	0
8	ACO_USER	ACTIVITY		EQ	'ResMan'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	ACO_USER	CLIENT		☐	MANDT	☐	Client
2	USER_ID	ACO_USER	USER_ID		☐	ACO_USER_ID	☐	User ID
3	OBJECT_ID	ACO_USER	OBJECT_ID		☐	ACO_OBJECT_ID	☐	Object ID
4	TOP_NODE_ID	ACO_USER	TOP_NODE_ID		☐	ACO_TOP_ID	☐	ID of Highest Node in the Hierarchy
5	ACTIVITY	ACO_USER	ACTIVITY		☐	ACO_ACTVT	☐	Activity for Authorization Check
6	TYPE	ACO_USER	TYPE		☐	ACO_OBJECT_TYPE	☐	Object Category
7	PLANSTART	CGPL_TASK	PLANSTART		☐	CGPL_PLANSTART	☐	Planned start date
8	PLANFINISH	CGPL_TASK	PLANFINISH		☐	CGPL_PLANFINISH	☐	Planned Finish Date
9	PARTICIPANT_ROLE	DPR_PART	PARTICIPANT_ROLE		☐	DPR_TV_PARTICIPANT_ROLE	☐	Role Type for Projects
10	BEG_TMSTMP	DPR_PART	BEG_TMSTMP		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
11	END_TMSTMP	DPR_PART	END_TMSTMP		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
12	WORK_EFFORT	DPR_PART	WORK_EFFORT		☐	DPR_TV_EFFORT	☐	Demand or Assigned Effort
13	WORK_UNIT	DPR_PART	WORK_UNIT		☐	DPR_TV_EFFORT_UNIT	☐	Unit for Demand or Effort
14	VACANT	DPR_PART	VACANT		☐	DPR_TV_VACANT	☐	Vacant Checkbox of Role
15	PARTICIPANT_ID	DPR_PART	PARTICIPANT_ID		☐	DPR_TV_PART_ID	☐	Role ID
16	ROLE_FUNCTION_ID	DPR_PART	ROLE_FUNCTION_ID		☐	DPR_TV_ROLE_FUNCTION_ID	☐	ID of Role Function
17	LOCATION	DPR_PART	LOCATION		☐	DPR_TV_LOCATION	☐	Location

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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