P_FMAVCT_COMPAT

@AbapCatalog.sqlViewName: 'PFMAVCT_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
@AbapCatalog.preserveKey: true
@VDM.private:true
//@EndUserText.label: 'Compatibility View replacing old SELECT from FMAVCT'

define view P_FMAVCT_Compat as select from fmavct as tot 
                                           left outer join fmavct_recon_yr as mig 
                                           on tot.rclnt  = mig.client and
                                              tot.rfikrs = mig.fm_area 
  {                                                               
  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.drcrk,
  key tot.rpmax,
  key tot.rfikrs,
  key tot.rfund,
  key tot.rfundsctr,
  key tot.rcmmtitem,
  key tot.rfuncarea,
  key tot.ruserdim,
  key tot.rgrant_nbr,
  key tot.rmeasure,
  key tot.rcvrgrp_9,
  key tot.budget_pd_9,
  key tot.ceffyear_9,
  key tot.wfstate_9,
  key tot.alloctype_9,
  key tot.logsys,
  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.cspred    
  } where ( mig.from_year is null ) or ( tot.ryear < mig.from_year )

union all select from P_FMAVCT as itm 
                      inner join fmavct_recon_yr as mig
                      on itm.rclnt  = mig.client and
                         itm.rfikrs = mig.fm_area and
                         itm.ryear >= 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.drcrk,
  key itm.rpmax,
  key itm.rfikrs,
  key itm.rfund,
  key itm.rfundsctr,
  key itm.rcmmtitem,
  key itm.rfuncarea,
  key itm.ruserdim,
  key itm.rgrant_nbr,
  key itm.rmeasure,
  key itm.rcvrgrp_9,
  key itm.budget_pd_9,
  key itm.ceffyear_9,
  key itm.wfstate_9,
  key itm.alloctype_9,
  key itm.logsys,
  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.cspred                     
  }      
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_FMAVCT",
"FMAVCT",
"FMAVCT_RECON_YR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/