C_BPProcessChangesUnion

Q: Which tables does C_BPProcessChangesUnion use?

C_BPProcessChangesUnion reads from 5 data source(s): I_BusinessPartnerProcessTP, I_BusinessPartnerProcessTP, I_BPRelshpProcessChangesUnion, I_BPRelshpProcessChangesUnion, I_BPProcessChangesUnion.

Q: How many fields does C_BPProcessChangesUnion have?

C_BPProcessChangesUnion has 73 fields. Key fields: MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, MDChgProcessModelTableName.

DDL: C_BPPROCESSCHANGESUNION SQL: CBPPROCCHGUNION Type: view CONSUMPTION

Consumtion view of all changes

C_BPProcessChangesUnion is a Consumption CDS View that provides data about "Consumtion view of all changes" in SAP S/4HANA. It reads from 5 data sources (I_BusinessPartnerProcessTP, I_BusinessPartnerProcessTP, I_BPRelshpProcessChangesUnion, I_BPRelshpProcessChangesUnion, I_BPProcessChangesUnion) and exposes 73 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, MDChgProcessModelTableName. It has 1 association to related views.

Data Sources (5)

Source	Alias	Join Type
I_BusinessPartnerProcessTP	BusinessPartner	inner
I_BusinessPartnerProcessTP	BusinessPartner	inner
I_BPRelshpProcessChangesUnion	Changes	union_all
I_BPRelshpProcessChangesUnion	Changes	union_all
I_BPProcessChangesUnion	I_BPProcessChangesUnion	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_BusinessPartnerProcessTP	_BusinessPartner	`$projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess and $projection.MDChgProcessStep = _BusinessPartner.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BusinessPartner.MDChgProcessSrceObject`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	CBPPROCCHGUNION	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Consumtion view of all changes	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (73)

Key	Field	Source Table	Source Field	Description
KEY	MasterDataChangeProcess		MasterDataChangeProcess
KEY	MDChgProcessStep		MDChgProcessStep
KEY	MDChgProcessSrceSystem		MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject		MDChgProcessSrceObject
KEY	MDChgProcessModelTableName		MDChgProcessModelTableName	Table Name
KEY	MDChangeProcessModelFieldName		MDChangeProcessModelFieldName	Field Name
KEY	MDChgProcessRecordObjectID		MDChgProcessRecordObjectID	Object Identifier
KEY	MDChgProcessSrceObjectTypeCode
	MDChangeProcModelTableDesc		MDChangeProcModelTableDesc	Table
	MDChangeProcessModelFieldDesc		MDChangeProcessModelFieldDesc	Field
	MDChgProcModelNodeExternalName		MDChgProcModelNodeExternalName	Entity
	MDChgProcModTableExternalName		MDChgProcModTableExternalName	Node
	MDChgProcModFieldExternalName		MDChgProcModFieldExternalName	Field Name
	MDChgProcCurrentAttributeValue		MDChgProcCurrentAttributeValue	New Value
	MDChgProcPrevAttributeValue		MDChgProcPrevAttributeValue	Old Value
	MDChgProcessAttributeIsChanged		MDChgProcessAttributeIsChanged	Is Changed
	MDChgProcessSourceModified		MDChgProcessSourceModified	Change Type
	MDChgProcessRecordObjectText		MDChgProcessRecordObjectText	Change Context
	IsBusinessPurposeCompleted	_BusinessPartner	IsBusinessPurposeCompleted
	AuthorizationGroup	_BusinessPartner	AuthorizationGroup
	MDChgProcessSrceBusPart1
	MDChgProcessSrceBusPart2
	BP1AuthorizationGroup	_BusinessPartner	AuthorizationGroup
	BP2AuthorizationGroup	_BusinessPartner	AuthorizationGroup
	MasterDataChangeProcess
KEY	MDChgProcessStep	I_BPRelshpProcessChangesUnion	MDChgProcessStep
KEY	MDChgProcessSrceSystem	I_BPRelshpProcessChangesUnion	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject	I_BusinessPartnerProcessTP	MDChgProcessSrceObject
KEY	MDChgProcessModelTableName	I_BPRelshpProcessChangesUnion	MDChgProcessModelTableName	Table Name
KEY	MDChangeProcessModelFieldName	I_BPRelshpProcessChangesUnion	MDChangeProcessModelFieldName	Field Name
KEY	MDChgProcessRecordObjectID	I_BPRelshpProcessChangesUnion	MDChgProcessRecordObjectID	Object Identifier
KEY	MDChgProcessSrceObjectTypeCode
	MDChangeProcModelTableDesc	I_BPRelshpProcessChangesUnion	MDChangeProcModelTableDesc	Table
	MDChangeProcessModelFieldDesc	I_BPRelshpProcessChangesUnion	MDChangeProcessModelFieldDesc	Field
	MDChgProcModelNodeExternalName	I_BPRelshpProcessChangesUnion	MDChgProcModelNodeExternalName	Entity
	MDChgProcModTableExternalName	I_BPRelshpProcessChangesUnion	MDChgProcModTableExternalName	Node
	MDChgProcModFieldExternalName	I_BPRelshpProcessChangesUnion	MDChgProcModFieldExternalName	Field Name
	MDChgProcCurrentAttributeValue	I_BPRelshpProcessChangesUnion	MDChgProcCurrentAttributeValue	New Value
	MDChgProcPrevAttributeValue	I_BPRelshpProcessChangesUnion	MDChgProcPrevAttributeValue	Old Value
	MDChgProcessAttributeIsChanged	I_BPRelshpProcessChangesUnion	MDChgProcessAttributeIsChanged	Is Changed
	MDChgProcessSourceModified	I_BPRelshpProcessChangesUnion	MDChgProcessSourceModified	Change Type
	MDChgProcessRecordObjectText	I_BPRelshpProcessChangesUnion	MDChgProcessRecordObjectText	Change Context
	IsBusinessPurposeCompleted	I_BusinessPartnerProcessTP	IsBusinessPurposeCompleted
	AuthorizationGroup	I_BusinessPartnerProcessTP	AuthorizationGroup
	MDChgProcessSrceBusPart1	I_BPRelshpProcessChangesUnion	MDChgProcessSrceBusPart1
	MDChgProcessSrceBusPart2	I_BPRelshpProcessChangesUnion	MDChgProcessSrceBusPart2
	BP1AuthorizationGroup	I_BPRelshpProcessChangesUnion	BP1AuthorizationGroup
	BP2AuthorizationGroup	I_BPRelshpProcessChangesUnion	BP2AuthorizationGroup
	MasterDataChangeProcess
KEY	MDChgProcessStep	I_BPRelshpProcessChangesUnion	MDChgProcessStep
KEY	MDChgProcessSrceSystem	I_BusinessPartnerProcessTP	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject	I_BusinessPartnerProcessTP	MDChgProcessSrceObject
KEY	MDChgProcessModelTableName	I_BPRelshpProcessChangesUnion	MDChgProcessModelTableName	Table Name
KEY	MDChangeProcessModelFieldName	I_BPRelshpProcessChangesUnion	MDChangeProcessModelFieldName	Field Name
KEY	MDChgProcessRecordObjectID	I_BPRelshpProcessChangesUnion	MDChgProcessRecordObjectID	Object Identifier
KEY	MDChgProcessSrceObjectTypeCode
	MDChangeProcModelTableDesc	I_BPRelshpProcessChangesUnion	MDChangeProcModelTableDesc	Table
	MDChangeProcessModelFieldDesc	I_BPRelshpProcessChangesUnion	MDChangeProcessModelFieldDesc	Field
	MDChgProcModelNodeExternalName	I_BPRelshpProcessChangesUnion	MDChgProcModelNodeExternalName	Entity
	MDChgProcModTableExternalName	I_BPRelshpProcessChangesUnion	MDChgProcModTableExternalName	Node
	MDChgProcModFieldExternalName	I_BPRelshpProcessChangesUnion	MDChgProcModFieldExternalName	Field Name
	MDChgProcCurrentAttributeValue	I_BPRelshpProcessChangesUnion	MDChgProcCurrentAttributeValue	New Value
	MDChgProcPrevAttributeValue	I_BPRelshpProcessChangesUnion	MDChgProcPrevAttributeValue	Old Value
	MDChgProcessAttributeIsChanged	I_BPRelshpProcessChangesUnion	MDChgProcessAttributeIsChanged	Is Changed
	MDChgProcessSourceModified	I_BPRelshpProcessChangesUnion	MDChgProcessSourceModified	Change Type
	MDChgProcessRecordObjectText	I_BPRelshpProcessChangesUnion	MDChgProcessRecordObjectText	Change Context
	IsBusinessPurposeCompleted	I_BusinessPartnerProcessTP	IsBusinessPurposeCompleted
	AuthorizationGroup	I_BusinessPartnerProcessTP	AuthorizationGroup
	MDChgProcessSrceBusPart1	I_BPRelshpProcessChangesUnion	MDChgProcessSrceBusPart1
	MDChgProcessSrceBusPart2	I_BPRelshpProcessChangesUnion	MDChgProcessSrceBusPart2
	BP1AuthorizationGroup	I_BPRelshpProcessChangesUnion	BP1AuthorizationGroup
	BP2AuthorizationGroup	I_BPRelshpProcessChangesUnion	BP2AuthorizationGroup
	RelationshipCategory	I_BPRelshpProcessChangesUnion	RelationshipCategory

@AbapCatalog.sqlViewName: 'CBPPROCCHGUNION'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Consumtion view of all changes'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@UI.presentationVariant: [{
  sortOrder: [{ by: 'MDChgProcessSrceObjectTypeCode', direction: #DESC }, 
              { by: 'MDChgProcessRecordObjectID', direction: #ASC }] 
}]

define view C_BPProcessChangesUnion
  as select from I_BPProcessChangesUnion
  association [1..1] to I_BusinessPartnerProcessTP as _BusinessPartner on  $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess
                                                                       and $projection.MDChgProcessStep        = _BusinessPartner.MDChgProcessStep
                                                                       and $projection.MDChgProcessSrceSystem  = _BusinessPartner.MDChgProcessSrceSystem
                                                                       and $projection.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject
{
      //I_BPProcessChangesUnion

      @UI.hidden:true
  key MasterDataChangeProcess,
      @UI.hidden:true
  key MDChgProcessStep,
      @UI.hidden:true
  key MDChgProcessSrceSystem,
      @UI.hidden:true
  key MDChgProcessSrceObject,
      @EndUserText.label: 'Table Name'
  key MDChgProcessModelTableName,
      @EndUserText.label: 'Field Name'
  key MDChangeProcessModelFieldName,
      @UI.hidden:true
      @EndUserText.label: 'Object Identifier'
  key MDChgProcessRecordObjectID,
      @UI.hidden:true
  key cast( '147' as mdc_source_otc )          as MDChgProcessSrceObjectTypeCode,
      @EndUserText.label: 'Table'
      MDChangeProcModelTableDesc,
      @EndUserText.label: 'Field'
      MDChangeProcessModelFieldDesc,
      @EndUserText.label: 'Entity'
      @UI.hidden:true
      MDChgProcModelNodeExternalName,
      @EndUserText.label: 'Node'
      @UI.hidden: true
      MDChgProcModTableExternalName,
      @EndUserText.label: 'Field Name'
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_BUPAPROCTP2_CALC_EXIT'
      @UI.hidden: true
      MDChgProcModFieldExternalName,
      @EndUserText.label: 'New Value'
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_BUPAPROCTP2_CALC_EXIT'
      MDChgProcCurrentAttributeValue,
      @EndUserText.label: 'Old Value'
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_BUPAPROCTP2_CALC_EXIT'
      MDChgProcPrevAttributeValue,
      @EndUserText.label: 'Is Changed'
      @UI.hidden:true
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_BUPAPROCTP2_CALC_EXIT'
      MDChgProcessAttributeIsChanged,
      @UI.hidden:true
      @EndUserText.label: 'Change Type'
      MDChgProcessSourceModified,
      @EndUserText.label: 'Change Context'
      MDChgProcessRecordObjectText,

      //needed for DCL

      @UI.hidden:true
      _BusinessPartner.IsBusinessPurposeCompleted,
      @UI.hidden:true
      _BusinessPartner.AuthorizationGroup,
      //needed for relationship changes

      @UI.hidden:true
      cast ( '' as mdc_bprel_source_partner  ) as MDChgProcessSrceBusPart1,
      @UI.hidden:true
      cast ( '' as mdc_bprel_source_partner  ) as MDChgProcessSrceBusPart2,
      @UI.hidden:true
      _BusinessPartner.AuthorizationGroup      as BP1AuthorizationGroup,
      @UI.hidden:true
      _BusinessPartner.AuthorizationGroup      as BP2AuthorizationGroup,
      @UI.hidden:true
      cast ('' as bu_reltyp )                  as RelationshipCategory

      //      cast ( '' as bu_reltyp ) as RelationshipCategory

}

// Business Partner in Relationship

union all select from I_BPRelshpProcessChangesUnion as Changes
  inner join          I_BusinessPartnerProcessTP    as BusinessPartner on  Changes.MasterDataChangeProcess = BusinessPartner.MasterDataChangeProcess
                                                                       and Changes.MDChgProcessStep        = BusinessPartner.MDChgProcessStep
                                                                       and Changes.MDChgProcessSrceSystem  = BusinessPartner.MDChgProcessSrceSystem
{
      //I_BPProcessChangesUnion

      @UI.hidden:true
  key Changes.MasterDataChangeProcess,
      @UI.hidden:true
  key Changes.MDChgProcessStep,
      @UI.hidden:true
  key Changes.MDChgProcessSrceSystem,
      @UI.hidden:true
  key BusinessPartner.MDChgProcessSrceObject,
      @EndUserText.label: 'Table Name'
  key Changes.MDChgProcessModelTableName,
      @EndUserText.label: 'Field Name'
  key Changes.MDChangeProcessModelFieldName,
      @UI.hidden:true
      @EndUserText.label: 'Object Identifier'
  key Changes.MDChgProcessRecordObjectID,
      @UI.hidden:true
  key cast( '1405' as mdc_source_otc ) as MDChgProcessSrceObjectTypeCode,
      @EndUserText.label: 'Table'
      Changes.MDChangeProcModelTableDesc,
      @EndUserText.label: 'Field'
      Changes.MDChangeProcessModelFieldDesc,
      @EndUserText.label: 'Entity'
      @UI.hidden:true
      Changes.MDChgProcModelNodeExternalName,
      @EndUserText.label: 'Node'
      @UI.hidden: true
      Changes.MDChgProcModTableExternalName,
      @EndUserText.label: 'Field Name'
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      @UI.hidden: true
      Changes.MDChgProcModFieldExternalName,
      @EndUserText.label: 'New Value'
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      Changes.MDChgProcCurrentAttributeValue,
      @EndUserText.label: 'Old Value'
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      Changes.MDChgProcPrevAttributeValue,
      @EndUserText.label: 'Is Changed'
      @UI.hidden:true
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      Changes.MDChgProcessAttributeIsChanged,
      @UI.hidden:true
      @EndUserText.label: 'Change Type'
      Changes.MDChgProcessSourceModified,
      @EndUserText.label: 'Change Context'
      Changes.MDChgProcessRecordObjectText,

      //needed for DCL

      @UI.hidden:true
      BusinessPartner.IsBusinessPurposeCompleted,
      @UI.hidden:true
      BusinessPartner.AuthorizationGroup,
      //needed for relationship changes

      @UI.hidden:true
      Changes.MDChgProcessSrceBusPart1,
      @UI.hidden:true
      Changes.MDChgProcessSrceBusPart2,
      @UI.hidden:true
      Changes.BP1AuthorizationGroup,
      @UI.hidden:true
      Changes.BP2AuthorizationGroup,
      @UI.hidden:true
      Changes.RelationshipCategory
}
where
     Changes.MDChgProcessSrceBusPart1 = BusinessPartner.MDChgProcessSrceObject
  or Changes.MDChgProcessSrceBusPart2 = BusinessPartner.MDChgProcessSrceObject

//Active Business Partner in newly created Relationship

union all select from I_BPRelshpProcessChangesUnion as Changes
  inner join          I_BusinessPartnerProcessTP    as BusinessPartner on  Changes.MasterDataChangeProcess = BusinessPartner.MasterDataChangeProcess
                                                                       and Changes.MDChgProcessStep        = BusinessPartner.MDChgProcessStep

{
      //I_BPProcessChangesUnion

      @UI.hidden:true
  key Changes.MasterDataChangeProcess,
      @UI.hidden:true
  key Changes.MDChgProcessStep,
      @UI.hidden:true
  key BusinessPartner.MDChgProcessSrceSystem,
      @UI.hidden:true
  key BusinessPartner.MDChgProcessSrceObject,
      @EndUserText.label: 'Table Name'
  key Changes.MDChgProcessModelTableName,
      @EndUserText.label: 'Field Name'
  key Changes.MDChangeProcessModelFieldName,
      @UI.hidden:true
      @EndUserText.label: 'Object Identifier'
  key Changes.MDChgProcessRecordObjectID,
      @UI.hidden:true
  key cast( '1405' as mdc_source_otc ) as MDChgProcessSrceObjectTypeCode,
      @EndUserText.label: 'Table'
      Changes.MDChangeProcModelTableDesc,
      @EndUserText.label: 'Field'
      Changes.MDChangeProcessModelFieldDesc,
      @EndUserText.label: 'Entity'
      @UI.hidden:true
      Changes.MDChgProcModelNodeExternalName,
      @EndUserText.label: 'Node'
      @UI.hidden: true
      Changes.MDChgProcModTableExternalName,
      @EndUserText.label: 'Field Name'
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      @UI.hidden: true
      Changes.MDChgProcModFieldExternalName,
      @EndUserText.label: 'New Value'
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      Changes.MDChgProcCurrentAttributeValue,
      @EndUserText.label: 'Old Value'
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      Changes.MDChgProcPrevAttributeValue,
      @EndUserText.label: 'Is Changed'
      @UI.hidden:true
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      Changes.MDChgProcessAttributeIsChanged,
      @UI.hidden:true
      @EndUserText.label: 'Change Type'
      Changes.MDChgProcessSourceModified,
      @EndUserText.label: 'Change Context'
      Changes.MDChgProcessRecordObjectText,

      //needed for DCL

      @UI.hidden:true
      BusinessPartner.IsBusinessPurposeCompleted,
      @UI.hidden:true
      BusinessPartner.AuthorizationGroup,
      //needed for relationship changes

      @UI.hidden:true
      Changes.MDChgProcessSrceBusPart1,
      @UI.hidden:true
      Changes.MDChgProcessSrceBusPart2,
      @UI.hidden:true
      Changes.BP1AuthorizationGroup,
      @UI.hidden:true
      Changes.BP2AuthorizationGroup,
      @UI.hidden:true
      Changes.RelationshipCategory
}
where
  (
       Changes.MDChgProcessSrceBusPart1       =  BusinessPartner.MDChgProcessSrceObject
    or Changes.MDChgProcessSrceBusPart2       =  BusinessPartner.MDChgProcessSrceObject
  )
  and  Changes.MDChgProcessSrceSystem         =  '-/-'
  and  BusinessPartner.MDChgProcessSrceSystem <> '-/-'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPPROCESSCHANGESUNION",
"I_BPRELSHPPROCESSCHANGESUNION",
"I_BUSINESSPARTNERPROCESSTP"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERPROCESSTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

C_BPProcessChangesUnion view