I_BUSPARTRELATIONSHIPPROCESS
Core Business Partner Relationship Proc
I_BUSPARTRELATIONSHIPPROCESS is a CDS View in S/4HANA. Core Business Partner Relationship Proc. It contains 40 fields. 14 CDS views read from this table.
CDS Views using this table (14)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BPCntctPersnEmlAddrProcChgs | view_entity | inner | TRANSACTIONAL | BP Contact Person Workplace Address Email Process Changes |
| I_BPCntctPersnFaxNmbrProcChgs | view_entity | inner | TRANSACTIONAL | CntctPrsn WrkplceAddr FaxNmbr Proc Chngs |
| I_BPCntctPersnMblNmbrProcChgs | view_entity | inner | TRANSACTIONAL | BP Contact Person Workplace Addr Mobile Phone Proc Changes |
| I_BPCntctPersnTelNmbrProcChgs | view_entity | inner | TRANSACTIONAL | BP Contact Person Workplace Addr Telephone Proc Changes |
| I_BPCntctPersnWbsteURLProcChgs | view_entity | inner | TRANSACTIONAL | BP Contact Person Workplace Address Website Process Changes |
| I_BPContactPersonAddrProcChgs | view_entity | inner | TRANSACTIONAL | BP Contact Person WplcAddr Process Chgs |
| I_BPRelshpTmeDpndcyProcChgs | view_entity | inner | TRANSACTIONAL | BP Relationship Time Dependency Process Changes |
| I_BusPartContactPersonProcChgs | view_entity | inner | TRANSACTIONAL | BP Relationship Contact Person Process Changes |
| I_BusPartRelationshipGov | view_entity | from | COMPOSITE | Business Partner Relationship Governance |
| I_BusPartRelationshipGov | view_entity | union_all | COMPOSITE | Business Partner Relationship Governance |
| I_BusPartRelationshipProcessTP | view_entity | from | TRANSACTIONAL | BP Relationship Process Data - TP |
| I_BusPartRelshpProcessChanges | view | from | TRANSACTIONAL | Business Partner Process Changes |
| I_BusPartRelshpProcessChanges | view | union_all | TRANSACTIONAL | Business Partner Process Changes |
| P_BusPartGovRelationshipList | view_entity | from | BASIC | Base list for all Relationships of BP |
Fields (40)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | MasterDataChangeProcess | MasterDataChangeProcess | 4 |
| KEY | MDChgProcessSrceBusPart1 | BusinessPartner1,BusinessPartner2,MDChgProcessSrceBusPart1 | 12 |
| KEY | MDChgProcessSrceBusPart2 | BusinessPartner1,BusinessPartner2,MDChgProcessSrceBusPart2 | 12 |
| KEY | MDChgProcessSrceObject | MDChgProcessSrceObject | 4 |
| KEY | MDChgProcessSrceSystem | MDChgProcessSrceSystem | 4 |
| KEY | MDChgProcessStep | MDChgProcessStep | 4 |
| KEY | RelationshipCategory | RelationshipCategory | 11 |
| _BusinessPartner1 | _BusinessPartner1 | 1 | |
| _BusinessPartner2 | _BusinessPartner2 | 1 | |
| BP1AuthorizationGroup | BP1AuthorizationGroup | 11 | |
| BP1DataController1 | BP1DataController1,BP2DataController1 | 9 | |
| BP1DataController10 | BP1DataController10,BP2DataController10 | 9 | |
| BP1DataController2 | BP1DataController2,BP2DataController2 | 9 | |
| BP1DataController3 | BP1DataController3,BP2DataController3 | 9 | |
| BP1DataController4 | BP1DataController4,BP2DataController4 | 9 | |
| BP1DataController5 | BP1DataController5,BP2DataController5 | 9 | |
| BP1DataController6 | BP1DataController6,BP2DataController6 | 9 | |
| BP1DataController7 | BP1DataController7,BP2DataController7 | 9 | |
| BP1DataController8 | BP1DataController8,BP2DataController8 | 9 | |
| BP1DataController9 | BP1DataController9,BP2DataController9 | 9 | |
| BP1DataControllerSet | BP1DataControllerSet,BP2DataControllerSet | 9 | |
| BP2AuthorizationGroup | BP1AuthorizationGroup,BP2AuthorizationGroup | 10 | |
| BP2DataController1 | BP1DataController1,BP2DataController1 | 9 | |
| BP2DataController10 | BP1DataController10,BP2DataController10 | 9 | |
| BP2DataController2 | BP1DataController2,BP2DataController2 | 9 | |
| BP2DataController3 | BP1DataController3,BP2DataController3 | 9 | |
| BP2DataController4 | BP1DataController4,BP2DataController4 | 9 | |
| BP2DataController5 | BP1DataController5,BP2DataController5 | 9 | |
| BP2DataController6 | BP1DataController6,BP2DataController6 | 9 | |
| BP2DataController7 | BP1DataController7,BP2DataController7 | 9 | |
| BP2DataController8 | BP1DataController8,BP2DataController8 | 9 | |
| BP2DataController9 | BP1DataController9,BP2DataController9 | 9 | |
| BP2DataControllerSet | BP1DataControllerSet,BP2DataControllerSet | 9 | |
| BPRelshpCatIsInFwdDirection | BPRelshpCatIsInFwdDirection | 10 | |
| BusinessPartner1 | BusinessPartner1 | 2 | |
| BusinessPartner2 | BusinessPartner2 | 2 | |
| BusinessPartnerCategory | BusinessPartnerCategory | 1 | |
| MDChgProcessSourceModifBinary | MDChgProcessSourceModifBinary | 1 | |
| MDChgProcessSourceModified | MDChgProcessSourceModified | 2 | |
| MDChgProcessValidationStatus | MDChgProcessValidationStatus | 1 |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Core Business Partner Relationship Proc'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #S,
dataClass: #MIXED
}
define view entity I_BusPartRelationshipProcess
as select from but050_prc as _BPRelProcess
association [0..1] to I_BusinessPartner as _BusinessPartner1active on $projection.BusinessPartner1 = _BusinessPartner1active.BusinessPartner
association [0..1] to I_BusinessPartner as _BusinessPartner2active on $projection.BusinessPartner2 = _BusinessPartner2active.BusinessPartner
association [0..1] to I_BusinessPartnerProcess as _BusinessPartner1 on $projection.MasterDataChangeProcess = _BusinessPartner1.MasterDataChangeProcess
and $projection.MDChgProcessStep = _BusinessPartner1.MDChgProcessStep
and (
$projection.MDChgProcessSrceSystem = _BusinessPartner1.MDChgProcessSrceSystem
or $projection.MDChgProcessSrceSystem = '-/-'
)
and $projection.MDChgProcessSrceBusPart1 = _BusinessPartner1.MDChgProcessSrceObject
association [0..1] to I_BusinessPartnerProcess as _BusinessPartner2 on $projection.MasterDataChangeProcess = _BusinessPartner2.MasterDataChangeProcess
and $projection.MDChgProcessStep = _BusinessPartner2.MDChgProcessStep
and $projection.MDChgProcessSrceBusPart2 = _BusinessPartner2.MDChgProcessSrceObject
{
key _BPRelProcess.process_id as MasterDataChangeProcess,
key _BPRelProcess.process_step_no as MDChgProcessStep,
key _BPRelProcess.source_system as MDChgProcessSrceSystem,
key _BPRelProcess.source_id as MDChgProcessSrceObject,
_BPRelProcess.source_partner1 as MDChgProcessSrceBusPart1,
_BPRelProcess.source_partner2 as MDChgProcessSrceBusPart2,
_BPRelProcess.reltyp as RelationshipCategory,
_BPRelProcess.partner1 as BusinessPartner1,
_BPRelProcess.partner2 as BusinessPartner2,
_BPRelProcess.source_modified as MDChgProcessSourceModified,
_BPRelProcess.source_modification_blip as MDChgProcessSourceModifBinary,
_BPRelProcess.validation_status as MDChgProcessValidationStatus,
@Semantics.booleanIndicator: true
cast( 'X' as abap.char( 1 ) ) as BPRelshpCatIsInFwdDirection,
_BusinessPartner1.BusinessPartnerGrouping as BusinessPartner1Grouping,
_BusinessPartner2.BusinessPartnerGrouping as BusinessPartner2Grouping,
_BusinessPartner1.BusinessPartnerCategory,
_BusinessPartner1active,
_BusinessPartner2active,
_BusinessPartner1,
_BusinessPartner2,
case
when _BusinessPartner1active.AuthorizationGroup is not null
then _BusinessPartner1active.AuthorizationGroup
else _BusinessPartner1.AuthorizationGroup
end as BP1AuthorizationGroup,
case
when _BusinessPartner2active.AuthorizationGroup is not null
then _BusinessPartner2active.AuthorizationGroup
else _BusinessPartner2.AuthorizationGroup
end as BP2AuthorizationGroup,
case
when _BusinessPartner1active.DataControllerSet is not null
then _BusinessPartner1active.DataControllerSet
else _BusinessPartner1.DataControllerSet
end as BP1DataControllerSet,
case
when _BusinessPartner2active.DataControllerSet is not null
then _BusinessPartner2active.DataControllerSet
else _BusinessPartner2.DataControllerSet
end as BP2DataControllerSet,
case
when _BusinessPartner1active.DataController1 is not null
then _BusinessPartner1active.DataController1
else _BusinessPartner1.DataController1
end as BP1DataController1,
case
when _BusinessPartner2active.DataController1 is not null
then _BusinessPartner2active.DataController1
else _BusinessPartner2.DataController1
end as BP2DataController1,
case
when _BusinessPartner1active.DataController2 is not null
then _BusinessPartner1active.DataController2
else _BusinessPartner1.DataController2
end as BP1DataController2,
case
when _BusinessPartner2active.DataController2 is not null
then _BusinessPartner2active.DataController2
else _BusinessPartner2.DataController2
end as BP2DataController2,
case
when _BusinessPartner1active.DataController3 is not null
then _BusinessPartner1active.DataController3
else _BusinessPartner1.DataController3
end as BP1DataController3,
case
when _BusinessPartner2active.DataController3 is not null
then _BusinessPartner2active.DataController3
else _BusinessPartner2.DataController3
end as BP2DataController3,
case
when _BusinessPartner1active.DataController4 is not null
then _BusinessPartner1active.DataController4
else _BusinessPartner1.DataController4
end as BP1DataController4,
case
when _BusinessPartner2active.DataController4 is not null
then _BusinessPartner2active.DataController4
else _BusinessPartner2.DataController4
end as BP2DataController4,
case
when _BusinessPartner1active.DataController5 is not null
then _BusinessPartner1active.DataController5
else _BusinessPartner1.DataController5
end as BP1DataController5,
case
when _BusinessPartner2active.DataController5 is not null
then _BusinessPartner2active.DataController5
else _BusinessPartner2.DataController5
end as BP2DataController5,
case
when _BusinessPartner1active.DataController6 is not null
then _BusinessPartner1active.DataController6
else _BusinessPartner1.DataController6
end as BP1DataController6,
case
when _BusinessPartner2active.DataController6 is not null
then _BusinessPartner2active.DataController6
else _BusinessPartner2.DataController6
end as BP2DataController6,
case
when _BusinessPartner1active.DataController7 is not null
then _BusinessPartner1active.DataController7
else _BusinessPartner1.DataController7
end as BP1DataController7,
case
when _BusinessPartner2active.DataController7 is not null
then _BusinessPartner2active.DataController7
else _BusinessPartner2.DataController7
end as BP2DataController7,
case
when _BusinessPartner1active.DataController8 is not null
then _BusinessPartner1active.DataController8
else _BusinessPartner1.DataController8
end as BP1DataController8,
case
when _BusinessPartner2active.DataController8 is not null
then _BusinessPartner2active.DataController8
else _BusinessPartner2.DataController8
end as BP2DataController8,
case
when _BusinessPartner1active.DataController9 is not null
then _BusinessPartner1active.DataController9
else _BusinessPartner1.DataController9
end as BP1DataController9,
case
when _BusinessPartner2active.DataController9 is not null
then _BusinessPartner2active.DataController9
else _BusinessPartner2.DataController9
end as BP2DataController9,
case
when _BusinessPartner1active.DataController10 is not null
then _BusinessPartner1active.DataController10
else _BusinessPartner1.DataController10
end as BP1DataController10,
case
when _BusinessPartner2active.DataController10 is not null
then _BusinessPartner2active.DataController10
else _BusinessPartner2.DataController10
end as BP2DataController10,
case
when _BusinessPartner1.BusinessPartnerName <> ''
then _BusinessPartner1.BusinessPartnerName
else _BusinessPartner1active.BusinessPartnerName end as BusinessPartnerName1,
case
when _BusinessPartner2.BusinessPartnerName <> ''
then _BusinessPartner2.BusinessPartnerName
else _BusinessPartner2active.BusinessPartnerName end as BusinessPartnerName2
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNERPROCESS",
"BUT050_PRC"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNERPROCESS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/