fco_ovhd_cost_acdoca

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Overhead costs from acdoca'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity fco_ovhd_cost_acdoca
  as select from acdoca as a
    inner join   tka01  as t  on t.kokrs = a.kokrs

    inner join   t000   as s  on s.mandt           = $session.client
                              and(
                                s.logsys           = a.logsyso
                                or a.logsyso       = ''
                                or(
                                  (
                                    a.accasty      = 'KS'
                                    or a.accasty   = 'KL'
                                  )
                                  and(
                                    s.logsys       = t.logsystem
                                    or t.logsystem = ''
                                  )
                                )
                              )

    inner join   tj01   as bt on bt.vrgng   = a.vrgng
                              and(
                                bt.xcosp    = 'X'
                                or bt.xcoss = 'X'
                              )
{
  key       a.rldnr,
  key       a.ryear,
  key       a.rbukrs,
  key       a.objnr,
  key       a.vrgng,
  key       a.co_beknz,
  key       a.racct,
  key       a.hrkft,
  key       case when bt.xcosp = 'X' then a.rassc else '' end  as rassc,
  key       case when bt.xcosp = 'X' then a.sbusa else '' end  as sbusa,
  key       a.rwcur,
  key       a.co_meinh,
  key       a.beltp,
  key       case when bt.xcoss = 'X' then a.parob1 else '' end as parob1,
            //                case when a.parobsrc = '1' then a.parob1     else case

            //                     when a.parobsrc = '2' then a.paccasty

            //                     else ''                             end end    else '' end as parob1, // COSS only


  key       case when bt.xcoss = 'X' then a.uspob else '' end  as uspob,
  key       a.poper,
            // TODO: maybe add parameter with_timestamp. now timestamp 0

            0                                                  as timestmp,
            //           a.parob1,

            a.paccasty,
            a.rassc                                            as credit_vbund,
            a.sbusa                                            as credit_pargb,
            a.rhcur,
            // reference fields block

            //            a.co_belnr,

            //            a.aworg,

            //            a.awtyp,

            //            a.awsys,

            //            a.awref,

            //            a.budat,

            //            a.bldat,

            @Semantics.amount.currencyCode: 'rwcur'
            a.wsl,
            @Semantics.amount.currencyCode: 'rhcur'
            a.hsl,
            a.rkcur,
            @Semantics.amount.currencyCode: 'rkcur'
            a.ksl,
            @Semantics.amount.currencyCode: 'rkcur'
            a.kfsl,
            @Semantics.amount.currencyCode: 'rkcur'
            a.psl,
            @Semantics.amount.currencyCode: 'rkcur'
            a.pfsl,
            @Semantics.quantity.unitOfMeasure: 'co_meinh'
            a.co_megbtr,
            @Semantics.quantity.unitOfMeasure: 'co_meinh'
            a.co_mefbtr,

            // Additional currencies:

            @Semantics.amount.currencyCode: 'rocur'
            a.osl,
            @Semantics.amount.currencyCode: 'rvcur'
            a.vsl,
            @Semantics.amount.currencyCode: 'rbcur'
            a.bsl,
            @Semantics.amount.currencyCode: 'rccur'
            a.csl,
            @Semantics.amount.currencyCode: 'rdcur'
            a.dsl,
            @Semantics.amount.currencyCode: 'recur'
            a.esl,
            @Semantics.amount.currencyCode: 'rfcur'
            a.fsl,
            @Semantics.amount.currencyCode: 'rgcur'
            a.gsl,
            @Semantics.amount.currencyCode: 'rco_ocur'
            a.co_osl,
            
            a.rocur,
            a.rvcur,
            a.rbcur,
            a.rccur,
            a.rdcur,
            a.recur,
            a.rfcur,
            a.rgcur,
            a.rco_ocur,
            a.co_buzei, //? do we need it?


            a.werks,
            a.matnr,
            a.hkgrp,
            a.recid,
            a.bemot,
            a.pernr,
            a.rsrce,
            a.prodper,

            a.rfarea,
            a.segment,
            a.rfund,
            a.rgrant_nbr,
            a.rbudget_pd,
            a.sfarea,
            a.psegment,
            a.sfund,
            a.sgrant_nbr,
            a.sbudget_pd,
            --new grouping fields
            a.vornr,
            a.arbid
            //            a.aufnr_org,

            //            a.vornr_org



}
where
  (
    (
          a.co_buzei    <>              '000'
      and not a.accasty =               ''
    )
    or(
          a.mig_source  =               'C'
      and a.bstat       =               'C'
    )
    or(
                        not             a.accasty = ''
    )

  )
  and     a.objnr       <>              ''
  and     a.accasty     <>              ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA",
"T000",
"TJ01",
"TKA01"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/