UHDT_HATR

Transparent Table Control Table (SAP+Cust)
21 Fields 2 CDS Views

Hierarchy Attribute Definition

UHDT_HATR is an SAP database table in S/4HANA. Hierarchy Attribute Definition. It contains 21 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FAC_CDS_UH_HD_ATTR_DEF view from Header Attribute Definition
FAC_CDS_UH_HD_ATTR_VAL_JSON view inner Header Attribute Value

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY hier_catg cakey Type
KEY attr_name natnm Attribute Name
grp_name hatgpnm Attribute Group
attr_type nattp Attribute Type
attr_sign atsgn Value Input Type
attr_seqe atseq Display Order
attr_shlp shpnm Search Help Name
attr_shlp_field shpfld Search Help Field
attr_shlp_tfield shptfd Search Help Text Fld
attr_mdty amdty Is Mandatory Field
attr_rdol ardol Read-Only
attr_dis_creation atdip Display on Creation
attr_technical atrtech Technical Attribute
attr_default_lval dalval Default Value - Low
attr_default_hval dahval Default Value - High
attr_ver_dependent havdep Version-Dependent
attr_auto_update havupd Auto-Save
attr_refresh_hier havref Refresh Hier.
attr_excel atexc Can be exported/imported
hrrp_mapping hrrp_mpfld HRRP Mapping Field

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 Definition
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UHDT_HATR (
    MANDT,               -- Client [mandt]
    HIER_CATG,           -- Type [cakey]
    ATTR_NAME,           -- Attribute Name [natnm]
    GRP_NAME,            -- Attribute Group [hatgpnm]
    ATTR_TYPE,           -- Attribute Type [nattp]
    ATTR_SIGN,           -- Value Input Type [atsgn]
    ATTR_SEQE,           -- Display Order [atseq]
    ATTR_SHLP,           -- Search Help Name [shpnm]
    ATTR_SHLP_FIELD,     -- Search Help Field [shpfld]
    ATTR_SHLP_TFIELD,    -- Search Help Text Fld [shptfd]
    ATTR_MDTY,           -- Is Mandatory Field [amdty]
    ATTR_RDOL,           -- Read-Only [ardol]
    ATTR_DIS_CREATION,   -- Display on Creation [atdip]
    ATTR_TECHNICAL,      -- Technical Attribute [atrtech]
    ATTR_DEFAULT_LVAL,   -- Default Value - Low [dalval]
    ATTR_DEFAULT_HVAL,   -- Default Value - High [dahval]
    ATTR_VER_DEPENDENT,  -- Version-Dependent [havdep]
    ATTR_AUTO_UPDATE,    -- Auto-Save [havupd]
    ATTR_REFRESH_HIER,   -- Refresh Hier. [havref]
    ATTR_EXCEL,          -- Can be exported/imported [atexc]
    HRRP_MAPPING,        -- HRRP Mapping Field [hrrp_mpfld]
    PRIMARY KEY (MANDT, HIER_CATG, ATTR_NAME)
);

Learn More