UHDT_NODE

Transparent Table Customizing Table
24 Fields 45 CDS Views

Hierarchy Node

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

CDS Views using this table (45)

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
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