The ACMHEXDB_HI4DIM3 table in SAP ERP or S/4HANA stores ACMHEX: Hierarchy for Dimension-3 (DBTable) data. There are total 6 fields in ACMHEXDB_HI4DIM3 table. The ACMHEX: Hierarchy for Dimension-3 (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_HI4DIM3 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_HI4DIM3 Table Fields
Following is the list of fields that are available in SAP ACMHEXDB_HI4DIM3 table. The primary key fields of the table are MANDT (Client), NODEID (ACMHEX: Node-ID (same as: RSHIENODID)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| NODEID | ACMHEX: Node-ID (same as: RSHIENODID) | ACMHEX_NODE_ID | NUMC (8) | |
| PARENTID | ACMHEX: Node-ID (same as: RSHIENODID) | ACMHEX_NODE_ID | NUMC (8) | |
| REGION | ACMHEX: Region Code | ACMHEX_REGION_CODE | ACMHEXDB_SREGION | CHAR (10) |
| COUNTRY | Country/Region Key | LAND1 | ACMHEXDB_SCOUNTR | CHAR (3) |
| CITYTO | ACMHEX: City | ACMHEX_CITY | CHAR (20) |
