Fins_Rev_Rec_uprctr_View

@AbapCatalog.sqlViewName: 'FINS_RR_UPRCTR'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'pernr - origin prctr'

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

//ACDOCA based list of

//- document number and item

//- account assignment object

//- personal number

//- resource

//- origin cost center

//- origin profit center

//- business transaction type

//- GL account

//Used in class cl_fins_trr_pernr_util

//Selects from ACDOCA all items which are no revenue recognition items


define view Fins_Rev_Rec_uprctr_View
  as select
    a.rldnr as rldnr,
    belnr,
    docln,
    rbukrs as bukrs, 
    gjahr as docyear,
    
    accasty,
    objnr,
    ps_posid,
    ps_psp_pnr,
    paobjnr,
    aufnr,
    kdauf,
    kdpos,
    
    ryear as gjahr,
    poper,
    fiscyearper,
    budat,
    racct as hkont,
    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,
    
    ukostl,
    pernr,
    rsrce,
    uprctr
  from         acdoca       as a
    inner join finsc_ld_cmp as v on  a.rbukrs = v.bukrs
                                 and a.rldnr  = v.rldnr --- Ledger space is obsolete     or a.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'
          )
      )
    )
 
 ;

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