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