UHDT_HATTRVALS

Transparent Table Customizing Table
7 Fields 3 CDS Views

Hierarchy Attribute Values

UHDT_HATTRVALS is an SAP database table in S/4HANA. Hierarchy Attribute Values. It contains 7 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FAC_CDS_UH_HD_ATTR_VAL_JSON view from Header Attribute Value
FAC_CDS_UH_HD_ATTR_VAL_JSON view union Header Attribute Value
FAC_CDS_uhdt_hattrvals_SDM view left_outer uhdt_hattrvals with SDM hryid field

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY hier_catg cakey Type
KEY hier_id vhrid Hierarchy ID
KEY ver_id vrsid Version ID
KEY attr_name natnm Attribute Name
KEY attr_lval alval Attribute Low Value
KEY attr_hval ahval Attribute High 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.

-- Hierarchy Attribute Values
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UHDT_HATTRVALS (
    CLIENT,     -- Client [mandt]
    HIER_CATG,  -- Type [cakey]
    HIER_ID,    -- Hierarchy ID [vhrid]
    VER_ID,     -- Version ID [vrsid]
    ATTR_NAME,  -- Attribute Name [natnm]
    ATTR_LVAL,  -- Attribute Low Value [alval]
    ATTR_HVAL,  -- Attribute High Value [ahval]
    PRIMARY KEY (CLIENT, HIER_CATG, HIER_ID, VER_ID, ATTR_NAME, ATTR_LVAL, ATTR_HVAL)
);

Learn More