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