C_MDChangeProcessLogHeader

@AbapCatalog.sqlViewName: 'CMDCHNGPROCLOGH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'MD Change Process Application Log'
@VDM.viewType: #CONSUMPTION

@ObjectModel: {
  transactionalProcessingEnabled: false,
  createEnabled: false,
  updateEnabled: false,
  deleteEnabled: false,
  usageType.serviceQuality: #C,
  usageType.sizeCategory : #L,
  usageType.dataClass: #TRANSACTIONAL
}

define view C_MDChangeProcessLogHeader
  as select from I_MDChangeProcessLogHeader
  //  association [1..1] to C_MasterDataChangeProcess      as _Root                     on  _Root.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID

  //  association [1..1] to C_MasterDataChangeProcessStep  as _Step                     on  _Step.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID


  association [0..1] to C_MDChgProcStepActivationKPI   as _MDChgProcStepActKPI      on  _MDChgProcStepActKPI.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
                                                                                    and _MDChgProcStepActKPI.MDChgProcessStepType = $projection.MDChgProcessStepType

  association [0..1] to C_MDChgProcStepBstRecdCalcKPI  as _MDChgProcStepBrcKPI      on  _MDChgProcStepBrcKPI.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
                                                                                    and _MDChgProcStepBrcKPI.MDChgProcessStepType = $projection.MDChgProcessStepType

  association [0..1] to C_MDChgProcStepEditKPISmmry    as _MDChgProcStepEdiKPISmmry on  _MDChgProcStepEdiKPISmmry.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
                                                                                    and _MDChgProcStepEdiKPISmmry.MDChgProcessStepType = $projection.MDChgProcessStepType

  association [0..*] to C_MDChgProcStepEditKPI         as _MDChgProcStepEdiKPI      on  _MDChgProcStepEdiKPI.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
                                                                                    and _MDChgProcStepEdiKPI.MDChgProcessStepType = $projection.MDChgProcessStepType

  association [0..1] to C_MDChgProcStepEvalKPISmmry    as _MDChgProcStepEvaKPISmmry on  _MDChgProcStepEvaKPISmmry.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
                                                                                    and _MDChgProcStepEvaKPISmmry.MDChgProcessStepType = $projection.MDChgProcessStepType

  association [0..*] to C_MDChgProcStepEvaluationKPI   as _MDChgProcStepEvaKPI      on  _MDChgProcStepEvaKPI.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
                                                                                    and _MDChgProcStepEvaKPI.MDChgProcessStepType = $projection.MDChgProcessStepType

  //  association [0..1] to C_MDChgProcEnrichmentSearchKPI as _MDChgProcStepDesKPI      on _MDChgProcStepDesKPI.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID

  //

  //  association [0..1] to C_MDChgProcStepEnrichKPISmmry  as _MDChgProcStepDeeKPISmmry on _MDChgProcStepDeeKPISmmry.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID

  //

  //  association [0..*] to C_MDChgProcStepEnrichmentKPI   as _MDChgProcStepDeeKPI      on _MDChgProcStepDeeKPI.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID


  association [0..1] to C_MDChgProcStepFilterRemoveKPI as _MDChgProcStepFarKPI      on  _MDChgProcStepFarKPI.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
                                                                                    and _MDChgProcStepFarKPI.MDChgProcessStepType = $projection.MDChgProcessStepType

  association [0..1] to C_MDChgProcStepMatchingKPI     as _MDChgProcStepMtcKPI      on  _MDChgProcStepMtcKPI.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
                                                                                    and _MDChgProcStepMtcKPI.MDChgProcessStepType = $projection.MDChgProcessStepType

  association [0..1] to C_MDChgProcStepStdznKPI        as _MDChgProcStepStdKPI      on  _MDChgProcStepStdKPI.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
                                                                                    and _MDChgProcStepStdKPI.MDChgProcessStepType = $projection.MDChgProcessStepType

  association [0..1] to C_MDChgProcStepUpdateKPISmmry  as _MDChgProcStepUpdKPISmmry on  _MDChgProcStepUpdKPISmmry.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
                                                                                    and _MDChgProcStepUpdKPISmmry.MDChgProcessStepType = $projection.MDChgProcessStepType

  association [0..*] to C_MDChgProcStepUpdateKPI       as _MDChgProcStepUpdKPI      on  _MDChgProcStepUpdKPI.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
                                                                                    and _MDChgProcStepUpdKPI.MDChgProcessStepType = $projection.MDChgProcessStepType

  association [0..1] to C_MDChgProcStepValidationKPI   as _MDChgProcStepValKPI      on  _MDChgProcStepValKPI.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
                                                                                    and _MDChgProcStepValKPI.MDChgProcessStepType = $projection.MDChgProcessStepType

  association [0..1] to C_MDChgProcStepFederationKPI   as _MDChgProcStepFedKPI      on  _MDChgProcStepFedKPI.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
                                                                                    and _MDChgProcStepFedKPI.MDChgProcessStepType = $projection.MDChgProcessStepType

  association [0..1] to C_MDChgProcStepSimlnKPISmmry   as _MDChgProcStepSimKPISmmry on  _MDChgProcStepSimKPISmmry.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
                                                                                    and _MDChgProcStepSimKPISmmry.MDChgProcessStepType = $projection.MDChgProcessStepType

  association [0..*] to C_MDChgProcStepSimulationKPI   as _MDChgProcStepSimKPI      on  _MDChgProcStepSimKPI.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
                                                                                    and _MDChgProcStepSimKPI.MDChgProcessStepType = $projection.MDChgProcessStepType

  association [0..1] to C_MDChgProcStepReplicationKPI  as _MDChgProcStepRepKPI      on  _MDChgProcStepRepKPI.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
                                                                                    and _MDChgProcStepRepKPI.MDChgProcessStepType = $projection.MDChgProcessStepType

  association [0..*] to C_MDChgProcStepDataProviderKPI as _MDChgProcStepDpiKPI      on  _MDChgProcStepDpiKPI.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
                                                                                    and _MDChgProcStepDpiKPI.MDChgProcessStepType = $projection.MDChgProcessStepType

  association [0..1] to C_MDChgProcStpDtaPrvdrKPISmmry as _MDChgProcStepDpiKPISmmry on  _MDChgProcStepDpiKPISmmry.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
                                                                                    and _MDChgProcStepDpiKPISmmry.MDChgProcessStepType = $projection.MDChgProcessStepType

  association [0..*] to I_MDChgProcKPIFilterUnion      as _MDChgProcKPIFilter       on  _MDChgProcKPIFilter.MDChgProcessStepUUID = $projection.MDChgProcessStepUUID
{
      //I_MDChangeProcessLogHeader

  key MDChgProcessStepUUID,
      MasterDataChangeProcessUUID,
      MasterDataChangeProcess,
      MDChgProcessStep,
      MDChgProcessTypeID,
      MDChgProcessGoal,
      MDChgProcessStatus,
      MDChgProcessSrceObjectTypeCode,
      MDChgProcessStepAdapter,
      MDChgProcessStepType,
      MDChgProcessStepStatus,
      MDChgProcessStepStartDateTime,
      MDChgProcessStepFinishDateTime,
      MDChgProcStpNumberOfExceptions,
      MDChgProcessStepNumberOfErrors,
      MDChgProcStepNumberOfWarnings,
      /* Associations */
      //I_MDChangeProcessLogHeader

      //      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]

      //      _Root,

      //      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]

      //      _Step,

      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcStepActKPI,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcStepBrcKPI,
      //      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]

      //      _MDChgProcStepDesKPI,

      //      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]

      //      _MDChgProcStepDeeKPISmmry,

      //      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]

      //      _MDChgProcStepDeeKPI,

      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcStepEdiKPISmmry,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcStepEdiKPI,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcStepEvaKPISmmry,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcStepEvaKPI,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcStepFarKPI,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcStepMtcKPI,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcStepStdKPI,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcStepUpdKPISmmry,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcStepUpdKPI,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcStepValKPI,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcStepFedKPI,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcStepSimKPISmmry,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcStepSimKPI,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcStepRepKPI,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcKPIFilter,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcStepDpiKPI,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MDChgProcStepDpiKPISmmry
}