SAP ACMROLE ACM: Role Persistency Table
Overview
ACMROLE is a standard SAP S/4HANA table that stores ACM: Role Persistency data. There are total 9 fields in the ACMROLE table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ACMROLE belongs to Data Control Language (DCL) (Define Authorizations for CDS) (BC-SEC-AUT-DCL) module and is located in the package Common Objects for Access Control Management (SACM_COMMON).
In addition, following links provide an overview of foreign key relationships, if any, that link ACMROLE to other SAP tables and standard CDS views available based on ACMROLE table in S/4HANA 2020.
Techincal Settings of ACMROLE
Below are technical details of the table ACMROLE
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ACMROLE Fields
The following table gives you an overview of the fields available in ACMROLE
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| ID | ACM: UUID of a Role | ACM_ROLE_ID | RAW | 16 | |
| NAME | ACM: Name of a Role | ACM_ROLE_NAME | CHAR | 30 | |
| DESCRIPTION | ACM: Short Description of a Role | ACM_ROLE_DESCRIPTION | CHAR | 60 | |
| DCLNAME | Access Control Document Name | ACM_DCLNAME | ACMDCLSRC | CHAR | 40 |
| MAPPING_ROLE | Boolean Variable (X = True, - = False, Space = Unknown) | BOOLEAN | CHAR | 1 | |
| CREATED_BY | User Name in User Master Record | XUBNAME | CHAR | 12 | |
| CREATED_AT | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC | 21 | |
| DCLACTIVE_AS4DATE | Last Changed On | AS4DATE | DATS | 8 | |
| DCLACTIVE_AS4TIME | Last changed at | AS4TIME | TIMS | 6 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ACMROLE
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| ACMROLE | DCLNAME | C: C | ACMDCLSRC |