I_MDChgProcessMatchGroupTP

DDL: I_MDCHGPROCESSMATCHGROUPTP Type: view_entity TRANSACTIONAL Package: MDC_MODEL

Master Data Consolidation: Match Group

I_MDChgProcessMatchGroupTP is a Transactional CDS View that provides data about "Master Data Consolidation: Match Group" in SAP S/4HANA. It reads from 2 data sources (I_MasterDataChangeProcess, I_MDChgProcMatchGrpRecdCount) and exposes 14 fields with key fields MasterDataChangeProcess, MDChgProcessMatchGroupID, MDChgProcessSrceObjectTypeCode. It has 5 associations to related views. Part of development package MDC_MODEL.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_MasterDataChangeProcess MasterDataChangeProcess inner
I_MDChgProcMatchGrpRecdCount MatchGroup from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_MDChgProcessMatchGroupRecord _MatchGroupBestRecord $projection.MasterDataChangeProcess = _MatchGroupBestRecord.MasterDataChangeProcess and $projection.MDChgProcessMatchGroupID = _MatchGroupBestRecord.MDChgProcessMatchGroupID and _MatchGroupBestRecord.MDChgProcMatchGrpIsBestRecord = 'X'
[1..1] I_MDChgProcessApprovalStatus _MatchGroupApprovalStatus $projection.MDChgProcMatchGrpApprvlStatus = _MatchGroupApprovalStatus.MDChangeProcessApprovalStatus
[0..1] P_MDChgProcessOpenMatchGroup _OpenMatchGroup $projection.MasterDataChangeProcess = _OpenMatchGroup.MasterDataChangeProcess and $projection.MDChgProcessMatchGroupID = _OpenMatchGroup.MDChgProcessMatchGroupID
[0..1] I_MDChgProcessStepTP _Step _Step.MasterDataChangeProcess = $projection.MasterDataChangeProcess and _Step.MDChgProcessStep = $projection.MDChgProcessStep
[1..*] I_MDChgProcMatchGroupRecordTP _MatchGroupRecord

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Master Data Consolidation: Match Group view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess I_MDChgProcMatchGrpRecdCount MasterDataChangeProcess
KEY MDChgProcessMatchGroupID I_MDChgProcMatchGrpRecdCount MDChgProcessMatchGroupID
KEY MDChgProcessSrceObjectTypeCode I_MDChgProcMatchGrpRecdCount MDChgProcessSrceObjectTypeCode
MDChgProcessStep I_MDChgProcMatchGrpRecdCount MDChgProcessStep
MDChgProcessNmbrOfSrceRecords I_MDChgProcMatchGrpRecdCount MDChgProcessNmbrOfSrceRecords
MDChgProcessGoal I_MasterDataChangeProcess MDChgProcessGoal
MDChgProcessCurrentStepNumber I_MasterDataChangeProcess MDChgProcessCurrentStepNumber
MasterDataChangeProcessUUID I_MasterDataChangeProcess MasterDataChangeProcessUUID
MDChgProcessStepWrkflwSts _Step MDChgProcessStepWrkflwSts
MDChgProcessStepWrkflwOvrlDcsn _Step MDChgProcessStepWrkflwOvrlDcsn
_MatchGroupRecord _MatchGroupRecord
_MatchGroupBestRecord _MatchGroupBestRecord
_MatchGroupApprovalStatus _MatchGroupApprovalStatus
_CurrentProcessStep 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Data Consolidation: Match Group'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #TRANSACTIONAL
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
define root view entity I_MDChgProcessMatchGroupTP
  as select from I_MDChgProcMatchGrpRecdCount as MatchGroup
    inner join   I_MasterDataChangeProcess    as MasterDataChangeProcess on MatchGroup.MasterDataChangeProcess = MasterDataChangeProcess.MasterDataChangeProcess

  composition [1..*] of I_MDChgProcMatchGroupRecordTP  as _MatchGroupRecord

  association [1..1] to I_MDChgProcessMatchGroupRecord as _MatchGroupBestRecord     on  $projection.MasterDataChangeProcess                 = _MatchGroupBestRecord.MasterDataChangeProcess
                                                                                    and $projection.MDChgProcessMatchGroupID                = _MatchGroupBestRecord.MDChgProcessMatchGroupID
                                                                                    and _MatchGroupBestRecord.MDChgProcMatchGrpIsBestRecord = 'X'
  association [1..1] to I_MDChgProcessApprovalStatus   as _MatchGroupApprovalStatus on  $projection.MDChgProcMatchGrpApprvlStatus = _MatchGroupApprovalStatus.MDChangeProcessApprovalStatus
  association [0..1] to P_MDChgProcessOpenMatchGroup   as _OpenMatchGroup           on  $projection.MasterDataChangeProcess  = _OpenMatchGroup.MasterDataChangeProcess
                                                                                    and $projection.MDChgProcessMatchGroupID = _OpenMatchGroup.MDChgProcessMatchGroupID
  association [0..1] to I_MDChgProcessStepTP          as _Step              on  _Step.MasterDataChangeProcess = $projection.MasterDataChangeProcess
                                                                            and _Step.MDChgProcessStep        = $projection.MDChgProcessStep
                                                                                    
{
  key MatchGroup.MasterDataChangeProcess,
  key MatchGroup.MDChgProcessMatchGroupID,
  key MatchGroup.MDChgProcessSrceObjectTypeCode,
      MatchGroup.MDChgProcessStep,
      MatchGroup.MDChgProcessNmbrOfSrceRecords,
      MasterDataChangeProcess.MDChgProcessGoal,
      MasterDataChangeProcess.MDChgProcessCurrentStepNumber,
      MasterDataChangeProcess.MasterDataChangeProcessUUID,
      case when _OpenMatchGroup.MDChgProcMatchGrpApprvlStatus is not null
        then _OpenMatchGroup.MDChgProcMatchGrpApprvlStatus
        else _MatchGroupBestRecord.MDChgProcMatchGrpApprvlStatus
      end as MDChgProcMatchGrpApprvlStatus,
      case when _OpenMatchGroup.MDChgProcMatchGrpApprvlStatus is not null
        then cast( '' as mdc_approver )
        else _MatchGroupBestRecord.MDChgProcMatchGroupApprover
      end as MDChgProcMatchGroupApprover,
      case when _OpenMatchGroup.MDChgProcMatchGrpApprvlStatus is not null
        then cast( 000000000000000 as mdc_approval_timestamp )
        else _MatchGroupBestRecord.MDChgProcMatchGrpApprvlDteTime
      end as MDChgProcMatchGrpApprvlDteTime,

      _Step.MDChgProcessStepWrkflwSts,
      _Step.MDChgProcessStepWrkflwOvrlDcsn,
      _MatchGroupRecord,
      _MatchGroupBestRecord,
      _MatchGroupApprovalStatus,
      MasterDataChangeProcess._MDChgProcessStep[ MDChgProcessStep = $projection.MDChgProcessCurrentStepNumber ] as _CurrentProcessStep

}

Learn More