I_BPHierarchyNodeData

DDL: I_BPHIERARCHYNODEDATA Type: view_entity Package: MDC_BP_HIER_GOV_BO
12 Fields 1 Data Sources 1 Associations

Business Partner Hierarchy Node

I_BPHierarchyNodeData is a CDS View that provides data about "Business Partner Hierarchy Node" in SAP S/4HANA. It reads from 1 data source (bph_node) and exposes 12 fields with key field BPHierarchyNodeUUID. It has 1 association to related views. Part of development package MDC_BP_HIER_GOV_BO.

Data Sources (1)

SourceAliasJoin Type
bph_node bph_node from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID and _BusinessPartner.BusinessPartnerCategory = '2'

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business Partner Hierarchy Node view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY BPHierarchyNodeUUID bph_node hierarchy_node_uuid
BusinessPartnerHierarchyUUID bph_node hierarchy_uuid
BusinessPartnerUUID bph_node business_partner_uuid
BPHierarchyNodeDisplayID bph_node hierarchy_node_display_id
BPHierarchyNodeCreatedBy bph_node created_by Version Created By
BPHierarchyNodeCreatedDateTime bph_node created_at Uploaded On
BPHierarchyNodeLastChangedBy bph_node last_changed_by Username
BPHierNodeLastChangedDateTime bph_node last_changed_at Timestamp
HierarchyID _Hierarchy BPHierarchyDisplayID
HierarchyType _Hierarchy BPHierarchyDataType
BusinessPartnerelseendasBusinessPartner
BusinessPartnerName _BusinessPartner BusinessPartnerName Extracted Customer Name

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 I_BPHierarchyNodeData.
-- 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.

CREATE VIEW I_BPHierarchyNodeData AS
SELECT
  bph_node.hierarchy_node_uuid AS BPHierarchyNodeUUID,
  bph_node.hierarchy_uuid AS BusinessPartnerHierarchyUUID,
  bph_node.business_partner_uuid AS BusinessPartnerUUID,
  bph_node.hierarchy_node_display_id AS BPHierarchyNodeDisplayID,
  bph_node.created_by AS BPHierarchyNodeCreatedBy,
  bph_node.created_at AS BPHierarchyNodeCreatedDateTime,
  bph_node.last_changed_by AS BPHierarchyNodeLastChangedBy,
  bph_node.last_changed_at AS BPHierNodeLastChangedDateTime,
  _Hierarchy.BPHierarchyDisplayID AS HierarchyID,
  _Hierarchy.BPHierarchyDataType AS HierarchyType,
  case when bph_node.business_partner_uuid <> hextobin('00000000000000000000000000000000') then _BusinessPartner.BusinessPartner else '' end as BusinessPartner AS BusinessPartnerelseendasBusinessPartner,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName
FROM bph_node
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID AND _BusinessPartner.BusinessPartnerCategory = '2'  -- association [0..1]
;

Learn More