C_BPProcessChangesUnion
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 9 data sources and exposes 131 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, MDChgProcessModelTableName.
Data Sources (9)
| Source | Alias | Join Type |
|---|---|---|
| I_BusinessPartnerProcessTP | BusinessPartner | inner |
| I_BusinessPartnerProcessTP | BusinessPartner | inner |
| I_BusinessPartnerProcessTP | BusinessPartner | inner |
| I_BusinessPartnerProcessTP | BusinessPartner | inner |
| I_BPRelshpProcessChangesUnion | Changes | union_all |
| I_BPRelshpProcessChangesUnion | Changes | union_all |
| I_BPRelshpProcessChangesUnion | Changes | union_all |
| I_BPRelshpProcessChangesUnion | Changes | union_all |
| I_BPProcessChangesUnion | I_BPProcessChangesUnion | from |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| 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 | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (131)
| 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 | IsBusinessPurposeCompleted | Purpose Completed | ||
| AuthorizationGroup | AuthorizationGroup | AuthorizGroup | ||
| BusinessPartner | BusinessPartner | Partner | ||
| DataControllerSet | DataControllerSet | |||
| MDChgProcessSrceBusPart1 | ||||
| MDChgProcessSrceBusPart2 | ||||
| BP1AuthorizationGroup | AuthorizationGroup | Authorization Group | ||
| BP2AuthorizationGroup | 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 | |
| KEY | MDChangeProcessModelFieldName | I_BPRelshpProcessChangesUnion | MDChangeProcessModelFieldName | |
| KEY | MDChgProcessRecordObjectID | I_BPRelshpProcessChangesUnion | MDChgProcessRecordObjectID | |
| KEY | MDChgProcessSrceObjectTypeCode | |||
| MDChangeProcModelTableDesc | I_BPRelshpProcessChangesUnion | MDChangeProcModelTableDesc | ||
| MDChangeProcessModelFieldDesc | I_BPRelshpProcessChangesUnion | MDChangeProcessModelFieldDesc | ||
| MDChgProcModelNodeExternalName | I_BPRelshpProcessChangesUnion | MDChgProcModelNodeExternalName | ||
| MDChgProcModTableExternalName | I_BPRelshpProcessChangesUnion | MDChgProcModTableExternalName | ||
| MDChgProcModFieldExternalName | I_BPRelshpProcessChangesUnion | MDChgProcModFieldExternalName | ||
| MDChgProcCurrentAttributeValue | I_BPRelshpProcessChangesUnion | MDChgProcCurrentAttributeValue | ||
| MDChgProcPrevAttributeValue | I_BPRelshpProcessChangesUnion | MDChgProcPrevAttributeValue | ||
| MDChgProcessAttributeIsChanged | I_BPRelshpProcessChangesUnion | MDChgProcessAttributeIsChanged | ||
| MDChgProcessSourceModified | I_BPRelshpProcessChangesUnion | MDChgProcessSourceModified | Modified | |
| MDChgProcessRecordObjectText | I_BPRelshpProcessChangesUnion | MDChgProcessRecordObjectText | ||
| IsBusinessPurposeCompleted | I_BusinessPartnerProcessTP | IsBusinessPurposeCompleted | Purpose Completed | |
| AuthorizationGroup | I_BusinessPartnerProcessTP | AuthorizationGroup | AuthorizGroup | |
| BusinessPartner | I_BPRelshpProcessChangesUnion | BusinessPartner1 | Partner | |
| DataControllerSet | I_BPRelshpProcessChangesUnion | BP1DataControllerSet | ||
| 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_BPRelshpProcessChangesUnion | MDChgProcessSrceSystem | Source System |
| KEY | MDChgProcessSrceObject | I_BusinessPartnerProcessTP | MDChgProcessSrceObject | Source ID |
| KEY | MDChgProcessModelTableName | I_BPRelshpProcessChangesUnion | MDChgProcessModelTableName | |
| KEY | MDChangeProcessModelFieldName | I_BPRelshpProcessChangesUnion | MDChangeProcessModelFieldName | |
| KEY | MDChgProcessRecordObjectID | I_BPRelshpProcessChangesUnion | MDChgProcessRecordObjectID | |
| KEY | MDChgProcessSrceObjectTypeCode | |||
| MDChangeProcModelTableDesc | I_BPRelshpProcessChangesUnion | MDChangeProcModelTableDesc | ||
| MDChangeProcessModelFieldDesc | I_BPRelshpProcessChangesUnion | MDChangeProcessModelFieldDesc | ||
| MDChgProcModelNodeExternalName | I_BPRelshpProcessChangesUnion | MDChgProcModelNodeExternalName | ||
| MDChgProcModTableExternalName | I_BPRelshpProcessChangesUnion | MDChgProcModTableExternalName | ||
| MDChgProcModFieldExternalName | I_BPRelshpProcessChangesUnion | MDChgProcModFieldExternalName | ||
| MDChgProcCurrentAttributeValue | I_BPRelshpProcessChangesUnion | MDChgProcCurrentAttributeValue | ||
| MDChgProcPrevAttributeValue | I_BPRelshpProcessChangesUnion | MDChgProcPrevAttributeValue | ||
| MDChgProcessAttributeIsChanged | I_BPRelshpProcessChangesUnion | MDChgProcessAttributeIsChanged | ||
| MDChgProcessSourceModified | I_BPRelshpProcessChangesUnion | MDChgProcessSourceModified | Modified | |
| MDChgProcessRecordObjectText | I_BPRelshpProcessChangesUnion | MDChgProcessRecordObjectText | ||
| IsBusinessPurposeCompleted | I_BusinessPartnerProcessTP | IsBusinessPurposeCompleted | Purpose Completed | |
| AuthorizationGroup | I_BusinessPartnerProcessTP | AuthorizationGroup | AuthorizGroup | |
| BusinessPartner | I_BPRelshpProcessChangesUnion | BusinessPartner2 | Partner | |
| DataControllerSet | I_BPRelshpProcessChangesUnion | BP2DataControllerSet | ||
| 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 | |
| KEY | MDChangeProcessModelFieldName | I_BPRelshpProcessChangesUnion | MDChangeProcessModelFieldName | |
| KEY | MDChgProcessRecordObjectID | I_BPRelshpProcessChangesUnion | MDChgProcessRecordObjectID | |
| KEY | MDChgProcessSrceObjectTypeCode | |||
| MDChangeProcModelTableDesc | I_BPRelshpProcessChangesUnion | MDChangeProcModelTableDesc | ||
| MDChangeProcessModelFieldDesc | I_BPRelshpProcessChangesUnion | MDChangeProcessModelFieldDesc | ||
| MDChgProcModelNodeExternalName | I_BPRelshpProcessChangesUnion | MDChgProcModelNodeExternalName | ||
| MDChgProcModTableExternalName | I_BPRelshpProcessChangesUnion | MDChgProcModTableExternalName | ||
| MDChgProcModFieldExternalName | I_BPRelshpProcessChangesUnion | MDChgProcModFieldExternalName | ||
| MDChgProcCurrentAttributeValue | I_BPRelshpProcessChangesUnion | MDChgProcCurrentAttributeValue | ||
| MDChgProcPrevAttributeValue | I_BPRelshpProcessChangesUnion | MDChgProcPrevAttributeValue | ||
| MDChgProcessAttributeIsChanged | I_BPRelshpProcessChangesUnion | MDChgProcessAttributeIsChanged | ||
| MDChgProcessSourceModified | I_BPRelshpProcessChangesUnion | MDChgProcessSourceModified | Modified | |
| MDChgProcessRecordObjectText | I_BPRelshpProcessChangesUnion | MDChgProcessRecordObjectText | ||
| IsBusinessPurposeCompleted | I_BusinessPartnerProcessTP | IsBusinessPurposeCompleted | Purpose Completed | |
| AuthorizationGroup | I_BusinessPartnerProcessTP | AuthorizationGroup | AuthorizGroup | |
| BusinessPartner | I_BPRelshpProcessChangesUnion | BusinessPartner1 | Partner | |
| DataControllerSet | I_BPRelshpProcessChangesUnion | BP1DataControllerSet | ||
| 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 | |
| KEY | MDChangeProcessModelFieldName | I_BPRelshpProcessChangesUnion | MDChangeProcessModelFieldName | |
| KEY | MDChgProcessRecordObjectID | I_BPRelshpProcessChangesUnion | MDChgProcessRecordObjectID | |
| KEY | MDChgProcessSrceObjectTypeCode | |||
| MDChangeProcModelTableDesc | I_BPRelshpProcessChangesUnion | MDChangeProcModelTableDesc | ||
| MDChangeProcessModelFieldDesc | I_BPRelshpProcessChangesUnion | MDChangeProcessModelFieldDesc | ||
| MDChgProcModelNodeExternalName | I_BPRelshpProcessChangesUnion | MDChgProcModelNodeExternalName | ||
| MDChgProcModTableExternalName | I_BPRelshpProcessChangesUnion | MDChgProcModTableExternalName | ||
| MDChgProcModFieldExternalName | I_BPRelshpProcessChangesUnion | MDChgProcModFieldExternalName | ||
| MDChgProcCurrentAttributeValue | I_BPRelshpProcessChangesUnion | MDChgProcCurrentAttributeValue | ||
| MDChgProcPrevAttributeValue | I_BPRelshpProcessChangesUnion | MDChgProcPrevAttributeValue | ||
| MDChgProcessAttributeIsChanged | I_BPRelshpProcessChangesUnion | MDChgProcessAttributeIsChanged | ||
| MDChgProcessSourceModified | I_BPRelshpProcessChangesUnion | MDChgProcessSourceModified | Modified | |
| MDChgProcessRecordObjectText | I_BPRelshpProcessChangesUnion | MDChgProcessRecordObjectText | ||
| IsBusinessPurposeCompleted | I_BusinessPartnerProcessTP | IsBusinessPurposeCompleted | Purpose Completed | |
| AuthorizationGroup | I_BusinessPartnerProcessTP | AuthorizationGroup | AuthorizGroup | |
| BusinessPartner | I_BPRelshpProcessChangesUnion | BusinessPartner2 | Partner | |
| DataControllerSet | I_BPRelshpProcessChangesUnion | BP2DataControllerSet | ||
| 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.
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,
IsBusinessPurposeCompleted,
AuthorizationGroup,
BusinessPartner,
DataControllerSet,
cast ( '' as mdc_bprel_source_partner ) AS MDChgProcessSrceBusPart1,
cast ( '' as mdc_bprel_source_partner ) AS MDChgProcessSrceBusPart2,
AuthorizationGroup AS BP1AuthorizationGroup,
AuthorizationGroup AS BP2AuthorizationGroup,
Changes.RelationshipCategory AS RelationshipCategory
FROM I_BPProcessChangesUnion
INNER JOIN I_BusinessPartnerProcessTP AS BusinessPartner ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_BPRelshpProcessChangesUnion
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA