I_BPHierNodeChangeProcessGov

@EndUserText.label: 'Change Process (Gov) of BP Hierarchy'
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view entity I_BPHierNodeChangeProcessGov
  as select from I_MasterDataChangeProcess as Process
    inner join   bph_node_prc              as BPHierNodeProcess on BPHierNodeProcess.process_id = Process.MasterDataChangeProcess
{

  key BPHierNodeProcess.process_id      as MasterDataChangeProcess,      
  key BPHierNodeProcess.source_system   as MDChgProcessSrceSystem,
  key BPHierNodeProcess.source_id       as MDChgProcessSrceObject,
  //key 

      BPHierNodeProcess.process_step_no as MDChgProcessStep,
      
      Process.MasterDataChangeProcessUUID,
      Process.MDChgProcessDescription,
      Process.MDChgProcessTypeID,
      Process.MDChgProcessGoal,
      Process.MDChgProcessStatus,
      Process.MDChgProcessSrceObjectTypeCode,
      Process.MDChgProcessRequestor,
      Process.MDChgProcessIsStarted,
      Process.MDChgProcessIsFinalized,
      Process.MDChgProcessLastStepIsFinished,
      Process.MDChgProcessCurrentStepNumber,
      Process.MDChgProcessIsErased
}
where
  (
        BPHierNodeProcess.process_step_no     =  Process.MDChgProcessCurrentStepNumber
    and Process.MDChgProcessCurrentStepNumber <> '0000'
  )
  or(
        BPHierNodeProcess.process_step_no     =  '0001'
    and Process.MDChgProcessCurrentStepNumber =  '0000'
  )