HPHRYNODE

Transparent Table Application Table
12 Fields 1 CDS Views

Hierarchy Nodes

HPHRYNODE is an SAP database table in S/4HANA. Hierarchy Nodes. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MasterDataHierarchyNode view from BASIC Master Data Hierarchy Node

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY hierarchy_id hp_hierarchy_id Hierarchy ID
KEY hierarchy_node_id hp_hierarchy_node_id Hierarchy Node ID
node_type hp_node_type Node Type
node_id hp_node_id Node ID
parent_hierarchy_node_id hp_hierarchy_node_id Hierarchy Node ID
hierarchy_level hp_hierarchy_level Hierarchy Level
template_level hp_template_level Template Level
attribute_name hp_attribute_name Attribute
virtual hp_virtual Virtual
leaf hp_leaf Leaf
no_of_children hp_no_of_children No. of Children

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 Nodes
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HPHRYNODE (
    MANDT,                     -- Client [mandt]
    HIERARCHY_ID,              -- Hierarchy ID [hp_hierarchy_id]
    HIERARCHY_NODE_ID,         -- Hierarchy Node ID [hp_hierarchy_node_id]
    NODE_TYPE,                 -- Node Type [hp_node_type]
    NODE_ID,                   -- Node ID [hp_node_id]
    PARENT_HIERARCHY_NODE_ID,  -- Hierarchy Node ID [hp_hierarchy_node_id]
    HIERARCHY_LEVEL,           -- Hierarchy Level [hp_hierarchy_level]
    TEMPLATE_LEVEL,            -- Template Level [hp_template_level]
    ATTRIBUTE_NAME,            -- Attribute [hp_attribute_name]
    VIRTUAL,                   -- Virtual [hp_virtual]
    LEAF,                      -- Leaf [hp_leaf]
    NO_OF_CHILDREN,            -- No. of Children [hp_no_of_children]
    PRIMARY KEY (MANDT, HIERARCHY_ID, HIERARCHY_NODE_ID)
);

Learn More