I_MasterDataChangeProcess

@AbapCatalog.sqlViewName: 'IMDCHGPROCESS'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Data Change Process'
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'MasterDataChangeProcessUUID'
@ObjectModel.semanticKey: 'MasterDataChangeProcess'
@Metadata.allowExtensions:true
@AbapCatalog.preserveKey:true

@ObjectModel.usageType: { dataClass: #TRANSACTIONAL, sizeCategory: #M, serviceQuality: #B }

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

define view I_MasterDataChangeProcess
  as select from mdc_d_prcroot as _Process
  //    inner join   I_MDChgProcessAuthorityCheck as _Auth on _Auth.MasterDataChangeProcessUUID = _Process.db_key


  association [1..1] to I_MDChgProcessAuthorityCheck as _Auth                  on _Auth.MasterDataChangeProcessUUID = _Process.db_key
  association [0..*] to I_MDChgProcessStep           as _MDChgProcessStep      on _MDChgProcessStep.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
  association [0..*] to I_MDChangeProcessSource      as _MDChangeProcessSource on _MDChangeProcessSource.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID



{
      // key

  key _Process.db_key                      as MasterDataChangeProcessUUID,
      // data

      _Process.id                          as MasterDataChangeProcess,
      @Semantics.text: true
      _Process.description                 as MDChgProcessDescription,
      _Process.type_id                     as MDChgProcessTypeID,
      _Process.goal                        as MDChgProcessGoal,
      _Process.status                      as MDChgProcessStatus,
      _Process.source_otc                  as MDChgProcessSrceObjectTypeCode,
      _Process.workflow                    as MDChgProcessWorkflowTemplate,
      _Process.requestor                   as MDChgProcessRequestor,
      _Process.delete_source               as MDChgProcessDelSrceDataIsRqd,
      _Process.create_date                 as MDChgProcessCreationDate,
      _Process.create_time                 as MDChgProcessCreationTime,
      _Process.change_date                 as MDChgProcessChangeDate,
      _Process.change_time                 as MDChgProcessChangeTime,
      _Process.finish_date                 as MDChgProcessFinishDate,
      _Process.finish_time                 as MDChgProcessFinishTime,
      _Process.update_counter              as MDChgProcessUpdateToken,
      _Process.started                     as MDChgProcessIsStarted,
      _Process.initialized                 as MDChgProcessIsInitialized,
      _Process.finalized                   as MDChgProcessIsFinalized,
      _Process.last_step_finished          as MDChgProcessLastStepIsFinished,
      _Process.current_step_no             as MDChgProcessCurrentStepNumber,
      _Process.check_point_active          as MDChgProcessChkPointIsActive,
      _Process.complete_requested          as MDChgProcessCompletionIsReqd,
      _Process.wf_delete_requested         as MDChgProcessWrkFlwDeltnIsRqd,
      _Process.src_delete_requested        as MDChgProcessSrceDeletionIsRqd,
      _Process.filter_chain                as MDChgProcessFilterChain,
      _Process.log_error                   as MDChgProcessErrorsAreLogged,
      _Process.last_act_key                as MDChgProcessLastActKey,
      _Process.predecessor_id              as MDChgProcessPredecessor,
      _Process.finalizing_at               as MDChgProcessFinalDateTime,
      _Process.next_step_scheduled_at      as MDChgProcessNextStpAtDateTime,
      _Process.duplicate_strategy          as MDChgProcessDuplicateStrategy,
      _Process.reliable                    as MDChgProcessIsReliable,
      _Process.erased                      as MDChgProcessIsErased,
      _Process.protection_reason           as MDChgProcessProtectionReason,
      _Process.referenced_federation_token as MDChgProcRefcdFederationToken,
      _Process.referenced_fed_proc_step    as MDChgProcRefcdFederationStp,
      _Process.federation_proc_bus_system  as MDChgProcFederationBusSystName,
      //    associations

      _MDChgProcessStep,
      _MDChangeProcessSource

}
where
  _Auth.MasterDataChangeProcessUUID is not null