Fins_Rev_Rec_uprctr_View

@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 entity Fins_Rev_Rec_uprctr_View
  as select
  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 = '' )
{
    a.rldnr as rldnr,
    a.belnr,
    a.docln,
    a.rbukrs as bukrs, 
    a.gjahr as docyear,
    
    a.accasty,
    a.objnr,
    a.ps_posid,
    a.ps_psp_pnr,
    a.paobjnr,
    a.aufnr,
    a.kdauf,
    a.kdpos,
    
    a.ryear as gjahr,
    a.poper,
    a.fiscyearper,
    a.budat,
    a.racct as hkont,
    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.ukostl,
    a.pernr,
    a.rsrce,
    a.uprctr
} 
  where
    (
          a.objnr          <> '' 
      and a.glaccount_type <> 'X'
      and     not(
            a.accasty        is null
            or    a.accasty  =  ''
          )
      or(
              a.mig_source   =  'C'
        and   a.bstat        =  'C'
      )
      or(
              a.mig_source   =  ' '
        and   a.bstat        =  'C'
      )
    )
    and       a.vorgn        <> 'TBRR'
    and(
              a.mig_source <> ' '
      or(
              a.mig_source =  ' '
        and   not(
            a.bstat        =  'C'
            and a.poper    =  '000'
          )
      )
    )
 
 ;