I_MDChgProcessBPMatchGroupTP

DDL: I_MDCHGPROCESSBPMATCHGROUPTP Type: view_entity TRANSACTIONAL
35 Fields 3 Associations

Master Data Consolidation: BP Match Group

I_MDChgProcessBPMatchGroupTP is a Transactional CDS View that provides data about "Master Data Consolidation: BP Match Group" in SAP S/4HANA. It has 3 associations to related views.

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_MDChgProcBPMatchGroupRecdTP _BestRecordDetails $projection.MasterDataChangeProcess = _BestRecordDetails.MasterDataChangeProcess and $projection.MDChgProcessMatchGroupID = _BestRecordDetails.MDChgProcessMatchGroupID and $projection.MDChgProcessSrceObjectTypeCode = _BestRecordDetails.MDChgProcessSrceObjectTypeCode and _BestRecordDetails.MDChgProcMatchGrpIsBestRecord = 'X'
[0..1] I_MDChgProcessStepTP _Step _Step.MasterDataChangeProcess = $projection.MasterDataChangeProcess and _Step.MDChgProcessStep = $projection.MDChgProcessStep
[0..*] I_MDChgProcBPMatchGroupRecdTP _MatchGroupRecord

Annotations (8)

NameValueLevelField
Search.searchable true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Master Data Consolidation: BP Match Group view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessMatchGroupID MDChgProcessMatchGroupID
KEY MDChgProcessSrceObjectTypeCode MDChgProcessSrceObjectTypeCode Bus. Obj. Type
MDChgProcessNmbrOfSrceRecords MDChgProcessNmbrOfSrceRecords
MDChgProcessStep MDChgProcessStep Step Number
MDChgProcessCurrentStepNumber MDChgProcessCurrentStepNumber Step Number
MasterDataChangeProcessUUID MasterDataChangeProcessUUID NodeID
MDChgProcessGoal MDChgProcessGoal Process Goal
MDChgProcMatchGrpApprvlStatus MDChgProcMatchGrpApprvlStatus
_MatchGroupRecord _MatchGroupRecord
_MatchGroupApprovalStatus _MatchGroupApprovalStatus
MDChgProcessMatchGroupName _BestRecordDetails AddressLine1Text Address line
MDChgProcessSrceSystem _BestRecordDetails MDChgProcessSrceSystem Source System
MDChgProcessSrceObject _BestRecordDetails MDChgProcessSrceObject Source ID
MDChgProcessStepWrkflwDefID _Step MDChgProcessStepWrkflwDefID
MDChgProcessStepWrkflwHandle _Step MDChgProcessStepWrkflwHandle
MDChgProcessStepWrkflwSts _Step MDChgProcessStepWrkflwSts
MDChgProcessStepWrkflwOvrlDcsn _Step MDChgProcessStepWrkflwOvrlDcsn
AuthorizationGroup _BestRecordDetails AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted _BestRecordDetails IsBusinessPurposeCompleted Purpose Completed
BusinessPartner _BestRecordDetails BusinessPartner Issuing Authority
DataControllerSet _BestRecordDetails DataControllerSet Data Ctrlr. Set
DataController1 _BestRecordDetails DataController1 Data Controller
DataController2 _BestRecordDetails DataController2 Data Controller
DataController3 _BestRecordDetails DataController3 Data Controller
DataController4 _BestRecordDetails DataController4 Data Controller
DataController5 _BestRecordDetails DataController5 Data Controller
DataController6 _BestRecordDetails DataController6 Data Controller
DataController7 _BestRecordDetails DataController7 Data Controller
DataController8 _BestRecordDetails DataController8 Data Controller
DataController9 _BestRecordDetails DataController9 Data Controller
DataController10 _BestRecordDetails DataController10 Data Controller
_BestRecordDetails _BestRecordDetails
_CurrentProcessStep _CurrentProcessStep
_Step _Step

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 I_MDChgProcessBPMatchGroupTP.
-- 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 I_MDChgProcessBPMatchGroupTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessMatchGroupID,
  MDChgProcessSrceObjectTypeCode,
  MDChgProcessNmbrOfSrceRecords,
  MDChgProcessStep,
  MDChgProcessCurrentStepNumber,
  MasterDataChangeProcessUUID,
  MDChgProcessGoal,
  MDChgProcMatchGrpApprvlStatus,
  _BestRecordDetails.AddressLine1Text AS MDChgProcessMatchGroupName,
  _BestRecordDetails.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
  _BestRecordDetails.MDChgProcessSrceObject AS MDChgProcessSrceObject,
  _Step.MDChgProcessStepWrkflwDefID AS MDChgProcessStepWrkflwDefID,
  _Step.MDChgProcessStepWrkflwHandle AS MDChgProcessStepWrkflwHandle,
  _Step.MDChgProcessStepWrkflwSts AS MDChgProcessStepWrkflwSts,
  _Step.MDChgProcessStepWrkflwOvrlDcsn AS MDChgProcessStepWrkflwOvrlDcsn,
  _BestRecordDetails.AuthorizationGroup AS AuthorizationGroup,
  _BestRecordDetails.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _BestRecordDetails.BusinessPartner AS BusinessPartner,
  _BestRecordDetails.DataControllerSet AS DataControllerSet,
  _BestRecordDetails.DataController1 AS DataController1,
  _BestRecordDetails.DataController2 AS DataController2,
  _BestRecordDetails.DataController3 AS DataController3,
  _BestRecordDetails.DataController4 AS DataController4,
  _BestRecordDetails.DataController5 AS DataController5,
  _BestRecordDetails.DataController6 AS DataController6,
  _BestRecordDetails.DataController7 AS DataController7,
  _BestRecordDetails.DataController8 AS DataController8,
  _BestRecordDetails.DataController9 AS DataController9,
  _BestRecordDetails.DataController10 AS DataController10
LEFT OUTER JOIN I_MDChgProcBPMatchGroupRecdTP AS _BestRecordDetails ON MasterDataChangeProcess = _BestRecordDetails.MasterDataChangeProcess AND MDChgProcessMatchGroupID = _BestRecordDetails.MDChgProcessMatchGroupID AND MDChgProcessSrceObjectTypeCode = _BestRecordDetails.MDChgProcessSrceObjectTypeCode AND _BestRecordDetails.MDChgProcMatchGrpIsBestRecord = 'X'  -- association [1..1]
LEFT OUTER JOIN I_MDChgProcessStepTP AS _Step ON _Step.MasterDataChangeProcess = MasterDataChangeProcess AND _Step.MDChgProcessStep = MDChgProcessStep  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcBPMatchGroupRecdTP AS _MatchGroupRecord ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More