I_BPHierChangeProcessGov

@EndUserText.label: 'Change Process (Governance) of BPH'
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view entity I_BPHierChangeProcessGov
  as select from I_MasterDataChangeProcess as Process
    inner join   bph_hier_prc              as BPHierProcess on BPHierProcess.process_id = Process.MasterDataChangeProcess
                                                           and BPHierProcess.process_step_no = '0001'
    association [0..1] to I_MDChangeProcessReasonText    as _ReasonText                on  _ReasonText.MasterDataChangeProcessReason  = $projection.MasterDataChangeProcessReason
                                                                                       and _ReasonText.MDChgProcessSrceObjectTypeCode = $projection.MDChgProcessSrceObjectTypeCode
                                                                                       and _ReasonText.Language                       = $session.system_language
                                                                                       
    association [0..1] to I_MDChangeProcessPriorityText  as _PriorityText              on  _PriorityText.MDChangeProcessPriority = $projection.MDChangeProcessPriority
                                                                                       and _PriorityText.Language                = $session.system_language                                                                                
{
  key BPHierProcess.process_id      as MasterDataChangeProcess,
  key BPHierProcess.process_step_no as MDChgProcessStep,
  key BPHierProcess.source_system   as MDChgProcessSrceSystem,
  key BPHierProcess.source_id       as MDChgProcessSrceObject,
      Process.MasterDataChangeProcessUUID,
      Process.MDChgProcessDescription,
      Process.MDChgProcessTypeID,
      Process.MDChgProcessGoal,
      Process.MDChgProcessStatus,
      Process.MDChgProcessSrceObjectTypeCode,
      Process.MDChgProcessRequestor,
      Process.MDChgProcessIsStarted,
      Process.MDChgProcessIsFinalized,
      Process.MDChgProcessLastStepIsFinished,
      Process.MDChgProcessCurrentStepNumber,
      Process.MDChgProcessIsErased,
      Process.MasterDataChangeProcessReason,
      _ReasonText.MDChangeProcessReasonText,
      Process.MDChangeProcessPriority,
      _PriorityText.MDChangeProcessPriorityText,
      Process.MasterDataChangeProcessDueDate
}
//where

//  (

//        BPHierProcess.process_step_no         =  Process.MDChgProcessCurrentStepNumber

//    and Process.MDChgProcessCurrentStepNumber <> '0000'

//  )

//  or(

//        BPHierProcess.process_step_no         =  '0001'

//    and Process.MDChgProcessCurrentStepNumber =  '0000'

//  )