HRRP_NODET

Transparent Table Application Table
14 Fields 25 CDS Views

Hierarchy node texts

HRRP_NODET is an SAP database table in S/4HANA. Hierarchy node texts. It contains 14 fields. 25 CDS views read from this table.

CDS Views using this table (25)

ViewTypeJoinVDMDescription
FAC_CDS_HRRP_NODET_SDM_VER_B view from hrrp_nodet with sdm version field
I_BkAcctUniversalHierNodeTxt view from BASIC Bank Account Hierarchy Node Text
I_BudgetAccountHierarchyNodeT view from BASIC Budget Account Hierarchy Node - Text
I_BudgetPeriodHierarchyNodeT view from BASIC Budget Period Hierarchy Node Text
I_CnsldtnDocTypeHierNodeT_2 view from BASIC Cnsldtn Document Type Hier Node - Text
I_CnsldtnDocumentTypeHierNodeT view from BASIC Document Type Hierarchy Node - Text
I_CnsldtnSubitemHierNodeT view from BASIC Consolidation Subitem HierNode - Text
I_CnsldtnUnitHierNodeTextEnhcd view from BASIC Consolidation Unit Hierarchy Node - Text
I_CommitmentItemHierarchyNodeT view from BASIC Funds Center Hierarchy Node Text
I_CorporateIncomeTaxHierNodeT view from BASIC CIT Hierarchy Node - Text
I_CustUnivHierNodeText view from BASIC Customer Hierarchy Node - Text
I_FundedProgramHierarchyNodeT view from BASIC Funded Program Hierarchy Node - Text
I_FundHierarchyNodeText view from BASIC Fund Hierarchy Node Text
I_FundsCenterHierarchyNodeT view from BASIC Funds Center Hierarchy Node Text
I_GrantHierarchyNodeText view from BASIC Grant Hierarchy Node Text
I_ProdUnivHierNodeText view from BASIC Text View of Product Hierarchy Node
I_ProdUnivHierNodeText_2 view from BASIC Product Hierarchy Node - Text
I_ProdUnivHierNodeWthVersIDTxt view from BASIC Product Hierarchy Node Text
I_SponsoredClassHierarchyNodeT view from BASIC Sponsored Class Hierarchy Node Text
I_SponsoredProgHierarchyNodeT view from BASIC Sponsored Prog Hierarchy Node Text
I_WBSElementHierarchyNodeText view from BASIC WBS Element Hierarchy Node Text
P_CnsldtnUnitElimNodeText view_entity from BASIC Cnsldtn Unit Mgmt Elim Node - Text
P_CnsldtnUnivHierNodeElimT view from BASIC Consolidation Universal Hier Node - Text
P_CnsldtnUnivHierNodeText view from BASIC Consolidation Universal Hier Node - Text
P_CnsldtnUnivHierNodeText_2 view from BASIC Consolidation Universal Hier Node - Text

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY spras spras Language
KEY hryid hryid Hierarchy ID
KEY hryver hryversn Version
KEY nodecls nodecls Node Class
KEY hrynode hrynode Node
KEY parnode parnode Par. Node
KEY hryvalto datbi Valid To
hryvalfrom datab Valid From
nodetxt nodetxt Description
hrytyp hrytype Hierarchy Type
node_timedep node_timedep
uhnodeid nodid Node ID
par_uhnodeid npnid Node Parent 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 texts
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRRP_NODET (
    MANDT,         -- Client [mandt]
    SPRAS,         -- Language [spras]
    HRYID,         -- Hierarchy ID [hryid]
    HRYVER,        -- Version [hryversn]
    NODECLS,       -- Node Class [nodecls]
    HRYNODE,       -- Node [hrynode]
    PARNODE,       -- Par. Node [parnode]
    HRYVALTO,      -- Valid To [datbi]
    HRYVALFROM,    -- Valid From [datab]
    NODETXT,       -- Description [nodetxt]
    HRYTYP,        -- Hierarchy Type [hrytype]
    NODE_TIMEDEP,  -- node_timedep
    UHNODEID,      -- Node ID [nodid]
    PAR_UHNODEID,  -- Node Parent ID [npnid]
    PRIMARY KEY (MANDT, SPRAS, HRYID, HRYVER, NODECLS, HRYNODE, PARNODE, HRYVALTO)
);

Learn More