I_BPProcessChanges

DDL: I_BPPROCESSCHANGES SQL: IBPPROCCHG Type: view TRANSACTIONAL

Business Partner Process Changes

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

2 data source(s) 61 fields

Data Sources (2)

SourceAliasJoin Type
I_BusinessPartnerProcess _Current from
I_BusinessPartnerProcess _Current union_all

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerProcess _BusinessPartner $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess and $projection.MDChgProcessStep = _BusinessPartner.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BusinessPartner.MDChgProcessSrceObject

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBPPROCCHG 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.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess I_BusinessPartnerProcess MasterDataChangeProcess
KEY MDChgProcessStep I_BusinessPartnerProcess MDChgProcessStep
KEY MDChgProcessSrceSystem I_BusinessPartnerProcess MDChgProcessSrceSystem
KEY MDChgProcessSrceObject I_BusinessPartnerProcess MDChgProcessSrceObject
KEY MDChgProcessModelTableName _ModelTable MDChgProcessModelTableName
KEY MDChangeProcessModelFieldName
KEY MDChgProcessRecordObjectID
MDChangeProcModelTableDesc _ModelTable MDChangeProcModelTableDesc
MDChangeProcessModelFieldDesc
MDChgProcModelNodeExternalName
MDChgProcModTableExternalName
MDChgProcModFieldExternalName
MDChgProcCurrentAttributeValue
MDChgProcPrevAttributeValue
MDChgProcessAttributeIsChanged
MDChgProcessSourceModified I_BusinessPartnerProcess MDChgProcessSourceModified
MDChgProcessRecordObjectText
IsBusinessPurposeCompleted _BusinessPartner IsBusinessPurposeCompleted
AuthorizationGroup _BusinessPartner AuthorizationGroup
DataControllerSet _BusinessPartner DataControllerSet
DataController1 _BusinessPartner DataController1
DataController2 _BusinessPartner DataController2
DataController3 _BusinessPartner DataController3
DataController4 _BusinessPartner DataController4
DataController5 _BusinessPartner DataController5
DataController6 _BusinessPartner DataController6
DataController7 _BusinessPartner DataController7
DataController8 _BusinessPartner DataController8
DataController9 _BusinessPartner DataController9
DataController10 _BusinessPartner DataController10
MasterDataChangeProcess
KEY MDChgProcessStep I_BusinessPartnerProcess MDChgProcessStep
KEY MDChgProcessSrceSystem I_BusinessPartnerProcess MDChgProcessSrceSystem
KEY MDChgProcessSrceObject I_BusinessPartnerProcess MDChgProcessSrceObject
KEY MDChgProcessModelTableName _ModelField MDChgProcessModelTableName
KEY MDChangeProcessModelFieldName _ModelField MDChangeProcessModelFieldName
KEY MDChgProcessRecordObjectID
MDChangeProcModelTableDesc _ModelField MDChangeProcModelTableDesc
MDChangeProcessModelFieldDesc _ModelField MDChangeProcessModelFieldDesc
MDChgProcModelNodeExternalName
MDChgProcModTableExternalName
MDChgProcModFieldExternalName
MDChgProcCurrentAttributeValue
MDChgProcPrevAttributeValue
MDChgProcessAttributeIsChanged
MDChgProcessSourceModified I_BusinessPartnerProcess MDChgProcessSourceModified
MDChgProcessRecordObjectText
IsBusinessPurposeCompleted _BusinessPartner IsBusinessPurposeCompleted
AuthorizationGroup _BusinessPartner AuthorizationGroup
DataControllerSet _BusinessPartner DataControllerSet
DataController1 _BusinessPartner DataController1
DataController2 _BusinessPartner DataController2
DataController3 _BusinessPartner DataController3
DataController4 _BusinessPartner DataController4
DataController5 _BusinessPartner DataController5
DataController6 _BusinessPartner DataController6
DataController7 _BusinessPartner DataController7
DataController8 _BusinessPartner DataController8
DataController9 _BusinessPartner DataController9
DataController10 _BusinessPartner DataController10
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'IBPPROCCHG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Business Partner Process Changes'
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType:#TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_BPProcessChanges
  as select from           I_BusinessPartnerProcess    as _Current
    left outer to one join I_MDChangeProcessModelTable as _ModelTable on  _ModelTable.MDChgProcessModelTableName     = 'BUT000'
                                                                      and _ModelTable.MDChgProcessSrceObjectTypeCode = '147'
  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.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject

{
      //I_BusinessPartnerProcess

  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,
      _ModelTable.MDChangeProcModelTableDesc,
      cast ('' as as4text  )                                                                                              as MDChangeProcessModelFieldDesc,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'BusinessPartner' as fieldname )                                                                              as MDChgProcModelNodeExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'I_BusinessPartnerProcessTP' as fieldname )                                                                   as MDChgProcModTableExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_BUPAPROCTP2_CALC_EXIT'
      cast( '' as fieldname )                                                                                             as MDChgProcModFieldExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_BUPAPROCTP2_CALC_EXIT'
      cast( '' as abap.char( 260 ) )                                                                                      as MDChgProcCurrentAttributeValue,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_BUPAPROCTP2_CALC_EXIT'
      cast( '' as abap.char( 260 ) )                                                                                      as MDChgProcPrevAttributeValue,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_BUPAPROCTP2_CALC_EXIT'
      cast( '' as boolean )                                                                                               as MDChgProcessAttributeIsChanged,
      _Current.MDChgProcessSourceModified,
      cast( '' as abap.char( 260 ) )                                                                                      as MDChgProcessRecordObjectText,

      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.IsBusinessPurposeCompleted,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.AuthorizationGroup,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController1,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController2,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController3,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController4,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController6,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController7,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController8,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController9,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController10,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner

}
where
     _Current.MDChgProcessSourceModified = 'I'
  or _Current.MDChgProcessSourceModified = 'D'

union all select from     I_BusinessPartnerProcess    as _Current
  left outer to many join I_MDChangeProcessModelField as _ModelField on  _ModelField.MDChgProcessModelTableName     = 'BUT000'
                                                                     and _ModelField.MDChgProcessSrceObjectTypeCode = '147'
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.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject

{
      //I_BusinessPartnerProcess

  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,
      _ModelField.MDChangeProcModelTableDesc,
      _ModelField.MDChangeProcessModelFieldDesc,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'BusinessPartner' as fieldname )                                                                              as MDChgProcModelNodeExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'I_BusinessPartnerProcessTP' as fieldname )                                                                   as MDChgProcModTableExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_BUPAPROCTP2_CALC_EXIT'
      cast( '' as fieldname )                                                                                             as MDChgProcModFieldExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_BUPAPROCTP2_CALC_EXIT'
      cast( '' as abap.char( 260 ) )                                                                                      as MDChgProcCurrentAttributeValue,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_BUPAPROCTP2_CALC_EXIT'
      cast( '' as abap.char( 260 ) )                                                                                      as MDChgProcPrevAttributeValue,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_BUPAPROCTP2_CALC_EXIT'
      cast( '' as boolean )                                                                                               as MDChgProcessAttributeIsChanged,
      _Current.MDChgProcessSourceModified,
      cast ( '' as abap.char(260) )                                                                                       as MDChgProcessRecordObjectText,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.IsBusinessPurposeCompleted,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.AuthorizationGroup,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController1,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController2,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController3,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController4,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController6,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController7,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController8,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController9,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController10,
      _BusinessPartner
}
where
  _Current.MDChgProcessSourceModified = 'X'

Learn More