UHDT_NATR

Transparent Table Control Table (SAP+Cust)
24 Fields 3 CDS Views

Node Attribute Definition

UHDT_NATR is an SAP database table in S/4HANA. Node Attribute Definition. It contains 24 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FAC_CDS_UH_ATTR_VAL_JSON view inner Node Attribute Value
FAC_CDS_UH_NODE_ATTR_DEF view from Node Attribute Definition
FAC_CDS_UH_NODE_ATTR_VALUE view inner Node Attribute Values

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY node_catg CAKEY Type
KEY node_type NODTP Node Type
KEY attr_name NATNM Attribute Name
KEY node_entity BNNAM Business Entity
grp_name NATGPNM Node 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_technical ATRTECH Technical Attribute
attr_dis_in_col ATDIC Display in Column
attr_disor_in_col ATCLO Attr. Column Order
attr_dis_in_faen ATDIE For Fast Entry
attr_disor_in_faen ATFEO Order in Fast Entry
attr_default_lval DALVAL Default Value - Low
attr_default_hval DAHVAL Default Value - High
attr_excel ATEXC Can be exported/imported
attr_disor_excel ATEXO Order in Excel
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.

-- Node Attribute Definition
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UHDT_NATR (
    MANDT,               -- Client [MANDT]
    NODE_CATG,           -- Type [CAKEY]
    NODE_TYPE,           -- Node Type [NODTP]
    ATTR_NAME,           -- Attribute Name [NATNM]
    NODE_ENTITY,         -- Business Entity [BNNAM]
    GRP_NAME,            -- Node Attribute Group [NATGPNM]
    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_TECHNICAL,      -- Technical Attribute [ATRTECH]
    ATTR_DIS_IN_COL,     -- Display in Column [ATDIC]
    ATTR_DISOR_IN_COL,   -- Attr. Column Order [ATCLO]
    ATTR_DIS_IN_FAEN,    -- For Fast Entry [ATDIE]
    ATTR_DISOR_IN_FAEN,  -- Order in Fast Entry [ATFEO]
    ATTR_DEFAULT_LVAL,   -- Default Value - Low [DALVAL]
    ATTR_DEFAULT_HVAL,   -- Default Value - High [DAHVAL]
    ATTR_EXCEL,          -- Can be exported/imported [ATEXC]
    ATTR_DISOR_EXCEL,    -- Order in Excel [ATEXO]
    HRRP_MAPPING,        -- HRRP Mapping Field [HRRP_MPFLD]
    PRIMARY KEY (MANDT, NODE_CATG, NODE_TYPE, ATTR_NAME, NODE_ENTITY)
);

Learn More