ACMHEXDB_HI4DIM2

Transparent Table Temporary Data
12 Fields 4 CDS Views

ACMHEX: Hierarchies for Dimension-2 (DBTable)

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
ACMHEX_HIERS4DIM2 view from ACMHEX: Hierarchies for Dimension-2
ACMHEX_HIERS4DIM2_LEAFVIEW view from Leaf-View for Hierarchy-for-Dimension-2
ACMHEX_HIERS4DIM2_LEAFVIEW view left_outer Leaf-View for Hierarchy-for-Dimension-2
ACMHEX_HIERS4DIM2_LEAFVIEW view union Leaf-View for Hierarchy-for-Dimension-2

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY hieid1 acmhex_hier_id1 HIEID-1
KEY hieid2 acmhex_hier_id2 HIEID-2
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.
producer acmhex_producer_id Producer ID
plane_type acmhex_planetype Planetype
carrier_id acmhex_carr_id Carrier
connection_id acmhex_conn_id Connection

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-2 (DBTable)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACMHEXDB_HI4DIM2 (
    MANDT,          -- Client [mandt]
    HIEID1,         -- HIEID-1 [acmhex_hier_id1]
    HIEID2,         -- HIEID-2 [acmhex_hier_id2]
    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]
    PRODUCER,       -- Producer ID [acmhex_producer_id]
    PLANE_TYPE,     -- Planetype [acmhex_planetype]
    CARRIER_ID,     -- Carrier [acmhex_carr_id]
    CONNECTION_ID,  -- Connection [acmhex_conn_id]
    PRIMARY KEY (MANDT, HIEID1, HIEID2, NODEID)
);

Learn More