FAA_DOC_IT_BCF

@AbapCatalog.sqlViewName: 'FAAV_DOC_IT_BCF'
@EndUserText.label: 'Carry forward for statistical items'

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P

define view  FAA_DOC_IT_BCF

as select from  faat_doc_it
     inner join finsts_faa_bcf
             on finsts_faa_bcf.slalittype_srce = faat_doc_it.slalittype           
     inner join anla
             on anla.bukrs = faat_doc_it.bukrs
            and anla.anln1 = faat_doc_it.anln1
            and anla.anln2 = faat_doc_it.anln2
{ faat_doc_it.bukrs,
  faat_doc_it.anln1,
  faat_doc_it.anln2,
  faat_doc_it.anlgr,
  faat_doc_it.anlgr2,
  faat_doc_it.afabe,
  faat_doc_it.gjahr,
  faat_doc_it.ldgrp,
  faat_doc_it.hsl,
  faat_doc_it.ksl,
  faat_doc_it.osl,
  faat_doc_it.vsl,
  faat_doc_it.rhcur,
  faat_doc_it.rkcur,
  faat_doc_it.rocur,
  faat_doc_it.rvcur,

 'AMBU' as awtyp,
 '999'  as bwasl,
 '00'   as movcat, 
 '000'  as poper,

case 
  when ( slalittype between '07200' and '07209' )
    then slalittype
    else finsts_faa_bcf.slalittype_trgt
  end as SLALITTYPE,
  
  finsts_faa_bcf.slalittype_srce as SLALITTYPE_srce,
  anla.deakt
   }

union all 
    select from faat_plan_values 
     inner join anla
             on anla.bukrs = faat_plan_values.bukrs
            and anla.anln1 = faat_plan_values.anln1
            and anla.anln2 = faat_plan_values.anln2     

{ faat_plan_values.bukrs,
  faat_plan_values.anln1,
  faat_plan_values.anln2,
  faat_plan_values.anlgr,
  faat_plan_values.anlgr2,
  faat_plan_values.afabe,
  faat_plan_values.gjahr,
  faat_plan_values.ldgrp,
  faat_plan_values.hsl,
  faat_plan_values.ksl,
  faat_plan_values.osl,
  faat_plan_values.vsl,
  faat_plan_values.rhcur,
  faat_plan_values.rkcur,
  faat_plan_values.rocur,
  faat_plan_values.rvcur,

 'AMBU' as awtyp,
 '999'  as bwasl,
 '00'   as movcat, 
 '000'  as poper,
 
  faat_plan_values.slalittype as SLALITTYPE,
  faat_plan_values.slalittype as SLALITTYPE_srce,
  anla.deakt  
  }