I_MDCHGPROCSTEPMATCHINGKPI

@AbapCatalog.sqlViewName: 'IMDCHNGPRCMTCKPI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'MD Change Process Step Matching KPI'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.semanticKey: ['MasterDataChangeProcess','MDChgProcessStep']
@VDM.viewType: #BASIC

@ObjectModel.alternativeKey: [{
        id : 'MASTERDATACHANGEPROCESS',
        uniqueness : #UNIQUE_IF_NOT_INITIAL,
        element : ['MASTERDATACHANGEPROCESS']
    },{
        id : 'MDCHGPROCESSSTEP',
        uniqueness : #UNIQUE_IF_NOT_INITIAL,
        element : ['MDCHGPROCESSSTEP']
    }]

@ObjectModel: {
    resultSet.sizeCategory: #XS,
    usageType.serviceQuality: #C,
    usageType.sizeCategory: #L,
    usageType.dataClass: #MIXED }

define view I_MDChgProcStepMatchingKPI
  as select distinct from mdc_d_prcstep as Step
    join                  mdc_d_prcroot as _Root on _Root.db_key = Step.parent_key
{
  key Step.db_key                                                                         as MDChgProcessStepUUID,
      process_id                                                                          as MasterDataChangeProcess,
      step_number                                                                         as MDChgProcessStep,
      _Root.type_id                                                                       as MDChgProcessTypeID,
      _Root.goal                                                                          as MDChgProcessGoal,
      case when Step.source_otc is initial then _Root.source_otc else Step.source_otc end as MDChgProcessSrceObjectTypeCode,
      adapter                                                                             as MDChgProcessStepAdapter,
      step_type                                                                           as MDChgProcessStepType,
      @ObjectModel.readOnly: true
      started_at                                                                          as MDChgProcessStepStartDateTime,
      @ObjectModel.readOnly: true
      finished_at                                                                         as MDChgProcessStepFinishDateTime,

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfMtchgGroups, // Groups

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfActiveMtchgGroups, // Actives

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfSourceMtchgGroups, // Sources

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfApprovedMtchgGroups, // Approved

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfOpenMtchgGroups, // OpenMatchGroup

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfRejectedMtchgGroups, // Rejected

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfDiscardedRecords, // DiscardedRecords


      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfActvOpenMtchgGroups, // StatusActivesOpen

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfActvApprovedMtchgGroups, // StatusActivesApproved

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfActvRejectedMtchgGroups, // StatusActivesRejected

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfActvOpenRecords, // StatusActivesOpenRecords

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfActvApprovedRecords, // StatusActivesApprovedRecords

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfActvRejectedRecords, // StatusActivesRejectedRecords


      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfSrceOpenMtchgGroups, // StatusSourcesOpen

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfSrceApprovedMtchgGroups, // StatusSourcesApproved

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfSrceRejectedMtchgGroups, // StatusSourcesRejected,

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfSrceOpenRecords, // StatusSourcesOpenRecords

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfSrceApprovedRecords, // StatusSourcesApprovedRecords

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROC_STEP_KPI_CALC_EXIT'
      cast( 0 as abap.int4 )                                                              as MDNrOfSrceRejectedRecords // StatusSourcesRejectedRecords


}
where
  Step.step_type = 'MTC' and ( Step.status = '4' or Step.status = '5' ) and _Root.last_step_finished <> 'X'