I_BPHierarchyNodeDataTP

DDL: I_BPHIERARCHYNODEDATATP Type: view_entity Package: MDC_BP_HIER_GOV_BO
16 Fields 1 Data Sources 2 Associations

Business Partner Hierarchy Node - TP

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

Data Sources (1)

SourceAliasJoin Type
I_BPHierarchyNodeData I_BPHierarchyNodeData from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_BPHierNodeDataTimeSliceTP _HierarchyNodeTS
[0..*] I_BPHierNodeDataDescriptionTP _HierarchyNodeDescription

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business Partner Hierarchy Node - TP view
Search.searchable true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY BPHierarchyNodeUUID BPHierarchyNodeUUID
BPHierarchyNodeUUIDForEdit BPHierarchyNodeUUID
BusinessPartnerHierarchyUUID BusinessPartnerHierarchyUUID
BusinessPartnerUUID BusinessPartnerUUID UUID
BPHierarchyNodeDisplayID BPHierarchyNodeDisplayID
BPHierarchyNodeCreatedBy BPHierarchyNodeCreatedBy Version Created By
BPHierarchyNodeCreatedDateTime BPHierarchyNodeCreatedDateTime Uploaded On
BPHierarchyNodeLastChangedBy BPHierarchyNodeLastChangedBy Username
BPHierNodeLastChangedDateTime BPHierNodeLastChangedDateTime Timestamp
HierarchyID HierarchyID Hierarchy ID
HierarchyType HierarchyType Hierarchy Type
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName BusinessPartnerName Extracted Customer Name
_HierarchyNodeTS _HierarchyNodeTS
_Hierarchy _Hierarchy
_HierarchyNodeDescription _HierarchyNodeDescription

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_BPHierarchyNodeDataTP.
-- 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_BPHierarchyNodeDataTP AS
SELECT
  BPHierarchyNodeUUID,
  BPHierarchyNodeUUID AS BPHierarchyNodeUUIDForEdit,
  BusinessPartnerHierarchyUUID,
  BusinessPartnerUUID,
  BPHierarchyNodeDisplayID,
  BPHierarchyNodeCreatedBy,
  BPHierarchyNodeCreatedDateTime,
  BPHierarchyNodeLastChangedBy,
  BPHierNodeLastChangedDateTime,
  HierarchyID,
  HierarchyType,
  BusinessPartner,
  BusinessPartnerName
FROM I_BPHierarchyNodeData
LEFT OUTER JOIN I_BPHierNodeDataTimeSliceTP AS _HierarchyNodeTS ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPHierNodeDataDescriptionTP AS _HierarchyNodeDescription ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More