I_BusPartRelationshipGov

DDL: I_BUSPARTRELATIONSHIPGOV Type: view_entity COMPOSITE Package: MDC_BP_REL_GOV_BO
135 Fields 2 Data Sources 1 Associations

Business Partner Relationship Governance

I_BusPartRelationshipGov is a Composite CDS View that provides data about "Business Partner Relationship Governance" in SAP S/4HANA. It reads from 2 data sources (I_BusPartRelationshipProcess, I_BusPartRelationshipProcess) and exposes 135 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, BPRelshpCatIsInFwdDirection. It has 1 association to related views. Part of development package MDC_BP_REL_GOV_BO.

Data Sources (2)

SourceAliasJoin Type
I_BusPartRelationshipProcess BPRelProcess from
I_BusPartRelationshipProcess BPRelProcess union_all

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MasterDataChangeProcess _MasterDataChangeProcess $projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business Partner Relationship Governance view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (135)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess I_BusPartRelationshipProcess MasterDataChangeProcess Process ID
KEY MDChgProcessStep I_BusPartRelationshipProcess MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem I_BusPartRelationshipProcess MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject I_BusPartRelationshipProcess MDChgProcessSrceObject Source ID
KEY BPRelshpCatIsInFwdDirection
BusinessPartner1 I_BusPartRelationshipProcess MDChgProcessSrceBusPart1 Partner
BusinessPartner2 I_BusPartRelationshipProcess MDChgProcessSrceBusPart2 Partner
RelationshipCategory I_BusPartRelationshipProcess RelationshipCategory Relationsh.Cat.
BP1AuthorizationGroup I_BusPartRelationshipProcess BP1AuthorizationGroup AuthorizGroup
BP1DataControllerSet I_BusPartRelationshipProcess BP1DataControllerSet Data Ctrlr. Set
BP1DataController1 I_BusPartRelationshipProcess BP1DataController1 Data Controller
BP1DataController2 I_BusPartRelationshipProcess BP1DataController2 Data Controller
BP1DataController3 I_BusPartRelationshipProcess BP1DataController3 Data Controller
BP1DataController4 I_BusPartRelationshipProcess BP1DataController4 Data Controller
BP1DataController5 I_BusPartRelationshipProcess BP1DataController5 Data Controller
BP1DataController6 I_BusPartRelationshipProcess BP1DataController6 Data Controller
BP1DataController7 I_BusPartRelationshipProcess BP1DataController7 Data Controller
BP1DataController8 I_BusPartRelationshipProcess BP1DataController8 Data Controller
BP1DataController9 I_BusPartRelationshipProcess BP1DataController9 Data Controller
BP1DataController10 I_BusPartRelationshipProcess BP1DataController10 Data Controller
BP2AuthorizationGroup I_BusPartRelationshipProcess BP2AuthorizationGroup AuthorizGroup
BP2DataControllerSet I_BusPartRelationshipProcess BP2DataControllerSet Data Ctrlr. Set
BP2DataController1 I_BusPartRelationshipProcess BP2DataController1 Data Controller
BP2DataController2 I_BusPartRelationshipProcess BP2DataController2 Data Controller
BP2DataController3 I_BusPartRelationshipProcess BP2DataController3 Data Controller
BP2DataController4 I_BusPartRelationshipProcess BP2DataController4 Data Controller
BP2DataController5 I_BusPartRelationshipProcess BP2DataController5 Data Controller
BP2DataController6 I_BusPartRelationshipProcess BP2DataController6 Data Controller
BP2DataController7 I_BusPartRelationshipProcess BP2DataController7 Data Controller
BP2DataController8 I_BusPartRelationshipProcess BP2DataController8 Data Controller
BP2DataController9 I_BusPartRelationshipProcess BP2DataController9 Data Controller
BP2DataController10 I_BusPartRelationshipProcess BP2DataController10 Data Controller
BusinessPartnerCategory I_BusPartRelationshipProcess BusinessPartnerCategory Partner Cat.
BusinessPartnerGrouping
MasterDataChangeProcess Process ID
KEY MDChgProcessStep I_BusPartRelationshipProcess MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem I_BusPartRelationshipProcess MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject I_BusPartRelationshipProcess MDChgProcessSrceObject Source ID
KEY BPRelshpCatIsInFwdDirection
BusinessPartner1 I_BusPartRelationshipProcess MDChgProcessSrceBusPart2 Partner
BusinessPartner2 I_BusPartRelationshipProcess MDChgProcessSrceBusPart1 Partner
RelationshipCategory I_BusPartRelationshipProcess RelationshipCategory Relationsh.Cat.
BP1AuthorizationGroup I_BusPartRelationshipProcess BP2AuthorizationGroup AuthorizGroup
BP1DataControllerSet I_BusPartRelationshipProcess BP2DataControllerSet Data Ctrlr. Set
BP1DataController1 I_BusPartRelationshipProcess BP2DataController1 Data Controller
BP1DataController2 I_BusPartRelationshipProcess BP2DataController2 Data Controller
BP1DataController3 I_BusPartRelationshipProcess BP2DataController3 Data Controller
BP1DataController4 I_BusPartRelationshipProcess BP2DataController4 Data Controller
BP1DataController5 I_BusPartRelationshipProcess BP2DataController5 Data Controller
BP1DataController6 I_BusPartRelationshipProcess BP2DataController6 Data Controller
BP1DataController7 I_BusPartRelationshipProcess BP2DataController7 Data Controller
BP1DataController8 I_BusPartRelationshipProcess BP2DataController8 Data Controller
BP1DataController9 I_BusPartRelationshipProcess BP2DataController9 Data Controller
BP1DataController10 I_BusPartRelationshipProcess BP2DataController10 Data Controller
BP2AuthorizationGroup I_BusPartRelationshipProcess BP2AuthorizationGroup AuthorizGroup
BP2DataControllerSet I_BusPartRelationshipProcess BP1DataControllerSet Data Ctrlr. Set
BP2DataController1 I_BusPartRelationshipProcess BP1DataController1 Data Controller
BP2DataController2 I_BusPartRelationshipProcess BP1DataController2 Data Controller
BP2DataController3 I_BusPartRelationshipProcess BP1DataController3 Data Controller
BP2DataController4 I_BusPartRelationshipProcess BP1DataController4 Data Controller
BP2DataController5 I_BusPartRelationshipProcess BP1DataController5 Data Controller
BP2DataController6 I_BusPartRelationshipProcess BP1DataController6 Data Controller
BP2DataController7 I_BusPartRelationshipProcess BP1DataController7 Data Controller
BP2DataController8 I_BusPartRelationshipProcess BP1DataController8 Data Controller
BP2DataController9 I_BusPartRelationshipProcess BP1DataController9 Data Controller
BP2DataController10 I_BusPartRelationshipProcess BP1DataController10 Data Controller
BusinessPartnerCategory Partner Cat.
BusinessPartnerGrouping
KEY MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject Source ID
KEY BPRelshpCatIsInFwdDirection
BusinessPartner1 BusinessPartner1 Partner
BusinessPartner2 BusinessPartner2 Partner
RelationshipCategory RelationshipCategory Relationsh.Cat.
BP1AuthorizationGroup _BusinessPartner1 AuthorizationGroup AuthorizGroup
BP1DataControllerSet _BusinessPartner1 DataControllerSet Data Ctrlr. Set
BP1DataController1 _BusinessPartner1 DataController1 Data Controller
BP1DataController2 _BusinessPartner1 DataController2 Data Controller
BP1DataController3 _BusinessPartner1 DataController3 Data Controller
BP1DataController4 _BusinessPartner1 DataController4 Data Controller
BP1DataController5 _BusinessPartner1 DataController5 Data Controller
BP1DataController6 _BusinessPartner1 DataController6 Data Controller
BP1DataController7 _BusinessPartner1 DataController7 Data Controller
BP1DataController8 _BusinessPartner1 DataController8 Data Controller
BP1DataController9 _BusinessPartner1 DataController9 Data Controller
BP1DataController10 _BusinessPartner1 DataController10 Data Controller
BP2AuthorizationGroup _BusinessPartner2 AuthorizationGroup AuthorizGroup
BP2DataControllerSet _BusinessPartner2 DataControllerSet Data Ctrlr. Set
BP2DataController1 _BusinessPartner2 DataController1 Data Controller
BP2DataController2 _BusinessPartner2 DataController2 Data Controller
BP2DataController3 _BusinessPartner2 DataController3 Data Controller
BP2DataController4 _BusinessPartner2 DataController4 Data Controller
BP2DataController5 _BusinessPartner2 DataController5 Data Controller
BP2DataController6 _BusinessPartner2 DataController6 Data Controller
BP2DataController7 _BusinessPartner2 DataController7 Data Controller
BP2DataController8 _BusinessPartner2 DataController8 Data Controller
BP2DataController9 _BusinessPartner2 DataController9 Data Controller
BP2DataController10 _BusinessPartner2 DataController10 Data Controller
BusinessPartnerCategory _BusinessPartner1 BusinessPartnerCategory Partner Cat.
BusinessPartnerGrouping
KEY MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject Source ID
KEY BPRelshpCatIsInFwdDirection
BusinessPartner1 BusinessPartner2 Partner
BusinessPartner2 BusinessPartner1 Partner
RelationshipCategory RelationshipCategory Relationsh.Cat.
BP1AuthorizationGroup _BusinessPartner2 AuthorizationGroup AuthorizGroup
BP1DataControllerSet _BusinessPartner1 DataControllerSet Data Ctrlr. Set
BP1DataController1 _BusinessPartner1 DataController1 Data Controller
BP1DataController2 _BusinessPartner1 DataController2 Data Controller
BP1DataController3 _BusinessPartner1 DataController3 Data Controller
BP1DataController4 _BusinessPartner1 DataController4 Data Controller
BP1DataController5 _BusinessPartner1 DataController5 Data Controller
BP1DataController6 _BusinessPartner1 DataController6 Data Controller
BP1DataController7 _BusinessPartner1 DataController7 Data Controller
BP1DataController8 _BusinessPartner1 DataController8 Data Controller
BP1DataController9 _BusinessPartner1 DataController9 Data Controller
BP1DataController10 _BusinessPartner1 DataController10 Data Controller
BP2AuthorizationGroup _BusinessPartner1 AuthorizationGroup AuthorizGroup
BP2DataControllerSet _BusinessPartner2 DataControllerSet Data Ctrlr. Set
BP2DataController1 _BusinessPartner2 DataController1 Data Controller
BP2DataController2 _BusinessPartner2 DataController2 Data Controller
BP2DataController3 _BusinessPartner2 DataController3 Data Controller
BP2DataController4 _BusinessPartner2 DataController4 Data Controller
BP2DataController5 _BusinessPartner2 DataController5 Data Controller
BP2DataController6 _BusinessPartner2 DataController6 Data Controller
BP2DataController7 _BusinessPartner2 DataController7 Data Controller
BP2DataController8 _BusinessPartner2 DataController8 Data Controller
BP2DataController9 _BusinessPartner2 DataController9 Data Controller
BP2DataController10 _BusinessPartner2 DataController10 Data Controller
BusinessPartnerCategory _BusinessPartner2 BusinessPartnerCategory Partner Cat.
BusinessPartnerGrouping
MasterDataIsCurrent

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_BusPartRelationshipGov.
-- 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_BusPartRelationshipGov AS
SELECT
  BPRelProcess.MasterDataChangeProcess AS MasterDataChangeProcess,
  BPRelProcess.MDChgProcessStep AS MDChgProcessStep,
  BPRelProcess.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
  BPRelProcess.MDChgProcessSrceObject AS MDChgProcessSrceObject,
  cast( 'X' as boolean ) AS BPRelshpCatIsInFwdDirection,
  BPRelProcess.MDChgProcessSrceBusPart1 AS BusinessPartner1,
  BPRelProcess.MDChgProcessSrceBusPart2 AS BusinessPartner2,
  BPRelProcess.RelationshipCategory AS RelationshipCategory,
  BPRelProcess.BP1AuthorizationGroup AS BP1AuthorizationGroup,
  BPRelProcess.BP1DataControllerSet AS BP1DataControllerSet,
  BPRelProcess.BP1DataController1 AS BP1DataController1,
  BPRelProcess.BP1DataController2 AS BP1DataController2,
  BPRelProcess.BP1DataController3 AS BP1DataController3,
  BPRelProcess.BP1DataController4 AS BP1DataController4,
  BPRelProcess.BP1DataController5 AS BP1DataController5,
  BPRelProcess.BP1DataController6 AS BP1DataController6,
  BPRelProcess.BP1DataController7 AS BP1DataController7,
  BPRelProcess.BP1DataController8 AS BP1DataController8,
  BPRelProcess.BP1DataController9 AS BP1DataController9,
  BPRelProcess.BP1DataController10 AS BP1DataController10,
  BPRelProcess.BP2AuthorizationGroup AS BP2AuthorizationGroup,
  BPRelProcess.BP2DataControllerSet AS BP2DataControllerSet,
  BPRelProcess.BP2DataController1 AS BP2DataController1,
  BPRelProcess.BP2DataController2 AS BP2DataController2,
  BPRelProcess.BP2DataController3 AS BP2DataController3,
  BPRelProcess.BP2DataController4 AS BP2DataController4,
  BPRelProcess.BP2DataController5 AS BP2DataController5,
  BPRelProcess.BP2DataController6 AS BP2DataController6,
  BPRelProcess.BP2DataController7 AS BP2DataController7,
  BPRelProcess.BP2DataController8 AS BP2DataController8,
  BPRelProcess.BP2DataController9 AS BP2DataController9,
  BPRelProcess.BP2DataController10 AS BP2DataController10,
  BPRelProcess.BusinessPartnerCategory AS BusinessPartnerCategory,
  cast( ' ' as bu_group ) AS BusinessPartnerGrouping,
  cast( 'X' as abap_boolean preserving type ) AS MasterDataIsCurrent
FROM I_BusPartRelationshipProcess AS BPRelProcess
LEFT OUTER JOIN I_MasterDataChangeProcess AS _MasterDataChangeProcess ON MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess  -- association [0..1]
-- UNION ALL with additional select branch(es): I_BusPartRelationshipProcess
;

Learn More