ARUN_PROD_REQMT

@AbapCatalog.sqlViewName: 'V_ARUN_PRD_REQMT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Production order components'
define view ARUN_PROD_REQMT
  as select from    aufk            as au
    inner join      resb            as re on(
      au.mandt     = re.mandt
      and au.aufnr = re.aufnr
    )
    left outer join Arun_Com_Ralloc as ar on(
      re.rsnum     = ar.reserv_num
      and re.rspos = ar.reserv_item
      and re.bdart = 'AR'
    )
    left outer join marc            as mr on(
      mr.matnr     = re.matnr
      and mr.werks = re.werks
    )
{
  re.mandt,
  re.rsnum,
  re.rspos,
  re.aufnr,
  re.matnr,
  re.werks,
  re.bdter as requested_date,
  re.bdter as material_avail_date,
  re.meins,
  re.enmng,
  re.webaz,
  re.sgt_scat,
  re.sgt_rcat,
  case when ar.alloc_qty > 0 then ar.alloc_qty else 0 end as alloc_qty,
  re.charg,
  case when re.bdmng > 0 then
                         re.bdmng - re.enmng - COALESCE(alloc_qty,0) else 0 end as bdmng
}
where
  (
    re.xloek != 'X'
  ) -- deleted item should not be selected
  and(
    re.kzear != 'X'
  ) -- final issue for this reservation
  and(
    mr.fsh_mg_arun_req = '1'
  ) -- arun relevant