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