I_BUSPARTRELATIONSHIPGOV
Business Partner Relationship Governance
I_BUSPARTRELATIONSHIPGOV is a CDS View in S/4HANA. Business Partner Relationship Governance. It contains 33 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BPRelshpChangeProcessGov | view_entity | inner | TRANSACTIONAL | Business Partner Relationship Change Process Governance |
| I_BusPartContactPersonGovTP | view_entity | from | TRANSACTIONAL | BP Relationship Contact Person Data - TP |
| I_BusPartRelationshipGovTP | view_entity | from | TRANSACTIONAL | Business Partner Relationship Gov - TP |
Fields (33)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BPRelshpCatIsInFwdDirection | BPRelshpCatIsInFwdDirection,BPRelshpCatIsInFwdDrctnForEdit | 3 |
| KEY | MasterDataChangeProcess | MasterDataChangeProcess,MasterDataChangeProcessForEdit | 3 |
| KEY | MDChgProcessSrceObject | MDChgProcessSrceObject | 3 |
| KEY | MDChgProcessSrceSystem | MDChgProcessSrceSystem | 3 |
| KEY | MDChgProcessStep | MDChgProcessStep | 3 |
| BP1AuthorizationGroup | BP1AuthorizationGroup | 2 | |
| BP1DataController1 | BP1DataController1 | 1 | |
| BP1DataController10 | BP1DataController10 | 1 | |
| BP1DataController2 | BP1DataController2 | 1 | |
| BP1DataController3 | BP1DataController3 | 1 | |
| BP1DataController4 | BP1DataController4 | 1 | |
| BP1DataController5 | BP1DataController5 | 1 | |
| BP1DataController6 | BP1DataController6 | 1 | |
| BP1DataController7 | BP1DataController7 | 1 | |
| BP1DataController8 | BP1DataController8 | 1 | |
| BP1DataController9 | BP1DataController9 | 1 | |
| BP1DataControllerSet | BP1DataControllerSet | 1 | |
| BP2AuthorizationGroup | BP2AuthorizationGroup | 2 | |
| BP2DataController1 | BP2DataController1 | 1 | |
| BP2DataController10 | BP2DataController10 | 1 | |
| BP2DataController2 | BP2DataController2 | 1 | |
| BP2DataController3 | BP2DataController3 | 1 | |
| BP2DataController4 | BP2DataController4 | 1 | |
| BP2DataController5 | BP2DataController5 | 1 | |
| BP2DataController6 | BP2DataController6 | 1 | |
| BP2DataController7 | BP2DataController7 | 1 | |
| BP2DataController8 | BP2DataController8 | 1 | |
| BP2DataController9 | BP2DataController9 | 1 | |
| BP2DataControllerSet | BP2DataControllerSet | 1 | |
| BusinessPartner1 | BusinessPartner1 | 2 | |
| BusinessPartner2 | BusinessPartner2 | 2 | |
| BusinessPartnerCategory | BusinessPartnerCategory | 1 | |
| RelationshipCategory | RelationshipCategory | 1 |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Business Partner Relationship Governance'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #S,
dataClass: #MIXED
}
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] } */
define view entity I_BusPartRelationshipGov
as select from I_BusPartRelationshipProcess as BPRelProcess
// association [0..1] to I_BusinessPartnerGov as _BusinessPartner2InProcess on $projection.MDChgProcessStep = _BusinessPartner2InProcess.MDChgProcessStep
// and $projection.MasterDataChangeProcess = _BusinessPartner2InProcess.MasterDataChangeProcess
// and $projection.BusinessPartner2 = _BusinessPartner2InProcess.MDChgProcessSrceObject
//
//
// association [0..1] to I_BusinessPartner as _BusinessPartner2Active on $projection.BusinessPartner2 = _BusinessPartner2Active.BusinessPartner
association [0..1] to I_MasterDataChangeProcess as _MasterDataChangeProcess on $projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess
{
key BPRelProcess.MasterDataChangeProcess,
key BPRelProcess.MDChgProcessStep,
key BPRelProcess.MDChgProcessSrceSystem,
key BPRelProcess.MDChgProcessSrceObject,
key cast( 'X' as boolean ) as BPRelshpCatIsInFwdDirection,
BPRelProcess.MDChgProcessSrceBusPart1 as BusinessPartner1,
BPRelProcess.MDChgProcessSrceBusPart2 as BusinessPartner2,
BPRelProcess.RelationshipCategory,
BPRelProcess.BP1AuthorizationGroup,
BPRelProcess.BP1DataControllerSet,
BPRelProcess.BP1DataController1,
BPRelProcess.BP1DataController2,
BPRelProcess.BP1DataController3,
BPRelProcess.BP1DataController4,
BPRelProcess.BP1DataController5,
BPRelProcess.BP1DataController6,
BPRelProcess.BP1DataController7,
BPRelProcess.BP1DataController8,
BPRelProcess.BP1DataController9,
BPRelProcess.BP1DataController10,
BPRelProcess.BP2AuthorizationGroup,
BPRelProcess.BP2DataControllerSet,
BPRelProcess.BP2DataController1,
BPRelProcess.BP2DataController2,
BPRelProcess.BP2DataController3,
BPRelProcess.BP2DataController4,
BPRelProcess.BP2DataController5,
BPRelProcess.BP2DataController6,
BPRelProcess.BP2DataController7,
BPRelProcess.BP2DataController8,
BPRelProcess.BP2DataController9,
BPRelProcess.BP2DataController10,
BPRelProcess.BusinessPartnerCategory,
cast( ' ' as bu_group ) as BusinessPartnerGrouping,
cast(
case when BPRelProcess.MDChgProcessStep = _MasterDataChangeProcess.MDChgProcessCurrentStepNumber and _MasterDataChangeProcess.MDChgProcessCurrentStepNumber <> '0000' or
BPRelProcess.MDChgProcessStep = '0001' and _MasterDataChangeProcess.MDChgProcessCurrentStepNumber = '0000' then 'X'
else ' '
end as abap_boolean preserving type
) as MasterDataIsCurrent
// _BusinessPartner2InProcess,
// _BusinessPartner2Active
}
where
BPRelProcess.MDChgProcessSourceModified <> 'D'
union all
select from I_BusPartRelationshipProcess as BPRelProcess
//association [0..1] to I_BusinessPartnerGov as _BusinessPartner2InProcess on $projection.MDChgProcessStep = _BusinessPartner2InProcess.MDChgProcessStep
// and $projection.MasterDataChangeProcess = _BusinessPartner2InProcess.MasterDataChangeProcess
// and $projection.BusinessPartner2 = _BusinessPartner2InProcess.MDChgProcessSrceObject
//
//
//association [0..1] to I_BusinessPartner as _BusinessPartner2Active on $projection.BusinessPartner2 = _BusinessPartner2Active.BusinessPartner
association [0..1] to I_MasterDataChangeProcess as _MasterDataChangeProcess on $projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess
{
key BPRelProcess.MasterDataChangeProcess,
key BPRelProcess.MDChgProcessStep,
key BPRelProcess.MDChgProcessSrceSystem,
key BPRelProcess.MDChgProcessSrceObject,
key cast( ' ' as boolean ) as BPRelshpCatIsInFwdDirection,
BPRelProcess.MDChgProcessSrceBusPart2 as BusinessPartner1,
BPRelProcess.MDChgProcessSrceBusPart1 as BusinessPartner2,
BPRelProcess.RelationshipCategory,
BPRelProcess.BP2AuthorizationGroup as BP1AuthorizationGroup,
BPRelProcess.BP2DataControllerSet as BP1DataControllerSet,
BPRelProcess.BP2DataController1 as BP1DataController1,
BPRelProcess.BP2DataController2 as BP1DataController2,
BPRelProcess.BP2DataController3 as BP1DataController3,
BPRelProcess.BP2DataController4 as BP1DataController4,
BPRelProcess.BP2DataController5 as BP1DataController5,
BPRelProcess.BP2DataController6 as BP1DataController6,
BPRelProcess.BP2DataController7 as BP1DataController7,
BPRelProcess.BP2DataController8 as BP1DataController8,
BPRelProcess.BP2DataController9 as BP1DataController9,
BPRelProcess.BP2DataController10 as BP1DataController10,
BPRelProcess.BP2AuthorizationGroup as BP2AuthorizationGroup,
BPRelProcess.BP1DataControllerSet as BP2DataControllerSet,
BPRelProcess.BP1DataController1 as BP2DataController1,
BPRelProcess.BP1DataController2 as BP2DataController2,
BPRelProcess.BP1DataController3 as BP2DataController3,
BPRelProcess.BP1DataController4 as BP2DataController4,
BPRelProcess.BP1DataController5 as BP2DataController5,
BPRelProcess.BP1DataController6 as BP2DataController6,
BPRelProcess.BP1DataController7 as BP2DataController7,
BPRelProcess.BP1DataController8 as BP2DataController8,
BPRelProcess.BP1DataController9 as BP2DataController9,
BPRelProcess.BP1DataController10 as BP2DataController10,
BPRelProcess._BusinessPartner2.BusinessPartnerCategory,
cast( ' ' as bu_group ) as BusinessPartnerGrouping,
cast(
case when BPRelProcess.MDChgProcessStep = _MasterDataChangeProcess.MDChgProcessCurrentStepNumber and _MasterDataChangeProcess.MDChgProcessCurrentStepNumber <> '0000' or
BPRelProcess.MDChgProcessStep = '0001' and _MasterDataChangeProcess.MDChgProcessCurrentStepNumber = '0000' then 'X'
else ' '
end as abap_boolean preserving type
) as MasterDataIsCurrent
// _BusinessPartner2InProcess,
// _BusinessPartner2Active
}
where
BPRelProcess.MDChgProcessSourceModified <> 'D'
union all
select distinct from I_BPRelationship_2 as BPRelationShip
//association [0..1] to I_BusinessPartnerGov as _BusinessPartner2InProcess on $projection.MDChgProcessStep = _BusinessPartner2InProcess.MDChgProcessStep
// and $projection.MasterDataChangeProcess = _BusinessPartner2InProcess.MasterDataChangeProcess
// and $projection.BusinessPartner2 = _BusinessPartner2InProcess.MDChgProcessSrceObject
//
//
//association [0..1] to I_BusinessPartner as _BusinessPartner2Active on $projection.BusinessPartner2 = _BusinessPartner2Active.BusinessPartner
{
key '000000000000' as MasterDataChangeProcess,
key '0000' as MDChgProcessStep,
key '' as MDChgProcessSrceSystem,
key cast( concat( BusinessPartner1, concat( '$$', concat( BusinessPartner2, concat( '$$', RelationshipCategory ) ) ) ) as mdc_source_id ) as MDChgProcessSrceObject,
key cast( 'X' as boolean ) as BPRelshpCatIsInFwdDirection,
BusinessPartner1,
BusinessPartner2,
RelationshipCategory,
_BusinessPartner1.AuthorizationGroup as BP1AuthorizationGroup,
_BusinessPartner1.DataControllerSet as BP1DataControllerSet,
_BusinessPartner1.DataController1 as BP1DataController1,
_BusinessPartner1.DataController2 as BP1DataController2,
_BusinessPartner1.DataController3 as BP1DataController3,
_BusinessPartner1.DataController4 as BP1DataController4,
_BusinessPartner1.DataController5 as BP1DataController5,
_BusinessPartner1.DataController6 as BP1DataController6,
_BusinessPartner1.DataController7 as BP1DataController7,
_BusinessPartner1.DataController8 as BP1DataController8,
_BusinessPartner1.DataController9 as BP1DataController9,
_BusinessPartner1.DataController10 as BP1DataController10,
_BusinessPartner2.AuthorizationGroup as BP2AuthorizationGroup,
_BusinessPartner2.DataControllerSet as BP2DataControllerSet,
_BusinessPartner2.DataController1 as BP2DataController1,
_BusinessPartner2.DataController2 as BP2DataController2,
_BusinessPartner2.DataController3 as BP2DataController3,
_BusinessPartner2.DataController4 as BP2DataController4,
_BusinessPartner2.DataController5 as BP2DataController5,
_BusinessPartner2.DataController6 as BP2DataController6,
_BusinessPartner2.DataController7 as BP2DataController7,
_BusinessPartner2.DataController8 as BP2DataController8,
_BusinessPartner2.DataController9 as BP2DataController9,
_BusinessPartner2.DataController10 as BP2DataController10,
_BusinessPartner1.BusinessPartnerCategory,
cast( ' ' as bu_group ) as BusinessPartnerGrouping,
cast( 'X' as abap_boolean preserving type ) as MasterDataIsCurrent
// _BusinessPartner2InProcess,
// _BusinessPartner2Active
}
union all
select distinct from I_BPRelationship_2 as BPRelationShip
//association [0..1] to I_BusinessPartnerGov as _BusinessPartner2InProcess on $projection.MDChgProcessStep = _BusinessPartner2InProcess.MDChgProcessStep
// and $projection.MasterDataChangeProcess = _BusinessPartner2InProcess.MasterDataChangeProcess
// and $projection.BusinessPartner2 = _BusinessPartner2InProcess.MDChgProcessSrceObject
//
//
//association [0..1] to I_BusinessPartner as _BusinessPartner2Active on $projection.BusinessPartner2 = _BusinessPartner2Active.BusinessPartner
{
key '000000000000' as MasterDataChangeProcess,
key '0000' as MDChgProcessStep,
key '' as MDChgProcessSrceSystem,
key cast( concat( BusinessPartner1, concat( '$$', concat( BusinessPartner2, concat( '$$', RelationshipCategory ) ) ) ) as mdc_source_id ) as MDChgProcessSrceObject,
key cast( ' ' as boolean ) as BPRelshpCatIsInFwdDirection,
BusinessPartner2 as BusinessPartner1,
BusinessPartner1 as BusinessPartner2,
RelationshipCategory,
_BusinessPartner2.AuthorizationGroup as BP1AuthorizationGroup,
_BusinessPartner1.DataControllerSet as BP1DataControllerSet,
_BusinessPartner1.DataController1 as BP1DataController1,
_BusinessPartner1.DataController2 as BP1DataController2,
_BusinessPartner1.DataController3 as BP1DataController3,
_BusinessPartner1.DataController4 as BP1DataController4,
_BusinessPartner1.DataController5 as BP1DataController5,
_BusinessPartner1.DataController6 as BP1DataController6,
_BusinessPartner1.DataController7 as BP1DataController7,
_BusinessPartner1.DataController8 as BP1DataController8,
_BusinessPartner1.DataController9 as BP1DataController9,
_BusinessPartner1.DataController10 as BP1DataController10,
_BusinessPartner1.AuthorizationGroup as BP2AuthorizationGroup,
_BusinessPartner2.DataControllerSet as BP2DataControllerSet,
_BusinessPartner2.DataController1 as BP2DataController1,
_BusinessPartner2.DataController2 as BP2DataController2,
_BusinessPartner2.DataController3 as BP2DataController3,
_BusinessPartner2.DataController4 as BP2DataController4,
_BusinessPartner2.DataController5 as BP2DataController5,
_BusinessPartner2.DataController6 as BP2DataController6,
_BusinessPartner2.DataController7 as BP2DataController7,
_BusinessPartner2.DataController8 as BP2DataController8,
_BusinessPartner2.DataController9 as BP2DataController9,
_BusinessPartner2.DataController10 as BP2DataController10,
_BusinessPartner2.BusinessPartnerCategory,
cast( ' ' as bu_group ) as BusinessPartnerGrouping,
cast( 'X' as abap_boolean preserving type ) as MasterDataIsCurrent
// _BusinessPartner2InProcess,
// _BusinessPartner2Active
}