Sunday, May 19, 2024

SAP Table ACMHEXDB_H4D1DIR – ACMHEX: Directory for Hierarchies-for-Dimension-1 (DBTable)

ACMHEXDB_H4D1DIR is a standard SAP table in SAP ECC (or) S/4HANA which stores ACMHEX: Directory for Hierarchies-for-Dimension-1 (DBTable) data. There are total 4 fields in ACMHEXDB_H4D1DIR table.This blog post provides key technical details of SAP table ACMHEXDB_H4D1DIR, including its availability across SAP S/4HANA versions and the list of CDS views for ACMHEXDB_H4D1DIR table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package Hierarchy Example (SACMHIEREX)
Technical Component Data Control Language (DCL) (Define Authorizations for CDS) (BC-SEC-AUT-DCL)

SAP ACMHEXDB_H4D1DIR Table Fields

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

Field Description Data Element Domain Check Table Data Type
MANDT Client MANDT MANDT * CLNT (3)
HIEID ACMHEX: Hierarchy ID-1 ACMHEX_HIER_ID1 ACMHEX_HIER_ID CHAR (24)
HIERTXT Text Field of Length 60 TEXT60 TEXT60 CHAR (60)
LAST_CHANGED UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP TZNTSTMPS DEC (15)

Availability

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

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