Apj_V_Job_Run_Aborted_Finished

@AbapCatalog.sqlViewName: 'APJ_V_AF_JOBS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'All aborted or finished application jobs'
define view Apj_V_Job_Run_Aborted_Finished
  as select from    apj_d_job_exe   as jobs
    inner join      tbtco           as runs     on  jobs.job_name  = runs.jobname
                                                and runs.authckman = $session.client
    left outer join apj_d_jobc_info as jobc     on  runs.jobname  = jobc.job_name
                                                and runs.jobcount = jobc.job_count
    left outer join tbtc_task       as task     on  jobs.job_name = task.jobname
                                                and runs.jobcount = task.jobcount
    left outer join tbtc_task_det   as task_det on task.taskid = task_det.taskid
    left outer join APJ_V_JCE_UNION as jce      on  jce.job_catalog_entry_name    = jobs.job_catalog_entry
                                                and jce.job_catalog_entry_version = '0'
{
  key jobs.job_name                        as job_name,
  key runs.jobcount                        as job_count,
      coalesce(jobc.status,runs.status)    as job_run_status,
      jobs.jce_type_c                      as jce_type_c,
      jobs.job_catalog_entry               as job_catalog_entry_name,
      runs.periodic                        as job_periodic_ind,
      runs.prdmins                         as job_periodic_minutes,
      runs.prdhours                        as job_periodic_hours,
      runs.prddays                         as job_periodic_days,
      runs.prdweeks                        as job_periodic_weeks,
      runs.prdmonths                       as job_periodic_months,
      task_det.wdaycdir                    as job_task_workday_cdir,
      jce.delete_exit_class_name           as delete_exit_class_name
}
where
     runs.status = 'A'
  or runs.status = 'F'
  or jobc.status = 'A'
  or jobc.status = 'F';