ACMHEXDB_HI4DIM1

Transparent Table Temporary Data
8 Fields 4 CDS Views

ACMHEX: Hierarchies for Dimension-1 (DBTable)

ACMHEXDB_HI4DIM1 is an SAP database table in S/4HANA. ACMHEX: Hierarchies for Dimension-1 (DBTable). It contains 8 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
ACMHEX_HIERS4DIM1 view from ACMHEX: Hierarchies for Dimension-1
ACMHEX_HIERS4DIM1_LEAFVIEW view from Leaf-View for Hierarchy-for-Dimension-1
ACMHEX_HIERS4DIM1_LEAFVIEW view left_outer Leaf-View for Hierarchy-for-Dimension-1
ACMHEX_HIERS4DIM1_LEAFVIEW view union Leaf-View for Hierarchy-for-Dimension-1

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY hieid acmhex_hier_id1 HIEID-1
KEY nodeid acmhex_node_id Node ID
parentid acmhex_node_id Node ID
region acmhex_region_code Region
continent acmhex_continent Continent
country land1 Country/Reg.
carrid acmhex_carr_id Carrier

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: Hierarchies for Dimension-1 (DBTable)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACMHEXDB_HI4DIM1 (
    MANDT,      -- Client [mandt]
    HIEID,      -- HIEID-1 [acmhex_hier_id1]
    NODEID,     -- Node ID [acmhex_node_id]
    PARENTID,   -- Node ID [acmhex_node_id]
    REGION,     -- Region [acmhex_region_code]
    CONTINENT,  -- Continent [acmhex_continent]
    COUNTRY,    -- Country/Reg. [land1]
    CARRID,     -- Carrier [acmhex_carr_id]
    PRIMARY KEY (MANDT, HIEID, NODEID)
);

Learn More