P_FSTMT_Hry_leaf

DDL: P_FSTMT_HRY_LEAF SQL: PFSTMT_HR_LEAF Type: view BASIC
30 Fields 3 Data Sources

P_FSTMT_Hry_leaf is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (hrrp_node, hrrp_node, hrrp_node) and exposes 30 fields with key fields hryid, hryver, nodecls, childnode, hrynode.

Data Sources (3)

SourceAliasJoin Type
hrrp_node dnode inner
hrrp_node leaf from
hrrp_node parnode inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PFSTMT_HR_LEAF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
VDM.private true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY hryid hrrp_node hryid Hierarchy ID
KEY hryver hrrp_node hryver Version: Structures
KEY nodecls hrrp_node nodecls Node Class
KEY childnode hrrp_node hrynode Value
KEY hrynode hrrp_node parnode Par. Node
KEY hryvalto hrrp_node hryvalto Valid To
hryvalfrom hrrp_node hryvalfrom Valid From
balind hrrp_node balind Balance
nodetype hrrp_node nodetype Object Type
nodevalue hrrp_node nodevalue Value
racct hrrp_node nodevalue Value
sign
parnode hrrp_node parnode Par. Node
hryseqnbr hrrp_node hryseqnbr Sequence Number
hryid Hierarchy ID
KEY hryver hrrp_node hryver Version: Structures
KEY nodecls hrrp_node nodecls Node Class
KEY childnode plnode nodevalue Value
KEY hrynode hrrp_node parnode Par. Node
KEY hryvalto hrrp_node hryvalto Valid To
hryvalfrom hrrp_node hryvalfrom Valid From
balind plnode balind Balance
balnode plnode hrynode Node
NODETYPE
nodevalue plnode nodevalue Value
racct hrrp_node nodevalue Value
sign
parnode plnode parnode Par. Node
hryseqnbr plnode hryseqnbr Sequence Number
hrylevel plnode hrylevel Hierarchy Level

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_FSTMT_Hry_leaf.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PFSTMT_HR_LEAF

CREATE VIEW P_FSTMT_Hry_leaf AS
SELECT
  leaf.hryid AS hryid,
  leaf.hryver AS hryver,
  leaf.nodecls AS nodecls,
  leaf.hrynode AS childnode,
  leaf.parnode AS hrynode,
  leaf.hryvalto AS hryvalto,
  leaf.hryvalfrom AS hryvalfrom,
  leaf.balind AS balind,
  leaf.nodetype AS nodetype,
  leaf.nodevalue AS nodevalue,
  leaf.nodevalue AS racct,
  '' AS sign,
  parnode.parnode AS parnode,
  parnode.hryseqnbr AS hryseqnbr,
  plnode.hrynode AS balnode,
  plnode.hrylevel AS hrylevel
FROM hrrp_node AS leaf
INNER JOIN hrrp_node AS parnode ON /* join condition not captured in parsed metadata */
INNER JOIN hrrp_node AS dnode ON /* join condition not captured in parsed metadata */
;

Learn More