FINS_REV_REC_FLOWSOMD

@AbapCatalog.sqlViewName: 'FINSRR_FLOWSOMD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Flow of documents, Object Summary'
@ClientDependent: true

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

//List of

//- Number of (other) Business Transactions

//- Number of real time event based revenue recognition transactions

//- Number of target rev. event based revenue recognition transactions

//- Number of closing event based revenue recognition transactions

//- Number of excluded Business Transactions

//- Number partial real time event based revenue recognition transactions

//per ledger and account assignment object

//some master data are added

//Selects from Fins_Rev_Rec_Flowso


define view FINS_REV_REC_FLOWSOMD as 

select  
a.rldnr,
a.rbukrs,
a.accasty,
a.ps_pspid,
a.ps_posid,
a.ps_psp_pnr,
a.aufnr,
a.kdauf,
a.kdpos,
a.service_doc_id,
a.service_doc_item_id,    
a.service_contract_id,
a.service_contract_item_id,
a.vtkey,
a.vtpos,
a.solution_order_id,
a.min_budat,
a.max_budat,
cast( case when v.abgrs is not null then v.abgrs 
           when p.abgsl_bilel is not null then p.abgsl_bilel 
           when f.abgsl is not null then f.abgsl
           when s1.rev_rec_key is not null then s1.rev_rec_key
           when s.rev_rec_key is not null then s.rev_rec_key  
           when d.rev_rec_key is not null then d.rev_rec_key
           else ' ' end as abgr_schl ) as abgsl,
v.pstyv, 
a.no_of_ot,
a.no_of_ot_dp,
a.no_of_rr,
a.no_of_rrtr,
a.no_of_rrev, 
a.no_of_ex,
a.no_of_pa
from Fins_Rev_Rec_Flowso as a
left outer join vbap as v on v.vbeln = a.kdauf and v.posnr = a.kdpos and ( a.accasty = 'VB' or a.accasty = 'EO' )
left outer join FINSRR_RAKEY_WBS as p on p.pspnr = a.ps_psp_pnr and a.accasty = 'PR'
left outer join aufk as f on f.aufnr = a.aufnr and a.accasty = 'OR'
left outer join fco_srvdoc as s on s.service_doc_id = a.service_doc_id and s.service_doc_item_id = a.service_doc_item_id and a.accasty = 'SV'
left outer join fco_srvdoc as s1 on s1.service_doc_id = a.service_contract_id and s1.service_doc_item_id = a.service_contract_item_id and a.accasty = 'SC' 
left outer join dfkk_vt_i as d on d.vtkey = a.vtkey and d.vtpos = a.vtpos and ( a.accasty = 'PJ' or a.accasty = 'EO' )
; 


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINS_REV_REC_FLOWSO",
"AUFK",
"DFKK_VT_I",
"FCO_SRVDOC",
"VBAP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/