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 | U |
2 | ![]() |
ACMRULE | U | |
3 | ![]() |
ACMDTCONDITION | U | |
4 | ![]() |
ACMACCONDITION | U | |
5 | ![]() |
ACMACFIELD | U | |
6 | ![]() |
ACMASPECT | U | |
7 | ![]() |
ACMASPECTVIEW | U | |
8 | ![]() |
|||
9 | ![]() |
|||
10 | ![]() |
ACMACAVIEWDETAIL | U | |
11 | ![]() |
DDDDLNUMTYPES | U | |
12 | ![]() |
DDDDLCHARTYPES | U |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
ROLEID | JL | EQ | 0 | 0 | ||||
2 | ![]() |
ID | JR | EQ | AND | 0 | 0 | |||
3 | ![]() |
RULEID | JL | EQ | 0 | 0 | ||||
4 | ![]() |
ID | JR | EQ | AND | 0 | 0 | |||
5 | ![]() |
ID | JL | EQ | 0 | 0 | ||||
6 | ![]() |
ACCONDITION | JR | EQ | AND | 0 | 0 | |||
7 | ![]() |
PATH_TYPE | JL | EQ | 0 | 0 | ||||
8 | ![]() |
JR | EQ | 'FIELDVIEW' | AND | 0 | 0 | |||
9 | ![]() |
ACCONDITION_ID | JL | EQ | 0 | 0 | ||||
10 | ![]() |
ID | JR | EQ | AND | 0 | 0 | |||
11 | ![]() |
ID | JL | EQ | 0 | 0 | ||||
12 | ![]() |
ASPECT_ID | JR | EQ | AND | 0 | 0 | |||
13 | ![]() |
ASPECT_TYPE | JL | EQ | 0 | 0 | ||||
14 | ![]() |
JR | EQ | 'ASPECTVIEW' | AND | 0 | 0 | |||
15 | ![]() |
ASPECT_ID | JL | EQ | 0 | 0 | ||||
16 | ![]() |
ID | JR | EQ | AND | 0 | 0 | |||
17 | ![]() |
ROLEID | JL | EQ | 0 | 0 | ||||
18 | ![]() |
ID | JR | EQ | AND | 0 | 0 | |||
19 | ![]() |
RULEID | JL | EQ | 0 | 0 | ||||
20 | ![]() |
ID | JR | EQ | AND | 0 | 0 | |||
21 | ![]() |
ID | JL | EQ | 0 | 0 | ||||
22 | ![]() |
ACCONDITION | JR | EQ | AND | 0 | 0 | |||
23 | ![]() |
PATH_TYPE | JL | EQ | 0 | 0 | ||||
24 | ![]() |
JR | EQ | 'FIELDVIEW' | AND | 0 | 0 | |||
25 | ![]() |
ACCONDITION_ID | JL | EQ | 0 | 0 | ||||
26 | ![]() |
ID | JR | EQ | AND | 0 | 0 | |||
27 | ![]() |
ID | JL | EQ | 0 | 0 | ||||
28 | ![]() |
ASPECT_ID | JR | EQ | AND | 0 | 0 | |||
29 | ![]() |
ASPECT_TYPE | JL | EQ | 0 | 0 | ||||
30 | ![]() |
JR | EQ | 'PFCG_AUTH' | AND | 0 | 0 | |||
31 | ![]() |
ASPECT_ID | JL | EQ | 0 | 0 | ||||
32 | ![]() |
ID | JR | EQ | AND | 0 | 0 | |||
33 | ![]() |
ROLEID | JL | EQ | 0 | 0 | ||||
34 | ![]() |
ID | JR | EQ | AND | 0 | 0 | |||
35 | ![]() |
RULEID | JL | EQ | 0 | 0 | ||||
36 | ![]() |
ID | JR | EQ | AND | 0 | 0 | |||
37 | ![]() |
ID | JL | EQ | 0 | 0 | ||||
38 | ![]() |
ACCONDITION | JR | EQ | AND | 0 | 0 | |||
39 | ![]() |
PATH_TYPE | JL | EQ | 0 | 0 | ||||
40 | ![]() |
JR | EQ | 'PATHVIEW' | AND | 0 | 0 | |||
41 | ![]() |
ID | JL | EQ | 0 | 0 | ||||
42 | ![]() |
ACAUTHVIEW_ID | JR | EQ | AND | 0 | 0 | |||
43 | ![]() |
ACAUTHVIEW_ID | JL | EQ | 0 | 0 | ||||
44 | ![]() |
ID | JR | EQ | AND | 0 | 0 | |||
45 | ![]() |
ID | JL | EQ | 0 | 0 | ||||
46 | ![]() |
ASPECT_ID | JR | EQ | AND | 0 | 0 | |||
47 | ![]() |
ASPECT_ID | JL | EQ | 0 | 0 | ||||
48 | ![]() |
ID | JR | EQ | AND | 0 | 0 | |||
49 | ![]() |
NAME | NE | ' ' | 0 | 0 | ||||
50 | ![]() |
NAME | NE | ' ' | 0 | 0 | ||||
51 | ![]() |
ACAVIEWDETAIL_TYPE | EQ | 'AVVALUE' | AND | 0 | 0 | |||
52 | ![]() |
VIEW_FIELDNAME | NE | 'AVVALUE_FIXCOUNT' | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | ![]() |
![]() |
ID | ACM_ROLE_ID | ACM: UUID of a Role | |||
2 | ![]() |
![]() |
NAME | ACM_ROLE_NAME | ACM: Name of a Role | |||
3 | ![]() |
![]() |
RULEPOS | ACM_SEQUENCE_NUMBER | ACM: Position in a Sequence (First Position=0) | |||
4 | ![]() |
![]() |
CONDITIONPOS | ACM_SEQUENCE_NUMBER | ACM: Position in a Sequence (First Position=0) | |||
5 | ![]() |
![]() |
CINT4 | |||||
6 | ![]() |
![]() |
COMP_OPER | ACM_COMPARISON_OPERATOR | ACM: Comparison Operator (=, <>, <, >) | |||
7 | ![]() |
![]() |
ASPECT_ID | ACM_ASPECT_ID | ACM: UUID of an Aspect | |||
8 | ![]() |
![]() |
ASPECT_GENERIC | BOOLEAN | Boolean Variable (X=True, -=False, Space=Unknown) | |||
9 | ![]() |
![]() |
PATH_TYPE | ACM_ACCONDPATH_TYPE | ACM: Type of an Access-Condition Path | |||
10 | ![]() |
![]() |
ID | ACM_ACFIELD_ID | ACM: UUID of an Access-Condition Field | |||
11 | ![]() |
![]() |
NAME | ACM_ASPECT_NAME | ACM: Name of an Aspect | |||
12 | ![]() |
![]() |
ASPECT_TYPE | ACM_ASPECT_TYPE | ACM: Type of an Aspect | |||
13 | ![]() |
![]() |
ASPECT_EVAL_TIME | ACM_ASPECT_EVAL_TIME | ACM: Aspect Evaluation Time | |||
14 | ![]() |
![]() |
CCHAR100 | |||||
15 | ![]() |
![]() |
VIEW_ABAPNAME | VIEWNAME16 | View Name, 16 Characters | |||
16 | ![]() |
![]() |
VIEW_ENTITYNAME | ACM_ENTITY_ID | ACM: ID of an Entity | |||
17 | ![]() |
![]() |
CCHAR30 | |||||
18 | ![]() |
![]() |
CCHAR30 | |||||
19 | ![]() |
![]() |
ID | ACM_ROLE_ID | ACM: UUID of a Role | |||
20 | ![]() |
![]() |
NAME | ACM_ROLE_NAME | ACM: Name of a Role | |||
21 | ![]() |
![]() |
RULEPOS | ACM_SEQUENCE_NUMBER | ACM: Position in a Sequence (First Position=0) | |||
22 | ![]() |
![]() |
CONDITIONPOS | ACM_SEQUENCE_NUMBER | ACM: Position in a Sequence (First Position=0) | |||
23 | ![]() |
![]() |
CINT4 | |||||
24 | ![]() |
![]() |
COMP_OPER | ACM_COMPARISON_OPERATOR | ACM: Comparison Operator (=, <>, <, >) | |||
25 | ![]() |
![]() |
ASPECT_ID | ACM_ASPECT_ID | ACM: UUID of an Aspect | |||
26 | ![]() |
![]() |
ASPECT_GENERIC | BOOLEAN | Boolean Variable (X=True, -=False, Space=Unknown) | |||
27 | ![]() |
![]() |
PATH_TYPE | ACM_ACCONDPATH_TYPE | ACM: Type of an Access-Condition Path | |||
28 | ![]() |
![]() |
ID | ACM_ACFIELD_ID | ACM: UUID of an Access-Condition Field | |||
29 | ![]() |
![]() |
NAME | ACM_ASPECT_NAME | ACM: Name of an Aspect | |||
30 | ![]() |
![]() |
ASPECT_TYPE | ACM_ASPECT_TYPE | ACM: Type of an Aspect | |||
31 | ![]() |
![]() |
ASPECT_EVAL_TIME | ACM_ASPECT_EVAL_TIME | ACM: Aspect Evaluation Time | |||
32 | ![]() |
![]() |
DESCRIPTION | ACM_ASPECT_DESCRIPTION | ACM: Description of an Aspect (EndUserText.Label) | |||
33 | ![]() |
![]() |
KCHAR | |||||
34 | ![]() |
![]() |
KCHAR | |||||
35 | ![]() |
![]() |
KCHAR | |||||
36 | ![]() |
![]() |
KCHAR | |||||
37 | ![]() |
![]() |
ID | ACM_ROLE_ID | ACM: UUID of a Role | |||
38 | ![]() |
![]() |
NAME | ACM_ROLE_NAME | ACM: Name of a Role | |||
39 | ![]() |
![]() |
RULEPOS | ACM_SEQUENCE_NUMBER | ACM: Position in a Sequence (First Position=0) | |||
40 | ![]() |
![]() |
CONDITIONPOS | ACM_SEQUENCE_NUMBER | ACM: Position in a Sequence (First Position=0) | |||
41 | ![]() |
![]() |
POS | ACM_SEQUENCE_NUMBER | ACM: Position in a Sequence (First Position=0) | |||
42 | ![]() |
![]() |
COMP_OPER | ACM_COMPARISON_OPERATOR | ACM: Comparison Operator (=, <>, <, >) | |||
43 | ![]() |
![]() |
ASPECT_ID | ACM_ASPECT_ID | ACM: UUID of an Aspect | |||
44 | ![]() |
![]() |
ASPECT_GENERIC | BOOLEAN | Boolean Variable (X=True, -=False, Space=Unknown) | |||
45 | ![]() |
![]() |
PATH_TYPE | ACM_ACCONDPATH_TYPE | ACM: Type of an Access-Condition Path | |||
46 | ![]() |
![]() |
ID | ACM_ACAUTHVIEW_DETAIL_ID | ACM: UUID of an Authorization View Detail | |||
47 | ![]() |
![]() |
NAME | ACM_ASPECT_NAME | ACM: Name of an Aspect | |||
48 | ![]() |
![]() |
ASPECT_TYPE | ACM_ASPECT_TYPE | ACM: Type of an Aspect | |||
49 | ![]() |
![]() |
ASPECT_EVAL_TIME | ACM_ASPECT_EVAL_TIME | ACM: Aspect Evaluation Time | |||
50 | ![]() |
![]() |
CCHAR100 | |||||
51 | ![]() |
![]() |
VIEW_ABAPNAME | VIEWNAME16 | View Name, 16 Characters | |||
52 | ![]() |
![]() |
VIEW_ENTITYNAME | ACM_ENTITY_ID | ACM: ID of an Entity | |||
53 | ![]() |
![]() |
CCHAR30 | |||||
54 | ![]() |
![]() |
CCHAR30 | |||||
Maintenance Status
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 |