Faa_Plan_Values

@AbapCatalog.sqlViewName: 'FAAV_PLAN_VALUES'
@EndUserText.label: 'Geplante und Gebuchte Werte pro Anlage und Werttyp'

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

-- New with Note 2217483
define view Faa_Plan_Values
  as

  select from faat_plan_values
{
  key mandt      as mandt,
  key bukrs      as bukrs,
  key anln1      as anln1,
  key anln2      as anln2,
  key gjahr      as gjahr,
  key afabe      as afaber,
  key poper      as poper,
  key slalittype as SLALITTYPE,
  key movcat     as movcat,
  key poper      as depr_period, -- SIL new Ledger
  key ' '        as posted,
      ldgrp      as ldgrp,
      anlgr      as anlgr,
      anlgr2     as anlgr2,
      hsl        as HSL,
      ksl        as ksl,
      osl        as osl,
      vsl        as vsl,
      bsl        as bsl,
      csl        as csl,
      dsl        as dsl,
      esl        as esl,
      fsl        as fsl,
      gsl        as gsl,
      rhcur      as RHCUR,
      rkcur      as rkcur,
      rocur      as rocur,
      rvcur      as rvcur,
      rbcur      as rbcur,
      rccur      as rccur,
      rdcur      as rdcur,
      recur      as recur,
      rfcur      as rfcur,
      rgcur      as rgcur,
      recid      as RECID,
      xpost      as xpost,
      mig_source as MIG_SOURCE
}

union all select from acdoca         as acdoca
  inner join          Faa_Rep_Ledger as rldnr on  rldnr.bukrs      = acdoca.rbukrs
                                              and rldnr.rep_ledger = acdoca.rldnr
                                              and rldnr.lead_afabe = acdoca.afabe
{
  key acdoca.rclnt       as mandt,
  key acdoca.rbukrs      as bukrs,
  key acdoca.anln1       as anln1,
  key acdoca.anln2       as anln2,
  key acdoca.ryear       as gjahr,
  key acdoca.afabe       as afaber,
  key acdoca.poper       as poper,
  key acdoca.slalittype  as SLALITTYPE,
  key acdoca.movcat      as movcat,
  key acdoca.depr_period as depr_period, -- SIL new Ledger
  key case
        when acdoca.awtyp = 'AS91' then 'A'
        else 'X'
      end                as posted,
      rldnr.ldgrp        as ldgrp,
      acdoca.anlgr       as anlgr,
      acdoca.anlgr2      as anlgr2,
      sum( acdoca.hsl )  as HSL,
      sum( acdoca.ksl )  as ksl,
      sum( acdoca.osl )  as osl,
      sum( acdoca.vsl )  as vsl,
      sum( acdoca.bsl )  as bsl,
      sum( acdoca.csl )  as csl,
      sum( acdoca.dsl )  as dsl,
      sum( acdoca.esl )  as esl,
      sum( acdoca.fsl )  as fsl,
      sum( acdoca.gsl )  as gsl,
      acdoca.rhcur       as RHCUR,
      acdoca.rkcur       as rkcur,
      acdoca.rocur       as rocur,
      acdoca.rvcur       as rvcur,
      acdoca.rbcur       as rbcur,
      acdoca.rccur       as rccur,
      acdoca.rdcur       as rdcur,
      acdoca.recur       as recur,
      acdoca.rfcur       as rfcur,
      acdoca.rgcur       as rgcur,
      acdoca.recid       as RECID,
      'X'                as xpost,
      acdoca.mig_source  as MIG_SOURCE
}
where
  (
       acdoca.awtyp      =       'AMDP'
    or acdoca.awtyp      =       'AS91'
  )
  and  acdoca.slalittype between '07200' and '07299'
  group by acdoca.rclnt, acdoca.rbukrs, acdoca.anln1, acdoca.anln2, acdoca.ryear, acdoca.afabe, acdoca.poper, acdoca.slalittype, 
           acdoca.awtyp, rldnr.ldgrp, acdoca.anlgr, acdoca.anlgr2, acdoca.movcat, acdoca.depr_period,  acdoca.recid,  acdoca.mig_source,
           acdoca.rhcur, acdoca.rkcur, acdoca.rocur, acdoca.rvcur, acdoca.rbcur, acdoca.rccur, acdoca.rdcur, acdoca.recur, acdoca.rfcur, acdoca.rgcur
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAA_REP_LEDGER",
"ACDOCA",
"FAAT_PLAN_VALUES"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/