Fins_Rev_Rec_Acdoca_View

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'View on ACDOCA'

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

//Returns amounts line item by line item

//Used for support monitor

//Selects from ACDOCA


define view entity Fins_Rev_Rec_Acdoca_View
  as

  select
  from              acdoca as a
   // inner join finsc_ld_cmp as v on  a.rclnt = v.mandt and a.rbukrs = v.bukrs and a.rldnr  = v.rldnr 

   // inner join      t000   as b on a.rclnt = b.mandt

    left outer join bkpf   as k on //k.mandt = a.rclnt

                                k.bukrs = a.rbukrs
                               and k.belnr = a.belnr
                               and k.gjahr = a.gjahr
{
a.rldnr as rldnr,
    a.belnr,
    a.docln,
    a.vorgn,
    a.vrgng,
    a.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,
    a.awtyp,
    a.awsys,
    a.aworg,
    a.awref,
    a.awitem,
    a.awitgrp,
    a.subta,
    a.co_belnr,
    a.co_buzei,
    a.awtyp_rev,
    a.aworg_rev,
    a.awref_rev,
    a.xreversing,
    a.xreversed,
    a.xtruerev,
    a.objnr,
    a.ps_pspid,
    a.ps_prj_pnr,
    a.ps_posid,
    a.ps_psp_pnr,
    a.paobjnr,
    a.aufnr,
    a.nplnr,
    a.nplnr_vorgn,
    a.kdauf,
    a.kdpos,
    a.service_doc_type,
    a.service_doc_id,
    a.service_doc_item_id,
    a.service_contract_type,
    a.service_contract_id,
    a.service_contract_item_id,
    a.solution_order_id,
    a.solution_order_item_id,
    a.vtkey,
    a.vtpos,
    a.ra_contract_id,
    a.ra_pob_id,
    a.accasty,
    a.accas,
    a.scope,
    a.ukostl,
    a.ulstar,
    a.uprznr,
    a.gjahr as docyear,
    a.periv,
    a.ryear as gjahr,
    a.poper,
    a.fiscyearper,
    a.budat,
    a.bldat,
    a.wwert,  
    a.fbuda,
    a.bzdat,  // budat for item details    

    a.usnam,
    a.racct as hkont,
    a.gkont,
    a.ktosl,
    a.slalittype,
    a.blart,
    a.bschl,
    a.bemot,
    a.beltp,
    a.drcrk,
    case when ( a.objnr <> '' and not ( a.accasty is null or a.accasty = '' ) or
              ( a.mig_source = 'C' and a.bstat = 'C' ) ) //and ( a.logsyso = '' or a.logsyso = b.logsys ) 

         then cast('X' as kka_yes_no) else cast(' ' as kka_yes_no) end as coind,
    k.trr_partial_ind,
    a.rbukrs as bukrs,
    a.pbukrs,
    a.rassc as vbund,
    a.rbusa as gsber,
    a.sbusa as pargb,
    a.prctr,
    a.pprctr,
    a.segment,
    a.psegment,
    a.rfarea as fkber,
    a.sfarea as pfkber,
    a.matnr,
    a.matnr_copa,
    a.hkgrp,
    a.werks,
    a.lifnr,
    a.kunnr,
    a.work_item_id,
    a.pernr,
    a.rsrce,
    a.overtimecat,
    a.uprctr,
    a.hrkft,
    @Semantics.amount.currencyCode: 'rwcur'
    a.wsl,
    a.rwcur,
    @Semantics.amount.currencyCode: 'rhcur'
    a.hsl,
    a.rhcur,
    @Semantics.amount.currencyCode: 'rkcur'
    a.ksl,
    @Semantics.amount.currencyCode: 'rkcur'
    a.kfsl,
    a.rkcur,
    @Semantics.amount.currencyCode: 'rocur'
    a.osl,
    a.rocur,
    @Semantics.amount.currencyCode: 'rvcur'
    a.vsl,
    a.rvcur,
    @Semantics.amount.currencyCode: 'rbcur'
    a.bsl,
    a.rbcur,
    @Semantics.amount.currencyCode: 'rccur'
    a.csl,
    a.rccur,
    @Semantics.amount.currencyCode: 'rdcur'
    a.dsl,
    a.rdcur,
    @Semantics.amount.currencyCode: 'recur'
    a.esl,
    a.recur,
    @Semantics.amount.currencyCode: 'rfcur'
    a.fsl,
    a.rfcur,
    @Semantics.amount.currencyCode: 'rgcur'
    a.gsl,
    a.rgcur,
    @Semantics.amount.currencyCode: 'rco_ocur'
    a.co_osl,
    a.rco_ocur,
    @Semantics.quantity.unitOfMeasure: 'runit'
    a.msl,
    a.runit,
    @Semantics.quantity.unitOfMeasure: 'rvunit'
    a.vmsl,
    a.rvunit,
    @Semantics.quantity.unitOfMeasure: 'rrunit'
    a.rmsl,
    a.rrunit,
    @Semantics.quantity.unitOfMeasure: 'co_meinh'
    a.co_megbtr,
    a.co_meinh,
    a.sgtxt,
    a.timestamp,
    cast(1 as fins_trr_no_of_items) as no_of_items,
    cast('0' as fins_trr_aggregation_level) as aggregation_level
}
  where
    ( a.mig_source <> ' ' or ( a.mig_source =  ' ' and not ( a.bstat =  'C' and a.poper = '000' ) ) );
    // and ( a.mig_source = 'C' or ( a.mig_source = ' ' and not ( a.bstat = 'C' and a.poper = '000' ) ) )