The CRM_ACE_USERS table in SAP ERP or S/4HANA stores Repository of all ACE relevant users data. There are total 6 fields in CRM_ACE_USERS table. The Repository of all ACE relevant users table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRM_ACE_USERS table. It is in Interfaces for Access Control Engine (CRM_ACE_INTERFACES) ABAP package and is part of the Customer Relationship Management (CRM) module.
SAP CRM_ACE_USERS Table Fields
Following is the list of fields that are available in SAP CRM_ACE_USERS table. The primary key fields of the table are MANDT (Client), USR_NAME (User Name).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| USR_NAME | User Name | SYUNAME | CHAR (12) | |
| DEF_ACEGROUP_ID | ACEGroup ID (Access Control Engine) | CRM_ACE_GROUP_ID | RAW (16) | |
| LAST_UCT_CALC | Time of validity for user context | CRM_ACE_UCT_VALID_FROM | DEC (15) | |
| IS_ACTIVE | Logical Variable | CRMT_BOOLEAN | CHAR (1) | |
| VALID_UCC | Logical Variable | CRMT_BOOLEAN | CHAR (1) |
