I_MDCHGPROCMATCHGRPRECDCOUNT

CDS View

MD Cons Match Group Rec Count

I_MDCHGPROCMATCHGRPRECDCOUNT is a CDS View in S/4HANA. MD Cons Match Group Rec Count. It contains 5 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 5 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MDChgProcessMatchGroupTP view_entity from TRANSACTIONAL Master Data Consolidation: Match Group

Fields (5)

KeyField CDS FieldsUsed in Views
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessMatchGroupID MDChgProcessMatchGroupID 1
KEY MDChgProcessSrceObjectTypeCode MDChgProcessSrceObjectTypeCode 1
MDChgProcessNmbrOfSrceRecords MDChgProcessNmbrOfSrceRecords 1
MDChgProcessStep MDChgProcessStep 1 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'MD Cons Match Group Rec Count'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
define view entity I_MDChgProcMatchGrpRecdCount
  as select distinct from I_MDChgProcessMatchGroup      as MatchGroup
    inner join            P_MDChgProcLastCmpltdMtchgStp as LastMTCStep on MatchGroup.MasterDataChangeProcess = LastMTCStep.MasterDataChangeProcess
    inner join            I_MDChgProcessStep            as Step        on  LastMTCStep.MasterDataChangeProcess = Step.MasterDataChangeProcess
                                                                       and LastMTCStep.MDChgProcessStep        = Step.MDChgProcessStep
{
  key MatchGroup.MasterDataChangeProcess,
  key MatchGroup.MDChgProcessMatchGroupID,
  key Step.MDChgProcessSrceObjectTypeCode,
      Step.MDChgProcessStep,
//      MatchGroup.MDChgProcMatchGrpApprvlStatus,

//      MatchGroup.MDChgProcMatchGroupApprover,

      count( * ) as MDChgProcessNmbrOfSrceRecords
}
group by
  MatchGroup.MasterDataChangeProcess,
  MatchGroup.MDChgProcessMatchGroupID,
  Step.MDChgProcessSrceObjectTypeCode,
  Step.MDChgProcessStep
//  MatchGroup.MDChgProcMatchGrpApprvlStatus,

//  MatchGroup.MDChgProcMatchGroupApprover


union select distinct from I_MDChgProcIntmdMatchGrp      as MatchGroup
  inner join               I_MasterDataChangeProcess     as Process      on MatchGroup.MasterDataChangeProcess = Process.MasterDataChangeProcess
  inner join               P_MDChgProcLastCmpltdMtchgStp as LastMTCStep  on MatchGroup.MasterDataChangeProcess = LastMTCStep.MasterDataChangeProcess
  inner join               I_MDChgProcessStep            as MatchingStep on  MatchGroup.MasterDataChangeProcess  =  MatchingStep.MasterDataChangeProcess
                                                                         and MatchingStep.MDChgProcessStepType   =  'MTC'
                                                                         and MatchingStep.MDChgProcessStepStatus =  '4'
                                                                         and LastMTCStep.MDChgProcessStep        <> MatchingStep.MDChgProcessStep
{
  key MatchGroup.MasterDataChangeProcess                                                                                           as MasterDataChangeProcess,
  key MatchGroup.MDChgProcessMatchGroupID                                                                                          as MDChgProcessMatchGroupID,
  key MatchGroup.MDChgProcessSrceObjectTypeCode                                                                                    as MDChgProcessSrceObjectTypeCode,
      case when MatchingStep.MDChgProcessStep is not null then MatchingStep.MDChgProcessStep else LastMTCStep.MDChgProcessStep end as MDChgProcessStep,
//      MatchGroup.MDChgProcMatchGrpApprvlStatus,

//      MatchGroup.MDChgProcMatchGroupApprover,

      count( * )                                                                                                                   as MDChgProcessNmbrOfSrceRecords
}
where
      Process.MDChgProcessStatus   <> 'F'
  and Process.MDChgProcessIsErased <> 'X'
group by
  MatchGroup.MasterDataChangeProcess,
  MatchGroup.MDChgProcessMatchGroupID,
  MatchGroup.MDChgProcessSrceObjectTypeCode,
  LastMTCStep.MDChgProcessStep,
  MatchingStep.MDChgProcessStep
//  MatchGroup.MDChgProcMatchGrpApprvlStatus,

//  MatchGroup.MDChgProcMatchGroupApprover

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MASTERDATACHANGEPROCESS",
"I_MDCHGPROCESSMATCHGROUP",
"I_MDCHGPROCESSSTEP",
"I_MDCHGPROCINTMDMATCHGRP",
"P_MDCHGPROCLASTCMPLTDMTCHGSTP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More