FINS_REV_REC_COSACT_VIEW4_BAS

@AbapCatalog.sqlViewName: 'FINS_RR_COSACT4B'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Actuals for data with CO objects'

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED

//Returns similar results like Fins_Rev_Rec_Cos_Actual_View, but values are restricted to WSL, HSL, KSL and MSL

//used in method read_actual_data_for_dip_only, class CL_FINS_TRR_READ_SERVICES

//uses the field names of COVP, if available

//Without PAOBJNR

//Selects from ACDOCA


define view FINS_REV_REC_COSACT_VIEW4_BAS
  as select
    a.rldnr   as rldnr,
    objnr,
    ps_posid  as pspnr, //covp-pspnr type ps_posid

    ps_pspid  as pspid,
    ps_psp_pnr,
//  paobjnr,

    aufnr,
    kdauf     as vbeln,
    kdpos     as vbposnr,
    ryear     as gjahr,
    poper     as perio,
    fiscyearper,
    budat,
    bldat,
    fbuda     as valdt,
    racct     as kstar,
    kokrs,
    rbukrs    as bukrs,
    werks,
    rbusa     as gsber,
    prctr,
    matnr, 
    uspob,
    plstar,
    ukostl    as pkostl,
    //ulstar 

    parob1,
    //parob1 as parob,

    work_item_id,
    pernr,
    uprctr,
    hrkft,
    bemot,
    rsrce,
    overtimecat,
    accasty,
    bttype,
    cast( case a.bttype when 'RFCV' then a.bttype else ( case a.vrgng when '' then a.vorgn when 'COIE' then a.vorgn when 'COIN' then a.vorgn else a.vrgng end ) end as fins_trr_bttype ) as bttype_tec,
    vrgng,
    beltp,
    xreversed,
    xreversing,
    rwcur     as twaer,
    rhcur     as owaer,
    rkcur     as kwaer,
    //rco_ocur,

    runit     as meinh,
    runit     as meinb,
    sum(wsl)  as wtgbtr,
    sum(hsl)  as wogbtr,
    sum(ksl)  as wkgbtr,
    sum(kfsl) as wkfbtr,
    //sum(co_osl) as co_osl ,

    sum(msl)  as mbgbtr,
    sum(mfsl) as mbfbtr
    //sum(msl) as megbtr,

    //sum(mfsl) as mefbtr

  from         acdoca       as a
    inner join finsc_ld_cmp as v on  a.rbukrs = v.bukrs
                                 and a.rldnr  = v.rldnr
    inner join t000         as b on a.rclnt = b.mandt
  where
    (
          a.objnr          <> '' 
      and a.glaccount_type <> 'X'
      and     not(
            accasty        is null
            or    accasty  =  ''
          )
      or(
              mig_source   =  'C'
        and   bstat        =  'C'
      )
      or(
              mig_source   =  ' '
        and   bstat        =  'C'
      )
    )
    and(
              a.logsyso    =  ''
      or      a.logsyso    =  b.logsys
    )
    and       vorgn        <> 'TBRR'
    and(
              a.mig_source <> ' '
      or(
              a.mig_source =  ' '
        and   not(
            a.bstat        =  'C'
            and a.poper    =  '000'
          )
      )
    )
  group by
    a.rldnr,
    objnr,
    ps_posid,
    ps_pspid,
    ps_psp_pnr,
//  paobjnr,

    aufnr,
    kdauf,
    kdpos,
    ryear,
    poper,
    fiscyearper,
    budat,
    bldat,
    fbuda,
    racct,
    kokrs,
    rbukrs,
    werks,
    rbusa,
    prctr,
    matnr,
    uspob,
    plstar,
    ukostl,
    //ulstar,

    parob1,
    work_item_id,
    pernr,
    uprctr,
    hrkft,
    bemot,
    rsrce,
    overtimecat,
    accasty,
    bttype,
    vorgn,
    vrgng,
    beltp,
    xreversed,
    xreversing,
    rwcur,
    rhcur,
    rkcur,
//  rco_ocur,

    runit; 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA",
"FINSC_LD_CMP",
"T000"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/