I_UNIVERSALHIERNODE

CDS View
21 Fields 8 CDS Views

Universal Hierarchy Node

I_UNIVERSALHIERNODE is a CDS View in S/4HANA. Universal Hierarchy Node. It contains 21 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
FIISAL_GR_GLAcctGlobHier view_entity from Greece GLAccount hierarchy
I_CnsldtnBalValdtnRuleGroup view_entity inner BASIC Balance Validation Rule Group
P_AllocationCycleGroupNode view from CONSUMPTION Allocation Cycle Group Node
P_ShrtTrmCshPosAccHier view_entity inner COMPOSITE Short Term Cash Position Bank Acc Hier
P_XB_COSTSTATEMENTHIERALLNODE view_entity from BASIC Cost Statement Hierarchy Node
P_XB_COSTSTATEMENTHIERNODE view_entity from BASIC Cost Statement Hierarchy Node
R_CostCenterHierarchyNode view_entity from TRANSACTIONAL Cost Center Hierarchy Node
R_CostCenterHierarchyNodeText view_entity inner TRANSACTIONAL Cost Center Hierarchy Node Text

Fields (21)

KeyField CDS FieldsUsed in Views
KEY UniversalHierNodeID CashPositionHierNode,UniversalHierNodeID 5
KEY UniversalHierNodeLowValue CashPositionHierNodeValue,CostCtrHierarchyNodeShortID,UniversalHierNodeLowValue 6
KEY UniversalHierNodeType UniversalHierNodeType 5
_ClFdValue _ClFdValue 2
_Text _Text 3
_Version _Version 3
UniversalHierarchyVersionID UniversalHierarchyVersionID 4
UniversalHierNodeCreatedAt UniversalHierNodeCreatedAt 2
UniversalHierNodeCreatedBy UniversalHierNodeCreatedBy 2
UniversalHierNodeDisplayOrder UniversalHierNodeDisplayOrder 2
UniversalHierNodeEntity UniversalHierNodeEntity 2
UniversalHierNodeHighValue UniversalHierNodeHighValue 2
UniversalHierNodeLevel UniversalHierNodeLevel 4
UniversalHierNodeParentID CashPositionHierParentNode,UniversalHierNodeParentID 5
UniversalHierNodeRefID UniversalHierNodeRefID 2
UniversalHierNodeSequence UniversalHierNodeSequence 2
UniversalHierNodeSign UniversalHierNodeSign 2
UniversalHierNodeUpdatedAt UniversalHierNodeUpdatedAt 2
UniversalHierNodeUpdatedBy UniversalHierNodeUpdatedBy 2
UniversalHierNodeValidFrom UniversalHierNodeValidFrom 1
UniversalHierNodeValidTo UniversalHierNodeValidTo 1

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.

-- Universal Hierarchy Node
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UNIVERSALHIERNODE (
    UNIVERSALHIERNODEID,
    UNIVERSALHIERNODELOWVALUE,
    UNIVERSALHIERNODETYPE,
    _CLFDVALUE,
    _TEXT,
    _VERSION,
    UNIVERSALHIERARCHYVERSIONID,
    UNIVERSALHIERNODECREATEDAT,
    UNIVERSALHIERNODECREATEDBY,
    UNIVERSALHIERNODEDISPLAYORDER,
    UNIVERSALHIERNODEENTITY,
    UNIVERSALHIERNODEHIGHVALUE,
    UNIVERSALHIERNODELEVEL,
    UNIVERSALHIERNODEPARENTID,
    UNIVERSALHIERNODEREFID,
    UNIVERSALHIERNODESEQUENCE,
    UNIVERSALHIERNODESIGN,
    UNIVERSALHIERNODEUPDATEDAT,
    UNIVERSALHIERNODEUPDATEDBY,
    UNIVERSALHIERNODEVALIDFROM,
    UNIVERSALHIERNODEVALIDTO,
    PRIMARY KEY (UNIVERSALHIERNODEID, UNIVERSALHIERNODELOWVALUE, UNIVERSALHIERNODETYPE)
);

Learn More