HRRP_NODET
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA