HRRP_ATTR_NODE
Hierarchy attribute on node
HRRP_ATTR_NODE is an SAP database table in S/4HANA. Hierarchy attribute on node. It contains 10 fields. 12 CDS views read from this table.
CDS Views using this table (12)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_HRRP_ATTR_NODE | view | from | BASIC | |
| P_HRRP_NODE_ATTR | view | from | BASIC | |
| PSM_AVC_BUDGET_ACCOUNT_BASIC | view | left_outer | Basic Budget Account View for Hierarchy | |
| PSM_AVC_BUDGET_PERIOD_BASIC | view | left_outer | Basic Budget Period View for Hierarchy | |
| PSM_AVC_COST_CENTER_BASIC | view | left_outer | Basic Cost Center View for Hierarchy | |
| PSM_AVC_FUNCTIONAL_AREA_BASIC | view | left_outer | Basic Functional Area View for Hierarchy | |
| PSM_AVC_FUND_BASIC | view | left_outer | Basic Fund View for Hierarchy | |
| PSM_AVC_GRANT_BASIC | view | left_outer | Basic Grant View for Hierarchy | |
| PSM_AVC_SPONSORED_CLASS_BASIC | view | left_outer | Basic Sponsored Class View for Hierarchy | |
| PSM_AVC_SPONSORED_PROG_BASIC | view | left_outer | Basic Sponsored Prog. View for Hierarchy | |
| PSM_AVC_WBS_ELEMENT_BASIC | view | left_outer | Basic WBS Element View for Hierarchy | |
| R_HierRuntimeRprstnNodeAttrib | view | from | BASIC | Hierarchy Node Attribute |
Fields (10)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | hryid | hryid | Hierarchy ID | |||
| KEY | hryver | hryversn | Version | |||
| KEY | hryvalto | datbi | Valid To | |||
| KEY | nodecls | nodecls | Node Class | |||
| KEY | hrynode | hrynode | Node | |||
| KEY | parnode | parnode | Par. Node | |||
| KEY | hryattrname | hryattrname | Attribute Name | |||
| KEY | hryattrvalue | hryattrvalue | Attribute Value | |||
| KEY | hryattrhvalue | hryattrhvalue | Attribute High Value |
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 attribute on node
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRRP_ATTR_NODE (
MANDT, -- Client [mandt]
HRYID, -- Hierarchy ID [hryid]
HRYVER, -- Version [hryversn]
HRYVALTO, -- Valid To [datbi]
NODECLS, -- Node Class [nodecls]
HRYNODE, -- Node [hrynode]
PARNODE, -- Par. Node [parnode]
HRYATTRNAME, -- Attribute Name [hryattrname]
HRYATTRVALUE, -- Attribute Value [hryattrvalue]
HRYATTRHVALUE, -- Attribute High Value [hryattrhvalue]
PRIMARY KEY (MANDT, HRYID, HRYVER, HRYVALTO, NODECLS, HRYNODE, PARNODE, HRYATTRNAME, HRYATTRVALUE, HRYATTRHVALUE)
);
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