FCO_MIG_ACDOCA

@AbapCatalog.sqlViewName: 'FCOV_MIG_ACDOCA'
@EndUserText.label: 'CO Delta Entries - Aggregated ACDOCA Records'
@ObjectModel.usageType.serviceQuality: #P
define view FCO_MIG_ACDOCA as
select
       rclnt,
       acdoca.rldnr,
       objnr,
       gjahr,
       racct,
       hrkft,
       acdoca.vrgng,
       case when xcosp = 'X' then rassc else '      ' end as rassc,
       drcrk,
       co_belkz,
       rtcur,
       rwcur,
       rkcur,
       case when versn.rocur = 1 then acdoca.rocur else '' end as rocur,
       case when versn.rvcur = 1 then acdoca.rvcur else '' end as rvcur,
       case when versn.rbcur = 1 then acdoca.rbcur else '' end as rbcur,
       case when versn.rccur = 1 then acdoca.rccur else '' end as rccur,
       case when versn.rdcur = 1 then acdoca.rdcur else '' end as rdcur,
       case when versn.recur = 1 then acdoca.recur else '' end as recur,
       case when versn.rfcur = 1 then acdoca.rfcur else '' end as rfcur,
       case when versn.rgcur = 1 then acdoca.rgcur else '' end as rgcur,
       rvunit,
       beltp,
       rbukrs,
       rfarea,
       segment,
       case when xcosp = 'X' then sbusa else '    ' end as sbusa,
       co_beknz as beknz,
       rfund,
       rgrant_nbr,
       rbudget_pd,
       poper,
       parobsrc,
       parob1,
       case when xcoss = '' then '                      '
            when parobsrc = '1' then parob1
            else case when parobsrc = '2' then paccasty
                      else ''
                 end
       end as parob,
       case when xcoss = 'X' then uspob else '                      ' end as uspob,
       acdoca.kokrs,
       acdoca.periv,
       accasty,
       paccasty,
       sum(acdoca.tsl) as tsl,
       sum(acdoca.wsl) as wsl,
       sum(case when versn.wsl2  = 1 then acdoca.wsl2  else 0 end) as wsl2,
       sum(case when versn.wsl3  = 1 then acdoca.wsl3  else 0 end) as wsl3,
       sum(case when versn.hsl   = 1 then acdoca.hsl   else 0 end) as hsl,
       sum(case when versn.ksl   = 1 then acdoca.ksl   else 0 end) as ksl,
       sum(case when versn.osl   = 1 then acdoca.osl   else 0 end) as osl,
       sum(case when versn.vsl   = 1 then acdoca.vsl   else 0 end) as vsl,
       sum(case when versn.bsl   = 1 then acdoca.bsl   else 0 end) as bsl,
       sum(case when versn.csl   = 1 then acdoca.csl   else 0 end) as csl,
       sum(case when versn.dsl   = 1 then acdoca.dsl   else 0 end) as dsl,
       sum(case when versn.esl   = 1 then acdoca.esl   else 0 end) as esl,
       sum(case when versn.fsl   = 1 then acdoca.fsl   else 0 end) as fsl,
       sum(case when versn.gsl   = 1 then acdoca.gsl   else 0 end) as gsl,
       sum(case when versn.kfsl  = 1 then acdoca.kfsl  else 0 end) as kfsl,
       sum(case when versn.kfsl2 = 1 then acdoca.kfsl2 else 0 end) as kfsl2,
       sum(case when versn.kfsl3 = 1 then acdoca.kfsl3 else 0 end) as kfsl3,
       sum(case when versn.psl   = 1 then acdoca.psl   else 0 end) as psl,
       sum(case when versn.psl2  = 1 then acdoca.psl2  else 0 end) as psl2,
       sum(case when versn.psl3  = 1 then acdoca.psl3  else 0 end) as psl3,
       sum(case when versn.pfsl  = 1 then acdoca.pfsl  else 0 end) as pfsl,
       sum(case when versn.pfsl2 = 1 then acdoca.pfsl2 else 0 end) as pfsl2,
       sum(case when versn.pfsl3 = 1 then acdoca.pfsl3 else 0 end) as pfsl3,
       sum(acdoca.co_osl) as co_osl,
       sum(acdoca.vmsl) as vmsl,
       sum(acdoca.vmfsl) as vmfsl,
       max(acdoca.muvflg) as muvflg,
       cast(0 as abap.dec( 16, 0 ) ) as timestmp,
       bstat,
       mig_source,
       xcoss,
       xcosp
    from acdoca
    inner join tj01 on acdoca.vrgng = tj01.vrgng
    inner join FCO_MIG_VERSNE as versn on acdoca.rclnt = versn.mandt and
               acdoca.rldnr = versn.rldnr and acdoca.rbukrs = versn.bukrs
    inner join t000 on t000.mandt = acdoca.rclnt
    inner join tka01 on tka01.mandt = acdoca.rclnt and tka01.kokrs = acdoca.kokrs
    where ( tj01.xcosp = 'X' or tj01.xcoss = 'X' ) and
          objnr <> '' and ( accasty <> '' or ( accasty = '' and bstat = 'C' ) )
      // ALE logic: see include LKAUPF01, starting with line 39

      and ( logsyso = ''
         or logsyso = t000.logsys
         or ( ( accasty = 'KS' or accasty = 'KL' ) and ( tka01.logsystem = t000.logsys or
                                                         tka01.logsystem = '' ) ) )
    group by
       rclnt,
       acdoca.rldnr,
       objnr,
       gjahr,
       racct,
       hrkft,
       acdoca.vrgng,
       rassc,
       drcrk,
       co_belkz,
       rtcur,
       rwcur,
       rkcur,
       acdoca.rocur,
       acdoca.rvcur,
       acdoca.rbcur,
       acdoca.rccur,
       acdoca.rdcur,
       acdoca.recur,
       acdoca.rfcur,
       acdoca.rgcur,
       versn.rocur,
       versn.rvcur,
       versn.rbcur,
       versn.rccur,
       versn.rdcur,
       versn.recur,
       versn.rfcur,
       versn.rgcur,
       rvunit,
       beltp,
       rbukrs,
       rfarea,
       segment,
       sbusa,
       co_beknz,
       rfund,
       rgrant_nbr,
       rbudget_pd,
       poper,
       parobsrc,
       parob1,
       uspob,
       acdoca.kokrs,
       acdoca.periv,
       accasty,
       paccasty,
       bstat,
       mig_source,
       xcosp,
       xcoss
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCO_MIG_VERSNE",
"ACDOCA",
"T000",
"TJ01",
"TKA01"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/