SAP ABAP View SACMAT_ROLEASP_V (View for getting Aspects/Aspect-related infos for each Role)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SEC-AUT (Application Component) Authorization Management
     ⤷ SACMAT_API (Package) Administration API

Basic Data

View Type	D	Database View
Database View	SACMAT_ROLEASP_V
Short Description	View for getting Aspects/Aspect-related infos for each Role
Root table	ACMROLE	ACM: Role Persistency

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ACMROLE	ACMROLE	ACMROLE	U
2	ACMRULE		ACMRULE	U
3	ACMDTCONDITION		ACMDTCONDITION	U
4	ACMACCONDITION		ACMACCONDITION	U
5	ACMACFIELD		ACMACFIELD	U
6	ACMASPECT		ACMASPECT	U
7	ACMASPECTVIEW		ACMASPECTVIEW	U
8	ACMASPECTPFCG
9	ACMACAUTHVIEW
10	ACMACAVIEWDETAIL		ACMACAVIEWDETAIL	U
11	DDDDLNUMTYPES		DDDDLNUMTYPES	U
12	DDDDLCHARTYPES		DDDDLCHARTYPES	U

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ACMRULE	ROLEID	JL	EQ				0	0
2	ACMROLE	ID	JR	EQ			AND	0	0
3	ACMDTCONDITION	RULEID	JL	EQ				0	0
4	ACMRULE	ID	JR	EQ			AND	0	0
5	ACMACCONDITION	ID	JL	EQ				0	0
6	ACMDTCONDITION	ACCONDITION	JR	EQ			AND	0	0
7	ACMACCONDITION	PATH_TYPE	JL	EQ				0	0
8			JR	EQ	'FIELDVIEW'		AND	0	0
9	ACMACFIELD	ACCONDITION_ID	JL	EQ				0	0
10	ACMACCONDITION	ID	JR	EQ			AND	0	0
11	ACMASPECT	ID	JL	EQ				0	0
12	ACMACFIELD	ASPECT_ID	JR	EQ			AND	0	0
13	ACMASPECT	ASPECT_TYPE	JL	EQ				0	0
14			JR	EQ	'ASPECTVIEW'		AND	0	0
15	ACMASPECTVIEW	ASPECT_ID	JL	EQ				0	0
16	ACMASPECT	ID	JR	EQ			AND	0	0
17	ACMRULE	ROLEID	JL	EQ				0	0
18	ACMROLE	ID	JR	EQ			AND	0	0
19	ACMDTCONDITION	RULEID	JL	EQ				0	0
20	ACMRULE	ID	JR	EQ			AND	0	0
21	ACMACCONDITION	ID	JL	EQ				0	0
22	ACMDTCONDITION	ACCONDITION	JR	EQ			AND	0	0
23	ACMACCONDITION	PATH_TYPE	JL	EQ				0	0
24			JR	EQ	'FIELDVIEW'		AND	0	0
25	ACMACFIELD	ACCONDITION_ID	JL	EQ				0	0
26	ACMACCONDITION	ID	JR	EQ			AND	0	0
27	ACMASPECT	ID	JL	EQ				0	0
28	ACMACFIELD	ASPECT_ID	JR	EQ			AND	0	0
29	ACMASPECT	ASPECT_TYPE	JL	EQ				0	0
30			JR	EQ	'PFCG_AUTH'		AND	0	0
31	ACMASPECTPFCG	ASPECT_ID	JL	EQ				0	0
32	ACMASPECT	ID	JR	EQ			AND	0	0
33	ACMRULE	ROLEID	JL	EQ				0	0
34	ACMROLE	ID	JR	EQ			AND	0	0
35	ACMDTCONDITION	RULEID	JL	EQ				0	0
36	ACMRULE	ID	JR	EQ			AND	0	0
37	ACMACCONDITION	ID	JL	EQ				0	0
38	ACMDTCONDITION	ACCONDITION	JR	EQ			AND	0	0
39	ACMACCONDITION	PATH_TYPE	JL	EQ				0	0
40			JR	EQ	'PATHVIEW'		AND	0	0
41	ACMACAUTHVIEW	ID	JL	EQ				0	0
42	ACMACCONDITION	ACAUTHVIEW_ID	JR	EQ			AND	0	0
43	ACMACAVIEWDETAIL	ACAUTHVIEW_ID	JL	EQ				0	0
44	ACMACAUTHVIEW	ID	JR	EQ			AND	0	0
45	ACMASPECT	ID	JL	EQ				0	0
46	ACMACAVIEWDETAIL	ASPECT_ID	JR	EQ			AND	0	0
47	ACMASPECTVIEW	ASPECT_ID	JL	EQ				0	0
48	ACMASPECT	ID	JR	EQ			AND	0	0
49	ACMASPECT	NAME		NE	' '			0	0
50	ACMASPECT	NAME		NE	' '			0	0
51	ACMACAVIEWDETAIL	ACAVIEWDETAIL_TYPE		EQ	'AVVALUE'		AND	0	0
52	ACMACAVIEWDETAIL	VIEW_FIELDNAME		NE	'AVVALUE_FIXCOUNT'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	ROLE_ID	ACMROLE	ID		☐	ACM_ROLE_ID	☐	ACM: UUID of a Role
2	ROLE_NAME	ACMROLE	NAME		☐	ACM_ROLE_NAME	☐	ACM: Name of a Role
3	RULEPOS	ACMRULE	RULEPOS		☐	ACM_SEQUENCE_NUMBER	☐	ACM: Position in a Sequence (First Position=0)
4	CONDITIONPOS	ACMDTCONDITION	CONDITIONPOS		☐	ACM_SEQUENCE_NUMBER	☐	ACM: Position in a Sequence (First Position=0)
5	AVIEWDETAILPOS	DDDDLNUMTYPES	CINT4		☐		☐
6	COMP_OPER	ACMACFIELD	COMP_OPER		☐	ACM_COMPARISON_OPERATOR	☐	ACM: Comparison Operator (=, <>, <, >)
7	ASPECT_ID	ACMACFIELD	ASPECT_ID		☐	ACM_ASPECT_ID	☐	ACM: UUID of an Aspect
8	ASPECT_GENERIC	ACMACFIELD	ASPECT_GENERIC		☐	BOOLEAN	☐	Boolean Variable (X=True, -=False, Space=Unknown)
9	ACCOND_PATHTYPE	ACMACCONDITION	PATH_TYPE		☐	ACM_ACCONDPATH_TYPE	☐	ACM: Type of an Access-Condition Path
10	ACFIELD_AVDET_ID	ACMACFIELD	ID		☐	ACM_ACFIELD_ID	☐	ACM: UUID of an Access-Condition Field
11	ASPECT_NAME	ACMASPECT	NAME		☐	ACM_ASPECT_NAME	☐	ACM: Name of an Aspect
12	ASPECT_TYPE	ACMASPECT	ASPECT_TYPE		☐	ACM_ASPECT_TYPE	☐	ACM: Type of an Aspect
13	ASPECT_EVAL_TIME	ACMASPECT	ASPECT_EVAL_TIME		☐	ACM_ASPECT_EVAL_TIME	☐	ACM: Aspect Evaluation Time
14	ASPECT_DESCRIPTION	DDDDLCHARTYPES	CCHAR100		☐		☐
15	ASPECTVIEW_ABAPNAME	ACMASPECTVIEW	VIEW_ABAPNAME		☐	VIEWNAME16	☐	View Name, 16 Characters
16	ASPECTVIEW_ENTITYNAME	ACMASPECTVIEW	VIEW_ENTITYNAME		☐	ACM_ENTITY_ID	☐	ACM: ID of an Entity
17	ASPECTVIEW_SRC_ENTITY	DDDDLCHARTYPES	CCHAR30		☐		☐
18	ASPECTVIEW_SRC_FIELD	DDDDLCHARTYPES	CCHAR30		☐		☐
19	ROLE_ID	ACMROLE	ID		☐	ACM_ROLE_ID	☐	ACM: UUID of a Role
20	ROLE_NAME	ACMROLE	NAME		☐	ACM_ROLE_NAME	☐	ACM: Name of a Role
21	RULEPOS	ACMRULE	RULEPOS		☐	ACM_SEQUENCE_NUMBER	☐	ACM: Position in a Sequence (First Position=0)
22	CONDITIONPOS	ACMDTCONDITION	CONDITIONPOS		☐	ACM_SEQUENCE_NUMBER	☐	ACM: Position in a Sequence (First Position=0)
23	AVIEWDETAILPOS	DDDDLNUMTYPES	CINT4		☐		☐
24	COMP_OPER	ACMACFIELD	COMP_OPER		☐	ACM_COMPARISON_OPERATOR	☐	ACM: Comparison Operator (=, <>, <, >)
25	ASPECT_ID	ACMACFIELD	ASPECT_ID		☐	ACM_ASPECT_ID	☐	ACM: UUID of an Aspect
26	ASPECT_GENERIC	ACMACFIELD	ASPECT_GENERIC		☐	BOOLEAN	☐	Boolean Variable (X=True, -=False, Space=Unknown)
27	ACCOND_PATHTYPE	ACMACCONDITION	PATH_TYPE		☐	ACM_ACCONDPATH_TYPE	☐	ACM: Type of an Access-Condition Path
28	ACFIELD_AVDET_ID	ACMACFIELD	ID		☐	ACM_ACFIELD_ID	☐	ACM: UUID of an Access-Condition Field
29	ASPECT_NAME	ACMASPECT	NAME		☐	ACM_ASPECT_NAME	☐	ACM: Name of an Aspect
30	ASPECT_TYPE	ACMASPECT	ASPECT_TYPE		☐	ACM_ASPECT_TYPE	☐	ACM: Type of an Aspect
31	ASPECT_EVAL_TIME	ACMASPECT	ASPECT_EVAL_TIME		☐	ACM_ASPECT_EVAL_TIME	☐	ACM: Aspect Evaluation Time
32	ASPECT_DESCRIPTION	ACMASPECT	DESCRIPTION		☐	ACM_ASPECT_DESCRIPTION	☐	ACM: Description of an Aspect (EndUserText.Label)
33	ASPECTVIEW_ABAPNAME	DDDDLCHARTYPES	KCHAR		☐		☐
34	ASPECTVIEW_ENTITYNAME	DDDDLCHARTYPES	KCHAR		☐		☐
35	ASPECTVIEW_SRC_ENTITY	DDDDLCHARTYPES	KCHAR		☐		☐
36	ASPECTVIEW_SRC_FIELD	DDDDLCHARTYPES	KCHAR		☐		☐
37	ROLE_ID	ACMROLE	ID		☐	ACM_ROLE_ID	☐	ACM: UUID of a Role
38	ROLE_NAME	ACMROLE	NAME		☐	ACM_ROLE_NAME	☐	ACM: Name of a Role
39	RULEPOS	ACMRULE	RULEPOS		☐	ACM_SEQUENCE_NUMBER	☐	ACM: Position in a Sequence (First Position=0)
40	CONDITIONPOS	ACMDTCONDITION	CONDITIONPOS		☐	ACM_SEQUENCE_NUMBER	☐	ACM: Position in a Sequence (First Position=0)
41	AVIEWDETAILPOS	ACMACAVIEWDETAIL	POS		☐	ACM_SEQUENCE_NUMBER	☐	ACM: Position in a Sequence (First Position=0)
42	COMP_OPER	ACMACAVIEWDETAIL	COMP_OPER		☐	ACM_COMPARISON_OPERATOR	☐	ACM: Comparison Operator (=, <>, <, >)
43	ASPECT_ID	ACMACAVIEWDETAIL	ASPECT_ID		☐	ACM_ASPECT_ID	☐	ACM: UUID of an Aspect
44	ASPECT_GENERIC	ACMACAVIEWDETAIL	ASPECT_GENERIC		☐	BOOLEAN	☐	Boolean Variable (X=True, -=False, Space=Unknown)
45	ACCOND_PATHTYPE	ACMACCONDITION	PATH_TYPE		☐	ACM_ACCONDPATH_TYPE	☐	ACM: Type of an Access-Condition Path
46	ACFIELD_AVDET_ID	ACMACAVIEWDETAIL	ID		☐	ACM_ACAUTHVIEW_DETAIL_ID	☐	ACM: UUID of an Authorization View Detail
47	ASPECT_NAME	ACMASPECT	NAME		☐	ACM_ASPECT_NAME	☐	ACM: Name of an Aspect
48	ASPECT_TYPE	ACMASPECT	ASPECT_TYPE		☐	ACM_ASPECT_TYPE	☐	ACM: Type of an Aspect
49	ASPECT_EVAL_TIME	ACMASPECT	ASPECT_EVAL_TIME		☐	ACM_ASPECT_EVAL_TIME	☐	ACM: Aspect Evaluation Time
50	ASPECT_DESCRIPTION	DDDDLCHARTYPES	CCHAR100		☐		☐
51	ASPECTVIEW_ABAPNAME	ACMASPECTVIEW	VIEW_ABAPNAME		☐	VIEWNAME16	☐	View Name, 16 Characters
52	ASPECTVIEW_ENTITYNAME	ACMASPECTVIEW	VIEW_ENTITYNAME		☐	ACM_ENTITY_ID	☐	ACM: ID of an Entity
53	ASPECTVIEW_SRC_ENTITY	DDDDLCHARTYPES	CCHAR30		☐		☐
54	ASPECTVIEW_SRC_FIELD	DDDDLCHARTYPES	CCHAR30		☐		☐

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	DDIC	20150523
SAP Release Created in	740