I_BPHierarchyNodeGovernanceTP

DDL: I_BPHIERARCHYNODEGOVERNANCETP Type: view_entity
27 Fields 1 Data Sources 6 Associations

BP Hierarchy Node (Governance) - TP

I_BPHierarchyNodeGovernanceTP is a CDS View that provides data about "BP Hierarchy Node (Governance) - TP" in SAP S/4HANA. It reads from 1 data source (I_BPHierarchyNodeGovernance) and exposes 27 fields with key fields MasterDataChangeProcess, MDChgProcessSrceSystem, MDChgProcessSrceObject. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BPHierarchyNodeGovernance Governance from

Associations (6)

CardinalityTargetAliasCondition
[1] I_BPHierarchyGovernanceTP _Hierarchy $projection.MasterDataChangeProcess = _Hierarchy.MasterDataChangeProcess and $projection.BusinessPartnerHierarchyUUID = _Hierarchy.BusinessPartnerHierarchyUUID
[0..1] I_MDCloudUserContactCard _BPHNCreatedByContactCard $projection.BPHierarchyNodeCreatedBy = _BPHNCreatedByContactCard.ContactCardID
[0..1] I_MDCloudUserContactCard _BPHNLastChangedByContactCard $projection.BPHierarchyNodeLastChangedBy = _BPHNLastChangedByContactCard.ContactCardID
[0..1] I_BPHierNodeChangeProcessGovTP _Process
[0..1] I_BPHierNodeDescriptionGovTP _HierarchyNodeDescription
[0..1] I_BPHierNodeTimeSliceGovTP _HierarchyNodeTS

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label BP Hierarchy Node (Governance) - TP 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
MDChgProcessGoal MDChgProcessGoal Process Goal
BPHierarchyNodeUUID BPHierarchyNodeUUID
MDChgProcSrceObjBPHierarchy MDChgProcSrceObjBPHierarchy
BusinessPartnerHierarchyUUID BusinessPartnerHierarchyUUID
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerUUID BusinessPartnerUUID UUID
BPHierarchyNodeDisplayID BPHierarchyNodeDisplayID
BusinessPartnerName BusinessPartnerName Extracted Customer Name
BPHierarchyNodeCreatedBy BPHierarchyNodeCreatedBy
BPHierarchyNodeCreatedDateTime BPHierarchyNodeCreatedDateTime
BPHierarchyNodeLastChangedBy BPHierarchyNodeLastChangedBy
BPHierNodeLastChangedDateTime BPHierNodeLastChangedDateTime
MDChgProcessSourceModified MDChgProcessSourceModified Modified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
MDChgProcessValidationStatus MDChgProcessValidationStatus
MasterDataCreatedByFullName _BPHNCreatedByContactCard FullName Name
MasterDataChangedByFullName _BPHNLastChangedByContactCard FullName Name
_Process _Process
_HierarchyNodeDescription _HierarchyNodeDescription
_HierarchyNodeTS _HierarchyNodeTS
_Hierarchy _Hierarchy
_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 I_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 I_BPHierarchyNodeGovernanceTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  MDChgProcessStep,
  MDChgProcessGoal,
  BPHierarchyNodeUUID,
  MDChgProcSrceObjBPHierarchy,
  BusinessPartnerHierarchyUUID,
  BusinessPartner,
  BusinessPartnerUUID,
  BPHierarchyNodeDisplayID,
  BusinessPartnerName,
  BPHierarchyNodeCreatedBy,
  BPHierarchyNodeCreatedDateTime,
  BPHierarchyNodeLastChangedBy,
  BPHierNodeLastChangedDateTime,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  MDChgProcessValidationStatus,
  _BPHNCreatedByContactCard.FullName AS MasterDataCreatedByFullName,
  _BPHNLastChangedByContactCard.FullName AS MasterDataChangedByFullName
FROM I_BPHierarchyNodeGovernance AS Governance
LEFT OUTER JOIN I_BPHierarchyGovernanceTP AS _Hierarchy ON MasterDataChangeProcess = _Hierarchy.MasterDataChangeProcess AND BusinessPartnerHierarchyUUID = _Hierarchy.BusinessPartnerHierarchyUUID  -- association [1]
LEFT OUTER JOIN I_MDCloudUserContactCard AS _BPHNCreatedByContactCard ON BPHierarchyNodeCreatedBy = _BPHNCreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_MDCloudUserContactCard AS _BPHNLastChangedByContactCard ON BPHierarchyNodeLastChangedBy = _BPHNLastChangedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_BPHierNodeChangeProcessGovTP AS _Process ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_BPHierNodeDescriptionGovTP AS _HierarchyNodeDescription ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_BPHierNodeTimeSliceGovTP AS _HierarchyNodeTS ON /* condition not available in parsed metadata */  -- association [0..1]
;

Learn More