C_BPRelshpProcessChangesUnion

DDL: C_BPRELSHPPROCESSCHANGESUNION SQL: CBPRELPROCCHGUN Type: view CONSUMPTION
46 Fields 1 Data Sources 1 Associations

BP Relationship Process Changes Union

C_BPRelshpProcessChangesUnion is a Consumption CDS View that provides data about "BP Relationship Process Changes Union" in SAP S/4HANA. It reads from 1 data source (I_BPRelshpProcessChangesUnion) and exposes 46 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, MDChgProcessModelTableName. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_BPRelshpProcessChangesUnion I_BPRelshpProcessChangesUnion from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerProcessTP _BusinessPartner $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess and $projection.MDChgProcessStep = _BusinessPartner.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem and ( $projection.MDChgProcessSrceObject = _BusinessPartner.MDChgProcessSrceObject or $projection.MDChgProcessSrceBusPart1 = _BusinessPartner.MDChgProcessSrceObject or $projection.MDChgProcessSrceBusPart2 = _BusinessPartner.MDChgProcessSrceObject )

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CBPRELPROCCHGUN view
EndUserText.label BP Relationship Process Changes Union view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (46)

KeyFieldSource TableSource FieldDescription
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
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
RelationshipCategory RelationshipCategory Relationsh.Cat.
BP1AuthorizationGroup BP1AuthorizationGroup Authorization Group
BP2AuthorizationGroup BP2AuthorizationGroup Authorization Group
BP1DataControllerSet BP1DataControllerSet
BP1DataController1 BP1DataController1
BP1DataController2 BP1DataController2
BP1DataController3 BP1DataController3
BP1DataController4 BP1DataController4
BP1DataController5 BP1DataController5
BP1DataController6 BP1DataController6
BP1DataController7 BP1DataController7
BP1DataController8 BP1DataController8
BP1DataController9 BP1DataController9
BP1DataController10 BP1DataController10
BP2DataControllerSet BP2DataControllerSet
BP2DataController1 BP2DataController1
BP2DataController2 BP2DataController2
BP2DataController3 BP2DataController3
BP2DataController4 BP2DataController4
BP2DataController5 BP2DataController5
BP2DataController6 BP2DataController6
BP2DataController7 BP2DataController7
BP2DataController8 BP2DataController8
BP2DataController9 BP2DataController9
BP2DataController10 BP2DataController10
IsBusinessPurposeCompleted _BusinessPartner IsBusinessPurposeCompleted Purpose Completed
AuthorizationGroup _BusinessPartner AuthorizationGroup AuthorizGroup
MDChgProcessSrceBusPart1 MDChgProcessSrceBusPart1
MDChgProcessSrceBusPart2 MDChgProcessSrceBusPart2

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_BPRelshpProcessChangesUnion.
-- 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: CBPRELPROCCHGUN

CREATE VIEW C_BPRelshpProcessChangesUnion AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  MDChgProcessModelTableName,
  MDChangeProcessModelFieldName,
  MDChgProcessRecordObjectID,
  MDChangeProcModelTableDesc,
  MDChangeProcessModelFieldDesc,
  MDChgProcModelNodeExternalName,
  MDChgProcModTableExternalName,
  MDChgProcModFieldExternalName,
  MDChgProcCurrentAttributeValue,
  MDChgProcPrevAttributeValue,
  MDChgProcessAttributeIsChanged,
  MDChgProcessSourceModified,
  MDChgProcessRecordObjectText,
  RelationshipCategory,
  BP1AuthorizationGroup,
  BP2AuthorizationGroup,
  BP1DataControllerSet,
  BP1DataController1,
  BP1DataController2,
  BP1DataController3,
  BP1DataController4,
  BP1DataController5,
  BP1DataController6,
  BP1DataController7,
  BP1DataController8,
  BP1DataController9,
  BP1DataController10,
  BP2DataControllerSet,
  BP2DataController1,
  BP2DataController2,
  BP2DataController3,
  BP2DataController4,
  BP2DataController5,
  BP2DataController6,
  BP2DataController7,
  BP2DataController8,
  BP2DataController9,
  BP2DataController10,
  _BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  MDChgProcessSrceBusPart1,
  MDChgProcessSrceBusPart2
FROM I_BPRelshpProcessChangesUnion
LEFT OUTER JOIN I_BusinessPartnerProcessTP AS _BusinessPartner ON MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess AND MDChgProcessStep = _BusinessPartner.MDChgProcessStep AND MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem AND ( MDChgProcessSrceObject = _BusinessPartner.MDChgProcessSrceObject OR MDChgProcessSrceBusPart1 = _BusinessPartner.MDChgProcessSrceObject OR MDChgProcessSrceBusPart2 = _BusinessPartner.MDChgProcessSrceObject )  -- association [1..1]
;

Learn More