Sunday, May 19, 2024

SAP Table ACMPFCGMAPPING – ACM: PFCG Field Mapping (for Hierarchy Authorization)

ACMPFCGMAPPING is a standard SAP table in SAP ECC (or) S/4HANA which stores ACM: PFCG Field Mapping (for Hierarchy Authorization) data. There are total 11 fields in ACMPFCGMAPPING table.This blog post provides key technical details of SAP table ACMPFCGMAPPING, including its availability across SAP S/4HANA versions and the list of CDS views for ACMPFCGMAPPING 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 ACMPFCGMAPPING Table Fields

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

Field Description Data Element Domain Check Table Data Type
ID ACM: Mapping ID ACM_MAPPING_ID ACM_ID RAW (16)
PARENT_ID ACM: UUID of an Aggregate (Accesspolicy) ACM_AGGREGATE_ID SYSUUID ACMAGGREGATE RAW (16)
PARENT_TYPE ACM: Type of an DCL Top-Level Object ACM_DCLTOPLEVEL_TYPE ACM_DCLTOPLEVEL_TYPE CHAR (10)
POS ACM: Position in a Sequence ACM_SEQUENCE_NUMBER ACM_SEQUENCE_NUMBER INT4 (10)
NAME ACM: Name of a Mapping ACM_MAPPING_NAME ACM_DDSTRUCOBJNAME CHAR (30)
DESCRIPTION ACM: Description of a Mapping (EndUserText.Label) ACM_MAPPING_DESCRIPTION ACM_ENDUSERTEXT_LABEL CHAR (80)
AUTH_OBJECT Authorization Object XUOBJECT XUOBJECT CHAR (10)
SACF_SCENARIO Scenario Name for Switchable Authorization Check SCEN_NAME SCEN_NAME CHAR (40)
MAPPING_VIEW_ENTITYNAME ACM: Name of an CDS Entity ACM_ENTITY_ID ACM_DDSTRUCOBJNAME CHAR (30)
DATASOURCE_NAME ACM: Name of a Hierarchy Datasource ACM_HIER_DATASOURCE_NAME ACM_DDSTRUCOBJNAME CHAR (30)
CTE_ID ACM: UUID of a CTE entry ACM_CTE_ID SYSUUID RAW (16)

Availability

The SAP table ACMPFCGMAPPING 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 ACMPFCGMAPPING table

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