ACMHEXDB_H4D1DIR

Transparent Table Temporary Data
4 Fields 1 CDS Views

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

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
ACMHEX_HIERS4DIM1_DIRECTORY view from Directory of all Hierarchies in Hierarchy-for-Dimension-1

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY hieid acmhex_hier_id1 HIEID-1
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-1 (DBTable)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACMHEXDB_H4D1DIR (
    MANDT,         -- Client [mandt]
    HIEID,         -- HIEID-1 [acmhex_hier_id1]
    HIERTXT,       -- Text [text60]
    LAST_CHANGED,  -- Time Stamp [timestamp]
    PRIMARY KEY (MANDT, HIEID)
);

Learn More