UHDT_NODE

Transparent Table Customizing Table
24 Fields 46 CDS Views

Hierarchy Node

UHDT_NODE is an SAP database table in S/4HANA. Hierarchy Node. It contains 24 fields. 46 CDS views read from this table.

CDS Views using this table (46)

ViewTypeJoinVDMDescription
FAC_CDS_UH_ACTIVITYTYPENODE view from Universal Hier Activity Type Node
FAC_CDS_UH_ATTR_VAL_JSON view inner Node Attribute Value
FAC_CDS_UH_COMPANYCODENODE view from Universal Hierarchy Company Code Node
FAC_CDS_UH_COSTCENTERNODE view from Universal Hierarchy Cost Center Node
FAC_CDS_UH_FSV_CONTRAITEM view from Universal Hierarchy FSV Contra Items
FAC_CDS_UH_FSVCONTRAITEM view from Universal Hierarchy FSV Contra Item
FAC_CDS_UH_FSVNODE view from Universal Hierarchy FSV Node
FAC_CDS_UH_FUNCNLAREANODE view from Universal Hierarchy Function Area Node
FAC_CDS_UH_GENERICNODE view from Universal Hierarchy Generic Node
FAC_CDS_UH_GLACCOUNTNODE view from Universal Hierarchy G/L Account Node
fac_cds_uh_node view from Universal Hierarchy Node
FAC_CDS_UH_NODE_ACTION view from Universal Hierarchy Node Action
FAC_CDS_UH_NODE_ATTR_VALUE view inner Node Attribute Values
FAC_CDS_UH_PRFTCENTERNODE view from Universal Hierarchy Profit Center Node
FAC_CDS_UH_REGIONNODE view from Universal Hierarchy Region Node
FAC_CDS_UH_RULEHIER view inner Rule Hierarchy
FAC_CDS_UH_RULENODE view from Universal Hierarchy Company Code Node
FAC_CDS_UH_RULENODE view inner Universal Hierarchy Company Code Node
FAC_CDS_UH_SEGMENTNODE view from Universal Hierarchy Segment Node
FAC_CDS_UH_STSTCLKEYFIGNODE view from Universal Hier Stat Key Figure Node
FAC_CDS_UH_VER_LANG view inner Universal Hierarchy Version Language
FAC_CDS_uhdt_hattrvals_SDM view left_outer uhdt_hattrvals with SDM hryid field
fac_cds_ve_group_node view from Validation Group Node
FAC_CDS_VE_VALIDATION_GROUP view inner Validation Group
FAC_CDS_VE_VALIDATION_GROUP_VH view inner Validation Group Value Help
FAC_SH_UNIVERSALHIERDIRVH view inner Universal Hierarchy Directory Value Help
FAC_VE_GRP_RULE_COUNT view left_outer Validation Group Rule Count
FIISAL_GR_GLAcctGlobHier2 view_entity from Greece GLAccount hierarchy
FINCS_UH_BUSINESSAREANODE view from Universal Hierarchy Business Area Node
FINCS_UH_COSTCENTERNODE view from Universal Hierarchy Cost Center Node
FINCS_UH_COUNTRYKEYNODE view from Universal Hierarchy Country/Region Node
FINCS_UH_CUSTOMERGRPNODE view from Universal Hierarchy Customer Group Node
FINCS_UH_CUSTOMERNODE view from Universal Hierarchy Customer Node
FINCS_UH_FinTransTypeNODE view from Universal Hierarchy Transaction Type Node
FINCS_UH_FSITEMNODE view from Universal Hierarchy Financial Statement Item Node
FINCS_UH_FUNCTIONALAREANODE view from Universal Hierarchy Functional Area Node
FINCS_UH_GLACCOUNTNODE view from Universal Hierarchy G/L Account Node
FINCS_UH_PRODUCTNODE view from Universal Hierarchy Product Sold Node
FINCS_UH_PROFITCENTERNODE view from Universal Hierarchy Profit Center Node
FINCS_UH_PROJECTNODE view from Universal Hierarchy Project Node
FINCS_UH_RITEMNODE view from Universal Hierarchy Reporting Item Node
FINCS_UH_SALESORGNODE view from Universal Hierarchy Sales Organization Node
FINCS_UH_SEGMENTNode view from Universal Hierarchy Segment Node
FINCS_UH_SUPPLIERNODE view from Universal Hierarchy Supplier Node
FINCS_UH_UNITNODE view from Universal Hierarchy - Consolidation Unit Node
I_UniversalHierNode view from BASIC Universal Hierarchy Node

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY node_id NODID Node ID
ver_id VRSID Version ID
node_pid NPNID Node Parent ID
node_rid NRNID Reference Node ID
node_type NODTP Node Type
node_entity BNNAM Business Entity
node_level NLEVL Node Level
node_ind NIDCT Node Indicator
node_seq NSEQN Sequence Number
node_order NUIOD UI Display Order
node_sgn NSIGN Node Value Sign
node_vldfm NDTFM Node Valid From
node_vldto NDTTO Node Valid To
node_lval NLVAL Node Low Value
node_hval NHVAL Node High Value
created_at NODCT Node Creation Time
created_by NODCB Node Created By
updated_at NODUT Node Updated Time
updated_by NODUB Node Updated By
ref_verid RVRID Ref. Version ID
origin_verid VRSID Version ID
ref_t_group_id RGPID Ref. Group ID
ref_s_group_id RGPID Ref. Group ID

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 Node
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UHDT_NODE (
    CLIENT,          -- Client [MANDT]
    NODE_ID,         -- Node ID [NODID]
    VER_ID,          -- Version ID [VRSID]
    NODE_PID,        -- Node Parent ID [NPNID]
    NODE_RID,        -- Reference Node ID [NRNID]
    NODE_TYPE,       -- Node Type [NODTP]
    NODE_ENTITY,     -- Business Entity [BNNAM]
    NODE_LEVEL,      -- Node Level [NLEVL]
    NODE_IND,        -- Node Indicator [NIDCT]
    NODE_SEQ,        -- Sequence Number [NSEQN]
    NODE_ORDER,      -- UI Display Order [NUIOD]
    NODE_SGN,        -- Node Value Sign [NSIGN]
    NODE_VLDFM,      -- Node Valid From [NDTFM]
    NODE_VLDTO,      -- Node Valid To [NDTTO]
    NODE_LVAL,       -- Node Low Value [NLVAL]
    NODE_HVAL,       -- Node High Value [NHVAL]
    CREATED_AT,      -- Node Creation Time [NODCT]
    CREATED_BY,      -- Node Created By [NODCB]
    UPDATED_AT,      -- Node Updated Time [NODUT]
    UPDATED_BY,      -- Node Updated By [NODUB]
    REF_VERID,       -- Ref. Version ID [RVRID]
    ORIGIN_VERID,    -- Version ID [VRSID]
    REF_T_GROUP_ID,  -- Ref. Group ID [RGPID]
    REF_S_GROUP_ID,  -- Ref. Group ID [RGPID]
    PRIMARY KEY (CLIENT, NODE_ID)
);

Learn More