UHDT_HATV

Transparent Table Control Table (SAP+Cust)

Definitions of Acceptable Values for Hierarchy Attributes

UHDT_HATV is an SAP database table in S/4HANA. Definitions of Acceptable Values for Hierarchy Attributes. It contains 4 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FAC_CDS_UH_HD_ATTR_FVAL_DEF view from Header Attribute Fixed Value Definition

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY hier_catg cakey Type
KEY attr_name natnm Attribute Name
KEY attr_valu avalu Attribute Value

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.

-- Definitions of Acceptable Values for Hierarchy Attributes
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UHDT_HATV (
    MANDT,      -- Client [mandt]
    HIER_CATG,  -- Type [cakey]
    ATTR_NAME,  -- Attribute Name [natnm]
    ATTR_VALU,  -- Attribute Value [avalu]
    PRIMARY KEY (MANDT, HIER_CATG, ATTR_NAME, ATTR_VALU)
);