Sunday, May 19, 2024

SAP Table ACMACCONDITION – ACM: Access-Conditions (globally+reusable)

ACMACCONDITION is a standard SAP table in SAP ECC (or) S/4HANA which stores ACM: Access-Conditions (globally+reusable) data. There are total 12 fields in ACMACCONDITION table.This blog post provides key technical details of SAP table ACMACCONDITION, including its availability across SAP S/4HANA versions and the list of CDS views for ACMACCONDITION table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package Common Objects for Access Control Management (SACM_COMMON)
Technical Component Data Control Language (DCL) (Define Authorizations for CDS) (BC-SEC-AUT-DCL)

SAP ACMACCONDITION Table Fields

The following is the list of fields that are available in SAP ACMACCONDITION table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
ID ACM: UUID of an Access Condition ACM_ACCONDITION_ID SYSUUID RAW (16)
ENTITY_ID ACM: Name of an CDS Entity ACM_ENTITY_ID ACM_DDSTRUCOBJNAME CHAR (30)
NAME ACM: Name of an Access-Condition ACM_ACCONDITION_NAME ACM_DDSTRUCOBJNAME CHAR (30)
PATH_TYPE ACM: Type of an Access-Condition Path ACM_ACCONDPATH_TYPE ACM_ACCONDPATH_TYPE CHAR (10)
ACAUTHVIEW_ID ACM: UUID of an Authorization View ACM_AUTH_VIEW_ID SYSUUID RAW (16)
CTE_ID ACM: UUID of a CTE entry ACM_CTE_ID SYSUUID RAW (16)
COMP_OPER ACM: Comparison Operator (=, <>, <, >) ACM_COMPARISON_OPERATOR ACM_COMPARISON_OPERATOR CHAR (10)
ASPECT_TYPE ACM: Type of an Aspect ACM_ASPECT_TYPE ACM_ASPECT_TYPE CHAR (10)
ASPECT_ID ACM: UUID of an Aspect ACM_ASPECT_ID SYSUUID RAW (16)
QUANTIFIER_CANON ACM: Quantifier ACM_QUANTIFIER ACM_QUANTIFIER CHAR (6)
CREATED_BY User Name in User Master Record XUBNAME XUBNAME CHAR (12)
CREATED_AT UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPL TZNTSTMPL DEC (21)

Availability

The SAP table ACMACCONDITION is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Available?
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for ACMACCONDITION table

There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.