SAP ACL_ACE ACL: Entry for Authorized Users Table data and field list

ACL_ACE is a standard SAP Table which is used to store ACL: Entry for Authorized Users data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ACL_ACE table consists of various fields, each holding specific information or linking keys about ACL: Entry for Authorized Users data available in SAP. These include ACL_ID (ACL: Key GUID of ACL), ACE_CTR (ACL: ACE Counter), ACL_USER (ACL: User), ACL_GROUP (ACL: User Group)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

ACL_ACE table Technical Details:

Delivery Class: W - System table, contents transportable via separate TR objects
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP ACL_ACE table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the ACL_ACE table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient ID SYMANDTCLNT3Assigned to domainMANDT
ACL_IDACL: Key GUID of ACL ACL_IDCHAR32ACL_MAINSYSUUID_C
ACE_CTRACL: ACE Counter ACL_ACECTRNUMC4
ACL_USERACL: User ACL_USERCHAR12Assigned to domainXUBNAME
ACL_GROUPACL: User Group ACL_USRGRPCHAR40CHAR40
ACT_GROUPACL: Role ACL_ACTGRPCHAR32ACL_ACTGRP
GRANT_MODEACL: Grant Mode for Activity ACL_GRNTMDCHAR1ACL_GRNTMD

Key field Non-key field



How do I retrieve data from SAP table ACL_ACE using ABAP code

The following ABAP code Example will allow you to do a basic selection on ACL_ACE to SELECT all data from the table
DATA: WA_ACL_ACE TYPE ACL_ACE.

SELECT SINGLE *
FROM ACL_ACE
INTO CORRESPONDING FIELDS OF WA_ACL_ACE
WHERE...

How to access SAP table ACL_ACE

Within an ECC or HANA version of SAP you can also view further information about ACL_ACE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).