The ACMHEXDB_H4D2DIR table in SAP ERP or S/4HANA stores ACMHEX: Directory for Hierarchies-for-Dimension-2 (DBTable) data. There are total 5 fields in ACMHEXDB_H4D2DIR table. The ACMHEX: Directory for Hierarchies-for-Dimension-2 (DBTable) 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 ACMHEXDB_H4D2DIR table. It is in Hierarchy Example (SACMHIEREX) ABAP package and is part of the Data Control Language (DCL) (Define Authorizations for CDS) (BC-SEC-AUT-DCL) module.
SAP ACMHEXDB_H4D2DIR Table Fields
Following is the list of fields that are available in SAP ACMHEXDB_H4D2DIR table. The primary key fields of the table are MANDT (Client), HIEID1 (ACMHEX: Hierarchy ID-1), HIEID2 (ACMHEX: Hierarchy ID-2).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| HIEID1 | ACMHEX: Hierarchy ID-1 | ACMHEX_HIER_ID1 | CHAR (24) | |
| HIEID2 | ACMHEX: Hierarchy ID-2 | ACMHEX_HIER_ID2 | CHAR (24) | |
| HIERTXT | Text Field of Length 60 | TEXT60 | CHAR (60) | |
| LAST_CHANGED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) |
