What is C_BPProcessChangesUnion in SAP S/4HANA?

C_BPProcessChangesUnion is a consumption CDS view in SAP S/4HANA. Consumtion view of all changes It contains 73 fields.

What VDM layer is C_BPProcessChangesUnion?

C_BPProcessChangesUnion is classified as a Consumption view optimized for specific business scenarios and reporting.

C_BPProcessChangesUnion

Q: Which tables does C_BPProcessChangesUnion read from?

C_BPProcessChangesUnion reads data from: I_BusinessPartnerProcessTP, I_BusinessPartnerProcessTP, I_BPRelshpProcessChangesUnion, I_BPRelshpProcessChangesUnion, I_BPProcessChangesUnion.

DDL: C_BPPROCESSCHANGESUNION SQL: CBPPROCCHGUNION Type: view CONSUMPTION

73 Fields 5 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

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. It is exposed through 1 OData service (C_BUSINESSPARTNERGOVTP_SRV). It is used in 1 Fiori application: Manage Business Partners Central Governance.

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

OData Services (1)

Service	Binding	Version	Contract	Release
C_BUSINESSPARTNERGOVTP_SRV	C_BUSINESSPARTNERGOVTP_SRV	V2	C1	NOT_RELEASED

Fiori Apps (1)

App ID	App Name	Type	Description
F6555	Manage Business Partners Central Governance	Transactional

Manage Business Partners Central Governance

Business Role: Master Data Specialist - Business Partner Data

This app is used in SAP Master Data Governance in cloud-ready mode.With the "Manage Business Partners" app, you can display, create, and change business partners. You can use Manage Business Partners as a single point of entry to create, display, and edit your master data.Features: Create business partner Search for existing business partners Display and edit business partner Look up reference data for business partners and use external data sources to create and enrich business partners Check and improve data quality using freely defined validation rules Change multiple business partners in mass request Address validation Add attachments Display replication status Replicate active business partners to other systems

Fields (73)

Key	Field	Source Table	Source Field	Description
KEY	MasterDataChangeProcess		MasterDataChangeProcess	Process ID
KEY	MDChgProcessStep		MDChgProcessStep	Step Number
KEY	MDChgProcessSrceSystem		MDChgProcessSrceSystem	Source System
KEY	MDChgProcessSrceObject		MDChgProcessSrceObject	Source ID
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	Purpose Completed
	AuthorizationGroup	_BusinessPartner	AuthorizationGroup	AuthorizGroup
	MDChgProcessSrceBusPart1
	MDChgProcessSrceBusPart2
	BP1AuthorizationGroup	_BusinessPartner	AuthorizationGroup	Authorization Group
	BP2AuthorizationGroup	_BusinessPartner	AuthorizationGroup	Authorization Group
	MasterDataChangeProcess			Process ID
KEY	MDChgProcessStep	I_BPRelshpProcessChangesUnion	MDChgProcessStep	Step Number
KEY	MDChgProcessSrceSystem	I_BPRelshpProcessChangesUnion	MDChgProcessSrceSystem	Source System
KEY	MDChgProcessSrceObject	I_BusinessPartnerProcessTP	MDChgProcessSrceObject	Source ID
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	Purpose Completed
	AuthorizationGroup	I_BusinessPartnerProcessTP	AuthorizationGroup	AuthorizGroup
	MDChgProcessSrceBusPart1	I_BPRelshpProcessChangesUnion	MDChgProcessSrceBusPart1
	MDChgProcessSrceBusPart2	I_BPRelshpProcessChangesUnion	MDChgProcessSrceBusPart2
	BP1AuthorizationGroup	I_BPRelshpProcessChangesUnion	BP1AuthorizationGroup	Authorization Group
	BP2AuthorizationGroup	I_BPRelshpProcessChangesUnion	BP2AuthorizationGroup	Authorization Group
	MasterDataChangeProcess			Process ID
KEY	MDChgProcessStep	I_BPRelshpProcessChangesUnion	MDChgProcessStep	Step Number
KEY	MDChgProcessSrceSystem	I_BusinessPartnerProcessTP	MDChgProcessSrceSystem	Source System
KEY	MDChgProcessSrceObject	I_BusinessPartnerProcessTP	MDChgProcessSrceObject	Source ID
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	Purpose Completed
	AuthorizationGroup	I_BusinessPartnerProcessTP	AuthorizationGroup	AuthorizGroup
	MDChgProcessSrceBusPart1	I_BPRelshpProcessChangesUnion	MDChgProcessSrceBusPart1
	MDChgProcessSrceBusPart2	I_BPRelshpProcessChangesUnion	MDChgProcessSrceBusPart2
	BP1AuthorizationGroup	I_BPRelshpProcessChangesUnion	BP1AuthorizationGroup	Authorization Group
	BP2AuthorizationGroup	I_BPRelshpProcessChangesUnion	BP2AuthorizationGroup	Authorization Group
	RelationshipCategory	I_BPRelshpProcessChangesUnion	RelationshipCategory	Relationsh.Cat.

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_BPProcessChangesUnion.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CBPPROCCHGUNION

CREATE VIEW C_BPProcessChangesUnion AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  MDChgProcessModelTableName,
  MDChangeProcessModelFieldName,
  MDChgProcessRecordObjectID,
  cast( '147' as mdc_source_otc ) AS MDChgProcessSrceObjectTypeCode,
  MDChangeProcModelTableDesc,
  MDChangeProcessModelFieldDesc,
  MDChgProcModelNodeExternalName,
  MDChgProcModTableExternalName,
  MDChgProcModFieldExternalName,
  MDChgProcCurrentAttributeValue,
  MDChgProcPrevAttributeValue,
  MDChgProcessAttributeIsChanged,
  MDChgProcessSourceModified,
  MDChgProcessRecordObjectText,
  _BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  cast ( '' as mdc_bprel_source_partner ) AS MDChgProcessSrceBusPart1,
  cast ( '' as mdc_bprel_source_partner ) AS MDChgProcessSrceBusPart2,
  _BusinessPartner.AuthorizationGroup AS BP1AuthorizationGroup,
  _BusinessPartner.AuthorizationGroup AS BP2AuthorizationGroup,
  Changes.RelationshipCategory AS RelationshipCategory
FROM I_BPProcessChangesUnion
INNER JOIN I_BusinessPartnerProcessTP AS BusinessPartner ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartnerProcessTP AS _BusinessPartner ON MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess AND MDChgProcessStep = _BusinessPartner.MDChgProcessStep AND MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BusinessPartner.MDChgProcessSrceObject  -- association [1..1]
-- UNION ALL with additional select branch(es): I_BPRelshpProcessChangesUnion
;

Depth:

C_BPProcessChangesUnion view