C_BPHierarchyNodeGovernanceTP

DDL: C_BPHIERARCHYNODEGOVERNANCETP Type: view_entity
27 Fields 1 Data Sources 2 Associations

Projection of BPH Node (Governance)

C_BPHierarchyNodeGovernanceTP is a CDS View that provides data about "Projection of BPH Node (Governance)" in SAP S/4HANA. It reads from 1 data source (I_BPHierarchyNodeGovernanceTP) and exposes 27 fields with key fields MasterDataChangeProcess, MDChgProcessSrceSystem, MDChgProcessSrceObject. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BPHierarchyNodeGovernanceTP I_BPHierarchyNodeGovernanceTP projection

Associations (2)

CardinalityTargetAliasCondition
[1] I_BPHierarchyGovernanceTP _Hierarchy $projection.MasterDataChangeProcess = _Hierarchy.MasterDataChangeProcess and $projection.MDChgProcessSrceSystem = _Hierarchy.MDChgProcessSrceSystem and $projection.BusinessPartnerHierarchyUUID = _Hierarchy.BusinessPartnerHierarchyUUID
[0..*] C_BPHierNodeProcChangesUnion _Changes $projection.MasterDataChangeProcess = _Changes.MasterDataChangeProcess and $projection.MDChgProcessStep = _Changes.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Projection of BPH Node (Governance) view
Metadata.allowExtensions true view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
MDChgProcessStep MDChgProcessStep Step Number
BPHierarchyNodeUUID BPHierarchyNodeUUID
BusinessPartnerHierarchyUUID BusinessPartnerHierarchyUUID
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName BusinessPartnerName Extracted Customer Name
BusinessPartnerUUID BusinessPartnerUUID UUID
BPHierarchyNodeDisplayID BPHierarchyNodeDisplayID
BPHierarchyNodeCreatedBy BPHierarchyNodeCreatedBy
BPHierarchyNodeCreatedDateTime BPHierarchyNodeCreatedDateTime
BPHierarchyNodeLastChangedBy BPHierarchyNodeLastChangedBy
BPHierNodeLastChangedDateTime BPHierNodeLastChangedDateTime
MDChgProcessSourceModified MDChgProcessSourceModified Modified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
MDChgProcessValidationStatus MDChgProcessValidationStatus
MasterDataCreatedByFullName MasterDataCreatedByFullName Name
MasterDataChangedByFullName MasterDataChangedByFullName Name
int8
BPHierarchyNodeDescription _HierarchyNodeDescription BPHierarchyNodeDescription
MDChgProcessDescModified _HierarchyNodeDescription MDChgProcessSourceModified Modified
MDChgProcessTimeSliceModified _HierarchyNodeTS MDChgProcessSourceModified Modified
_Hierarchy _Hierarchy
_Changes _Changes
_BPHNLastChangedByContactCard _BPHNLastChangedByContactCard
_BPHNCreatedByContactCard _BPHNCreatedByContactCard

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 C_BPHierarchyNodeGovernanceTP.
-- 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 C_BPHierarchyNodeGovernanceTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  MDChgProcessStep,
  BPHierarchyNodeUUID,
  BusinessPartnerHierarchyUUID,
  BusinessPartner,
  BusinessPartnerName,
  BusinessPartnerUUID,
  BPHierarchyNodeDisplayID,
  BPHierarchyNodeCreatedBy,
  BPHierarchyNodeCreatedDateTime,
  BPHierarchyNodeLastChangedBy,
  BPHierNodeLastChangedDateTime,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  MDChgProcessValidationStatus,
  MasterDataCreatedByFullName,
  MasterDataChangedByFullName,
  virtual BPHierarchyNodeNumberOfChilds : abap.int8 AS int8,
  _HierarchyNodeDescription.BPHierarchyNodeDescription AS BPHierarchyNodeDescription,
  _HierarchyNodeDescription.MDChgProcessSourceModified AS MDChgProcessDescModified,
  _HierarchyNodeTS.MDChgProcessSourceModified AS MDChgProcessTimeSliceModified
FROM I_BPHierarchyNodeGovernanceTP
LEFT OUTER JOIN I_BPHierarchyGovernanceTP AS _Hierarchy ON MasterDataChangeProcess = _Hierarchy.MasterDataChangeProcess AND MDChgProcessSrceSystem = _Hierarchy.MDChgProcessSrceSystem AND BusinessPartnerHierarchyUUID = _Hierarchy.BusinessPartnerHierarchyUUID  -- association [1]
LEFT OUTER JOIN C_BPHierNodeProcChangesUnion AS _Changes ON MasterDataChangeProcess = _Changes.MasterDataChangeProcess AND MDChgProcessStep = _Changes.MDChgProcessStep AND MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject  -- association [0..*]
;

Learn More