I_BusPartRelshpProcessChanges

Q: Which tables does I_BusPartRelshpProcessChanges use?

I_BusPartRelshpProcessChanges reads from 2 data source(s): I_BusPartRelationshipProcess, I_BusPartRelationshipProcess.

Q: How many fields does I_BusPartRelshpProcessChanges have?

I_BusPartRelshpProcessChanges has 91 fields. Key fields: MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, MDChgProcessModelTableName.

DDL: I_BUSPARTRELSHPPROCESSCHANGES SQL: IBPRELPROCCHG Type: view TRANSACTIONAL

Business Partner Process Changes

I_BusPartRelshpProcessChanges is a Transactional CDS View that provides data about "Business Partner Process Changes" in SAP S/4HANA. It reads from 2 data sources (I_BusPartRelationshipProcess, I_BusPartRelationshipProcess) and exposes 91 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, MDChgProcessModelTableName. It has 2 associations to related views.

Data Sources (2)

Source	Alias	Join Type
I_BusPartRelationshipProcess	_Current	from
I_BusPartRelationshipProcess	_Current	union_all

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_BusinessPartnerProcess	_BusinessPartner	`$projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess and $projection.MDChgProcessStep = _BusinessPartner.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem and ( $projection.MDChgProcessSrceBusPart1 = _BusinessPartner.MDChgProcessSrceObject or $projection.MDChgProcessSrceBusPart2 = _BusinessPartner.MDChgProcessSrceObject )`
[0..1]	I_BusPartRelshpCategoryDesc	_RelationshipCategoryText	`$projection.RelationshipCategory = _RelationshipCategoryText.RelationshipCategory and $projection.BPRelshpCatIsInFwdDirection = _RelationshipCategoryText.BPRelshpCatIsInFwdDirection and _RelationshipCategoryText.BusPartRelshpIsRoleDefinition = ' '`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	IBPRELPROCCHG	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Business Partner Process Changes	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.sizeCategory	#XL	view
VDM.viewType	#TRANSACTIONAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (91)

Key	Field	Source Table	Source Field
KEY	MasterDataChangeProcess	I_BusPartRelationshipProcess	MasterDataChangeProcess
KEY	MDChgProcessStep	I_BusPartRelationshipProcess	MDChgProcessStep
KEY	MDChgProcessSrceSystem	I_BusPartRelationshipProcess	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject	I_BusPartRelationshipProcess	MDChgProcessSrceObject
KEY	MDChgProcessModelTableName	_ModelTable	MDChgProcessModelTableName
KEY	MDChangeProcessModelFieldName
KEY	MDChgProcessRecordObjectID
	MDChgProcessSrceBusPart1	I_BusPartRelationshipProcess	MDChgProcessSrceBusPart1
	MDChgProcessSrceBusPart2	I_BusPartRelationshipProcess	MDChgProcessSrceBusPart2
	RelationshipCategory	I_BusPartRelationshipProcess	RelationshipCategory
	BPRelshpCatIsInFwdDirection	I_BusPartRelationshipProcess	BPRelshpCatIsInFwdDirection
	BP1AuthorizationGroup	I_BusPartRelationshipProcess	BP1AuthorizationGroup
	BP2AuthorizationGroup	I_BusPartRelationshipProcess	BP2AuthorizationGroup
	BP1DataControllerSet	I_BusPartRelationshipProcess	BP1DataControllerSet
	BP1DataController1	I_BusPartRelationshipProcess	BP1DataController1
	BP1DataController2	I_BusPartRelationshipProcess	BP1DataController2
	BP1DataController3	I_BusPartRelationshipProcess	BP1DataController3
	BP1DataController4	I_BusPartRelationshipProcess	BP1DataController4
	BP1DataController5	I_BusPartRelationshipProcess	BP1DataController5
	BP1DataController6	I_BusPartRelationshipProcess	BP1DataController6
	BP1DataController7	I_BusPartRelationshipProcess	BP1DataController7
	BP1DataController8	I_BusPartRelationshipProcess	BP1DataController8
	BP1DataController9	I_BusPartRelationshipProcess	BP1DataController9
	BP1DataController10	I_BusPartRelationshipProcess	BP1DataController10
	BP2DataControllerSet	I_BusPartRelationshipProcess	BP2DataControllerSet
	BP2DataController1	I_BusPartRelationshipProcess	BP2DataController1
	BP2DataController2	I_BusPartRelationshipProcess	BP2DataController2
	BP2DataController3	I_BusPartRelationshipProcess	BP2DataController3
	BP2DataController4	I_BusPartRelationshipProcess	BP2DataController4
	BP2DataController5	I_BusPartRelationshipProcess	BP2DataController5
	BP2DataController6	I_BusPartRelationshipProcess	BP2DataController6
	BP2DataController7	I_BusPartRelationshipProcess	BP2DataController7
	BP2DataController8	I_BusPartRelationshipProcess	BP2DataController8
	BP2DataController9	I_BusPartRelationshipProcess	BP2DataController9
	BP2DataController10	I_BusPartRelationshipProcess	BP2DataController10
	MDChangeProcModelTableDesc	_ModelTable	MDChangeProcModelTableDesc
	MDChangeProcessModelFieldDesc
	MDChgProcModelNodeExternalName
	MDChgProcModTableExternalName
	MDChgProcModFieldExternalName
	MDChgProcCurrentAttributeValue
	MDChgProcPrevAttributeValue
	MDChgProcessAttributeIsChanged
	MDChgProcessSourceModified	I_BusPartRelationshipProcess	MDChgProcessSourceModified
	_BusinessPartner		_BusinessPartner
	MasterDataChangeProcess
KEY	MDChgProcessStep	I_BusPartRelationshipProcess	MDChgProcessStep
KEY	MDChgProcessSrceSystem	I_BusPartRelationshipProcess	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject	I_BusPartRelationshipProcess	MDChgProcessSrceObject
KEY	MDChgProcessModelTableName	_ModelField	MDChgProcessModelTableName
KEY	MDChangeProcessModelFieldName	_ModelField	MDChangeProcessModelFieldName
KEY	MDChgProcessRecordObjectID
	MDChgProcessSrceBusPart1	I_BusPartRelationshipProcess	MDChgProcessSrceBusPart1
	MDChgProcessSrceBusPart2	I_BusPartRelationshipProcess	MDChgProcessSrceBusPart2
	RelationshipCategory	I_BusPartRelationshipProcess	RelationshipCategory
	BPRelshpCatIsInFwdDirection	I_BusPartRelationshipProcess	BPRelshpCatIsInFwdDirection
	BP1AuthorizationGroup	I_BusPartRelationshipProcess	BP1AuthorizationGroup
	BP2AuthorizationGroup	I_BusPartRelationshipProcess	BP2AuthorizationGroup
	BP1DataControllerSet	I_BusPartRelationshipProcess	BP1DataControllerSet
	BP1DataController1	I_BusPartRelationshipProcess	BP1DataController1
	BP1DataController2	I_BusPartRelationshipProcess	BP1DataController2
	BP1DataController3	I_BusPartRelationshipProcess	BP1DataController3
	BP1DataController4	I_BusPartRelationshipProcess	BP1DataController4
	BP1DataController5	I_BusPartRelationshipProcess	BP1DataController5
	BP1DataController6	I_BusPartRelationshipProcess	BP1DataController6
	BP1DataController7	I_BusPartRelationshipProcess	BP1DataController7
	BP1DataController8	I_BusPartRelationshipProcess	BP1DataController8
	BP1DataController9	I_BusPartRelationshipProcess	BP1DataController9
	BP1DataController10	I_BusPartRelationshipProcess	BP1DataController10
	BP2DataControllerSet	I_BusPartRelationshipProcess	BP2DataControllerSet
	BP2DataController1	I_BusPartRelationshipProcess	BP2DataController1
	BP2DataController2	I_BusPartRelationshipProcess	BP2DataController2
	BP2DataController3	I_BusPartRelationshipProcess	BP2DataController3
	BP2DataController4	I_BusPartRelationshipProcess	BP2DataController4
	BP2DataController5	I_BusPartRelationshipProcess	BP2DataController5
	BP2DataController6	I_BusPartRelationshipProcess	BP2DataController6
	BP2DataController7	I_BusPartRelationshipProcess	BP2DataController7
	BP2DataController8	I_BusPartRelationshipProcess	BP2DataController8
	BP2DataController9	I_BusPartRelationshipProcess	BP2DataController9
	BP2DataController10	I_BusPartRelationshipProcess	BP2DataController10
	MDChangeProcModelTableDesc	_ModelField	MDChangeProcModelTableDesc
	MDChangeProcessModelFieldDesc	_ModelField	MDChangeProcessModelFieldDesc
	MDChgProcModelNodeExternalName
	MDChgProcModTableExternalName
	MDChgProcModFieldExternalName
	MDChgProcCurrentAttributeValue
	MDChgProcPrevAttributeValue
	MDChgProcessAttributeIsChanged
	MDChgProcessSourceModified	I_BusPartRelationshipProcess	MDChgProcessSourceModified
	_BusinessPartner		_BusinessPartner
	_RelationshipCategoryText		_RelationshipCategoryText

@AbapCatalog.sqlViewName: 'IBPRELPROCCHG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Business Partner Process Changes'
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]
@ClientHandling.algorithm: #SESSION_VARIABLE
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
define view I_BusPartRelshpProcessChanges
  as select from           I_BusPartRelationshipProcess as _Current
    left outer to one join I_MDChangeProcessModelTable  as _ModelTable on  _ModelTable.MDChgProcessModelTableName     = 'BUT050'
                                                                       and _ModelTable.MDChgProcessSrceObjectTypeCode = '1405'
  association [1..1] to I_BusinessPartnerProcess    as _BusinessPartner          on  $projection.MasterDataChangeProcess    = _BusinessPartner.MasterDataChangeProcess
                                                                                 and $projection.MDChgProcessStep           = _BusinessPartner.MDChgProcessStep
                                                                                 and $projection.MDChgProcessSrceSystem     = _BusinessPartner.MDChgProcessSrceSystem
                                                                                 and (
                                                                                    $projection.MDChgProcessSrceBusPart1    = _BusinessPartner.MDChgProcessSrceObject
                                                                                    or $projection.MDChgProcessSrceBusPart2 = _BusinessPartner.MDChgProcessSrceObject
                                                                                  )
  association [0..1] to I_BusPartRelshpCategoryDesc as _RelationshipCategoryText on  $projection.RelationshipCategory                        = _RelationshipCategoryText.RelationshipCategory
                                                                                 and $projection.BPRelshpCatIsInFwdDirection                 = _RelationshipCategoryText.BPRelshpCatIsInFwdDirection
                                                                                 and _RelationshipCategoryText.BusPartRelshpIsRoleDefinition = ' '
{
  key _Current.MasterDataChangeProcess,
  key _Current.MDChgProcessStep,
  key _Current.MDChgProcessSrceSystem,
  key _Current.MDChgProcessSrceObject,
  key _ModelTable.MDChgProcessModelTableName,
  key cast ( '' as fieldname )                                                                                             as MDChangeProcessModelFieldName,
  key cast( concat(_Current.MDChgProcessSrceSystem, concat( '%%', _Current.MDChgProcessSrceObject ) ) as abap.char(1000) ) as MDChgProcessRecordObjectID,
      _Current.MDChgProcessSrceBusPart1,
      _Current.MDChgProcessSrceBusPart2,
      _Current.RelationshipCategory,
      @Semantics.booleanIndicator: true
      _Current.BPRelshpCatIsInFwdDirection,
      _Current.BP1AuthorizationGroup,
      _Current.BP2AuthorizationGroup,
      _Current.BP1DataControllerSet,
      _Current.BP1DataController1,
      _Current.BP1DataController2,
      _Current.BP1DataController3,
      _Current.BP1DataController4,
      _Current.BP1DataController5,
      _Current.BP1DataController6,
      _Current.BP1DataController7,
      _Current.BP1DataController8,
      _Current.BP1DataController9,
      _Current.BP1DataController10,
      _Current.BP2DataControllerSet,
      _Current.BP2DataController1,
      _Current.BP2DataController2,
      _Current.BP2DataController3,
      _Current.BP2DataController4,
      _Current.BP2DataController5,
      _Current.BP2DataController6,
      _Current.BP2DataController7,
      _Current.BP2DataController8,
      _Current.BP2DataController9,
      _Current.BP2DataController10,
      _ModelTable.MDChangeProcModelTableDesc,
      cast ('' as as4text )                                                                                                as MDChangeProcessModelFieldDesc,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'BusinessPartnerRelationship' as fieldname )                                                                   as MDChgProcModelNodeExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'I_BusPartRelationshipProcessTP' as fieldname )                                                                as MDChgProcModTableExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      cast( '' as fieldname )                                                                                              as MDChgProcModFieldExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      cast( '' as abap.char( 260 ) )                                                                                       as MDChgProcCurrentAttributeValue,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      cast( '' as abap.char( 260 ) )                                                                                       as MDChgProcPrevAttributeValue,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      cast( '' as boolean )                                                                                                as MDChgProcessAttributeIsChanged,
      _Current.MDChgProcessSourceModified,

      concat_with_space(
         concat_with_space( _Current.BusinessPartnerName1,_RelationshipCategoryText.BusPartRelshpCatDescription,1)
       , _Current.BusinessPartnerName2,1)                                                                                  as MDChgProcessRecordObjectText,
      _BusinessPartner,
      _RelationshipCategoryText
}
where
     _Current.MDChgProcessSourceModified = 'I'
  or _Current.MDChgProcessSourceModified = 'D'

union all select from     I_BusPartRelationshipProcess as _Current
  left outer to many join I_MDChangeProcessModelField  as _ModelField on  _ModelField.MDChgProcessModelTableName     = 'BUT050'
                                                                      and _ModelField.MDChgProcessSrceObjectTypeCode = '1405'
association [1..1] to I_BusinessPartnerProcess    as _BusinessPartner          on  $projection.MasterDataChangeProcess    = _BusinessPartner.MasterDataChangeProcess
                                                                               and $projection.MDChgProcessStep           = _BusinessPartner.MDChgProcessStep
                                                                               and $projection.MDChgProcessSrceSystem     = _BusinessPartner.MDChgProcessSrceSystem
                                                                               and (
                                                                                  $projection.MDChgProcessSrceBusPart1    = _BusinessPartner.MDChgProcessSrceObject
                                                                                  or $projection.MDChgProcessSrceBusPart2 = _BusinessPartner.MDChgProcessSrceObject
                                                                                )
association [0..1] to I_BusPartRelshpCategoryDesc as _RelationshipCategoryText on  $projection.RelationshipCategory                        = _RelationshipCategoryText.RelationshipCategory
                                                                               and $projection.BPRelshpCatIsInFwdDirection                 = _RelationshipCategoryText.BPRelshpCatIsInFwdDirection
                                                                               and _RelationshipCategoryText.BusPartRelshpIsRoleDefinition = ' '
{
  key _Current.MasterDataChangeProcess,
  key _Current.MDChgProcessStep,
  key _Current.MDChgProcessSrceSystem,
  key _Current.MDChgProcessSrceObject,
  key _ModelField.MDChgProcessModelTableName,
  key _ModelField.MDChangeProcessModelFieldName,
  key cast( concat(_Current.MDChgProcessSrceSystem, concat( '%%', _Current.MDChgProcessSrceObject ) ) as abap.char(1000) ) as MDChgProcessRecordObjectID,
      _Current.MDChgProcessSrceBusPart1,
      _Current.MDChgProcessSrceBusPart2,
      _Current.RelationshipCategory,
      _Current.BPRelshpCatIsInFwdDirection,
      _Current.BP1AuthorizationGroup,
      _Current.BP2AuthorizationGroup,
      _Current.BP1DataControllerSet,
      _Current.BP1DataController1,
      _Current.BP1DataController2,
      _Current.BP1DataController3,
      _Current.BP1DataController4,
      _Current.BP1DataController5,
      _Current.BP1DataController6,
      _Current.BP1DataController7,
      _Current.BP1DataController8,
      _Current.BP1DataController9,
      _Current.BP1DataController10,
      _Current.BP2DataControllerSet,
      _Current.BP2DataController1,
      _Current.BP2DataController2,
      _Current.BP2DataController3,
      _Current.BP2DataController4,
      _Current.BP2DataController5,
      _Current.BP2DataController6,
      _Current.BP2DataController7,
      _Current.BP2DataController8,
      _Current.BP2DataController9,
      _Current.BP2DataController10,
      _ModelField.MDChangeProcModelTableDesc,
      _ModelField.MDChangeProcessModelFieldDesc,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'BusinessPartnerRelationship' as fieldname )                                                                   as MDChgProcModelNodeExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'I_BusPartRelationshipProcessTP' as fieldname )                                                                as MDChgProcModTableExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      cast( '' as fieldname )                                                                                              as MDChgProcModFieldExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      cast( '' as abap.char( 260 ) )                                                                                       as MDChgProcCurrentAttributeValue,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      cast( '' as abap.char( 260 ) )                                                                                       as MDChgProcPrevAttributeValue,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      cast( '' as boolean )                                                                                                as MDChgProcessAttributeIsChanged,
      _Current.MDChgProcessSourceModified,
      concat_with_space(
              concat_with_space( _Current.BusinessPartnerName1,_RelationshipCategoryText.BusPartRelshpCatDescription,1)
            , _Current.BusinessPartnerName2,1)                                                                             as MDChgProcessRecordObjectText,
      _BusinessPartner,
      _RelationshipCategoryText
}
where
  _Current.MDChgProcessSourceModified = 'X'

Depth:

I_BusPartRelshpProcessChanges view

I_BusPartRelationshipProcess view_entity
I_BusPartRelationshipProcess view_entity

I_BPRelshpProcessChangesUnion view