HRRP_NODET

Transparent Table Application Table

Hierarchy node texts

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

CDS Views using this table (19)

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_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_CorporateIncomeTaxHierNodeT view from BASIC CIT Hierarchy Node - Text
I_CustUnivHierNodeText view from BASIC Customer 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
P_CnsldtnUnivHierNodeElimT view from BASIC
P_CnsldtnUnivHierNodeText view from BASIC Consolidation Universal Hier Node - Text
P_CnsldtnUnivHierNodeText_2 view from BASIC

Fields (11)

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

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]
    PRIMARY KEY (MANDT, SPRAS, HRYID, HRYVER, NODECLS, HRYNODE, PARNODE, HRYVALTO)
);