P_GMAVCT_COMPAT

@AbapCatalog.sqlViewName: 'PGMAVCT_COMPAT'
//@ClientDependent: true

@ClientHandling.algorithm: #AUTOMATED //#SESSION_VARIABLE leads to short dump in SELECT...CLIENT SPECIFIED

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL //Inserted by VDM CDS Suite Plugin

@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
//@EndUserText.label: 'Compatibility View replacing old SELECT from GMAVCT'

define view P_GMAVCT_Compat as select from gmavct as tot
                                           left outer join gmavct_recon_yr as mig
                                           on tot.rclnt  = mig.client and
                                              tot.rbukrs = mig.company_code
  {
  key tot.rclnt,
  key tot.rldnr,
  key tot.rrcty,
  key tot.rvers,
  key tot.ryear,
  key tot.robjnr,
  key tot.cobjnr,
  key tot.sobjnr,
  key tot.rtcur,
  key tot.runit,
  key tot.drcrk,
  key tot.rpmax,
  key tot.rbukrs,
  key tot.rgrant_nbr,
  key tot.rfund,
  key tot.rsponsored_prog,
  key tot.rsponsored_class,
  key tot.rbdgt_vldty_nbr,
  key tot.ceffyear_9,
  key tot.wfstate_9,
  key tot.alloctype_9,
  key tot.logsys,
  key tot.grantee_fy_9,
  key tot.sbukrs,
  tot.tslvt,
  tot.tsl01,
  tot.tsl02,
  tot.tsl03,
  tot.tsl04,
  tot.tsl05,
  tot.tsl06,
  tot.tsl07,
  tot.tsl08,
  tot.tsl09,
  tot.tsl10,
  tot.tsl11,
  tot.tsl12,
  tot.tsl13,
  tot.tsl14,
  tot.tsl15,
  tot.tsl16,
  tot.hslvt,
  tot.hsl01,
  tot.hsl02,
  tot.hsl03,
  tot.hsl04,
  tot.hsl05,
  tot.hsl06,
  tot.hsl07,
  tot.hsl08,
  tot.hsl09,
  tot.hsl10,
  tot.hsl11,
  tot.hsl12,
  tot.hsl13,
  tot.hsl14,
  tot.hsl15,
  tot.hsl16,
  tot.kslvt,
  tot.ksl01,
  tot.ksl02,
  tot.ksl03,
  tot.ksl04,
  tot.ksl05,
  tot.ksl06,
  tot.ksl07,
  tot.ksl08,
  tot.ksl09,
  tot.ksl10,
  tot.ksl11,
  tot.ksl12,
  tot.ksl13,
  tot.ksl14,
  tot.ksl15,
  tot.ksl16,
  tot.mslvt,
  tot.msl01,
  tot.msl02,
  tot.msl03,
  tot.msl04,
  tot.msl05,
  tot.msl06,
  tot.msl07,
  tot.msl08,
  tot.msl09,
  tot.msl10,
  tot.msl11,
  tot.msl12,
  tot.msl13,
  tot.msl14,
  tot.msl15,
  tot.msl16,
  tot.cspred,
  tot.qspred
  } where ( mig.from_year is null ) or ( tot.grantee_fy_9 < mig.from_year )

union all select from P_GMAVCT as itm
                      inner join gmavct_recon_yr as mig
                      on itm.rclnt  = mig.client and
                         itm.rbukrs = mig.company_code and
                         itm.grantee_fy_9 >= mig.from_year
  {
  key itm.rclnt,
  key itm.rldnr,
  key itm.rrcty,
  key itm.rvers,
  key itm.ryear,
  key itm.robjnr,
  key itm.cobjnr,
  key itm.sobjnr,
  key itm.rtcur,
  key itm.runit,
  key itm.drcrk,
  key itm.rpmax,
  key itm.rbukrs,
  key itm.rgrant_nbr,
  key itm.rfund,
  key itm.rsponsored_prog,
  key itm.rsponsored_class,
  key itm.rbdgt_vldty_nbr,
  key itm.ceffyear_9,
  key itm.wfstate_9,
  key itm.alloctype_9,
  key itm.logsys,
  key itm.grantee_fy_9,
  key itm.sbukrs,
  itm.tslvt,
  itm.tsl01,
  itm.tsl02,
  itm.tsl03,
  itm.tsl04,
  itm.tsl05,
  itm.tsl06,
  itm.tsl07,
  itm.tsl08,
  itm.tsl09,
  itm.tsl10,
  itm.tsl11,
  itm.tsl12,
  itm.tsl13,
  itm.tsl14,
  itm.tsl15,
  itm.tsl16,
  itm.hslvt,
  itm.hsl01,
  itm.hsl02,
  itm.hsl03,
  itm.hsl04,
  itm.hsl05,
  itm.hsl06,
  itm.hsl07,
  itm.hsl08,
  itm.hsl09,
  itm.hsl10,
  itm.hsl11,
  itm.hsl12,
  itm.hsl13,
  itm.hsl14,
  itm.hsl15,
  itm.hsl16,
  itm.kslvt,
  itm.ksl01,
  itm.ksl02,
  itm.ksl03,
  itm.ksl04,
  itm.ksl05,
  itm.ksl06,
  itm.ksl07,
  itm.ksl08,
  itm.ksl09,
  itm.ksl10,
  itm.ksl11,
  itm.ksl12,
  itm.ksl13,
  itm.ksl14,
  itm.ksl15,
  itm.ksl16,
  itm.mslvt,
  itm.msl01,
  itm.msl02,
  itm.msl03,
  itm.msl04,
  itm.msl05,
  itm.msl06,
  itm.msl07,
  itm.msl08,
  itm.msl09,
  itm.msl10,
  itm.msl11,
  itm.msl12,
  itm.msl13,
  itm.msl14,
  itm.msl15,
  itm.msl16,
  itm.cspred,
  itm.qspred
  }

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_GMAVCT",
"GMAVCT",
"GMAVCT_RECON_YR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/