Atpc_Cds_Resb_D

@AbapCatalog.sqlViewName: 'ATPC_RESB_D'
@ObjectModel.usageType: {
    serviceQuality: #X,
    sizeCategory: #XXL,
    dataClass: #MIXED
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'CDS View on RESB for Reading of Own Deltas in ATP'
define view Atpc_Cds_Resb_D
  as select from resb

  // should not be used anymore


{
  //  key the single select

  cast (rsnum as delnr) as delnr,
  rspos                 as delps,
  case when bdart = 'AR' and xwaok = 'X' then 'WR'
       else bdart end   as atpcat, // rsart????????

  //  key for mass select

  matnr                 as matnr,
  werks                 as werks,
  lgort                 as lgort,
  charg                 as charg,
  sobkz                 as sobkz,
  kdauf                 as kdauf,
  kdpos                 as kdpos,
  pspel                 as pspel,
  lifnr                 as lifnr,
  //  ATP Data

  bdart                 as bdart,
  umwrk                 as umwrk,
  umlgo                 as umlgo,
  umsok                 as umsok,
  bdter                 as atpdate,
  shkzg                 as shkzg,
  bdmng                 as bdmng,
  enmng                 as enmng,
  vmeng                 as vmeng,
  //  for check against customizing / masterdata

  //    bdart  as bdart,

  xwaok                 as xwaok
}
where
       resb.xloek   = ''
  and  resb.kzear   = ''
  and

       resb.bdmng   > resb.enmng
  and  resb.dumps   = ''
  and  resb.no_disp = ''
  and

       resb.txtps   = ''
  and  resb.schgt   = ''
  and  resb.dbskz   = ''
  and(
       resb.vorab   is null
    or resb.vorab   = ''
  );