ACMHEXDB_HI4DIM3

Transparent Table Temporary Data
6 Fields 3 CDS Views

ACMHEX: Hierarchy for Dimension-3 (DBTable)

ACMHEXDB_HI4DIM3 is an SAP database table in S/4HANA. ACMHEX: Hierarchy for Dimension-3 (DBTable). It contains 6 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
ACMHEX_HIERS4DIM3 view from ACMHEX: Single Hierarchy for Dimension-3
ACMHEX_HIERS4DIM3_LEAFVIEW view from Leaf-View for Hierarchy-for-Dimension-3
ACMHEX_HIERS4DIM3_LEAFVIEW view left_outer Leaf-View for Hierarchy-for-Dimension-3

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY nodeid acmhex_node_id Node ID
parentid acmhex_node_id Node ID
region acmhex_region_code Region
country land1 Country/Reg.
cityto acmhex_city City

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- ACMHEX: Hierarchy for Dimension-3 (DBTable)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACMHEXDB_HI4DIM3 (
    MANDT,     -- Client [mandt]
    NODEID,    -- Node ID [acmhex_node_id]
    PARENTID,  -- Node ID [acmhex_node_id]
    REGION,    -- Region [acmhex_region_code]
    COUNTRY,   -- Country/Reg. [land1]
    CITYTO,    -- City [acmhex_city]
    PRIMARY KEY (MANDT, NODEID)
);

Learn More