ACMHEXDB_H4D2DIR

Transparent Table Temporary Data
5 Fields 1 CDS Views

ACMHEX: Directory for Hierarchies-for-Dimension-2 (DBTable)

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
ACMHEX_HIERS4DIM2_DIRECTORY view from Directory of all Hierarchies in Hierarchy-for-Dimension-2

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY hieid1 acmhex_hier_id1 HIEID-1
KEY hieid2 acmhex_hier_id2 HIEID-2
hiertxt text60 Text
last_changed timestamp Time Stamp

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: Directory for 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_H4D2DIR (
    MANDT,         -- Client [mandt]
    HIEID1,        -- HIEID-1 [acmhex_hier_id1]
    HIEID2,        -- HIEID-2 [acmhex_hier_id2]
    HIERTXT,       -- Text [text60]
    LAST_CHANGED,  -- Time Stamp [timestamp]
    PRIMARY KEY (MANDT, HIEID1, HIEID2)
);

Learn More