Fins_Rev_Rec_Acdoca_View

@AbapCatalog.sqlViewName: 'FINS_RR_ACDOCA'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
@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 Fins_Rev_Rec_Acdoca_View
  as

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

    a.usnam,
    racct as hkont,
    gkont,
    ktosl,
    slalittype,
    a.blart,
    bschl,
    bemot,
    beltp,
    drcrk,
    case when ( a.objnr <> '' and not ( accasty is null or accasty = '' ) or
              ( 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,
    trr_partial_ind,
    rbukrs as bukrs,
    pbukrs,
    rassc as vbund,
    rbusa as gsber,
    sbusa as pargb,
    prctr,
    pprctr,
    segment,
    psegment,
    rfarea as fkber,
    sfarea as pfkber,
    matnr,
    matnr_copa,
    hkgrp,
    werks,
    lifnr,
    kunnr,
    work_item_id,
    pernr,
    rsrce,
    overtimecat,
    uprctr,
    hrkft,
    wsl,
    rwcur,
    hsl,
    rhcur,
    ksl,
    kfsl,
    rkcur,
    osl,
    rocur,
    vsl,
    rvcur,
    bsl,
    rbcur,
    csl,
    rccur,
    dsl,
    rdcur,
    esl,
    recur,
    fsl,
    rfcur,
    gsl,
    rgcur,
    co_osl,
    rco_ocur,
    msl,
    runit,
    vmsl,
    rvunit,
    rmsl,
    rrunit,
    co_megbtr,
    co_meinh,
    sgtxt,
    timestamp,
    cast(1 as fins_trr_no_of_items) as no_of_items,
    cast('0' as fins_trr_aggregation_level) as aggregation_level
  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
                               and k.bukrs = a.rbukrs
                               and k.belnr = a.belnr
                               and k.gjahr = a.gjahr
  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' ) ) )     

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