Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How I can improve the Performance of CDS view in FI related tables.

SVT
Explorer
0 Kudos

Hi Guys,

I have a requirement ,Need to join the below tables and get a single view using CDS.

1.acdoca

2.bset

3.j_1bbranch

4.lfa1

5.kna1

6.abusinesspartner

7.dfkkbptaxnum

8.makt

9.t8g02t

10.finsts_slalittyt

11.tabwt

12.finsc_bttype_t

13.edoineinv

14.skat

define view ZFI_CDS_GL as select from  acdoca as ac       
left outer join bseg 
    on ac.belnr = bseg.belnr 
    and ac.buzei = bseg.buzei 
    and ac.rbukrs = bseg.bukrs 
    and ac.gjahr = bseg.gjahr    
left outer join bset as bt
     on ac.belnr = bt.belnr 
     and ac.buzei = bt.buzei 
     and ac.rbukrs = bt.bukrs 
     and ac.gjahr = bt.gjahr 
     and bseg.taxps = bt.taxps      
left outer join bkpf as bkpf
     on ac.belnr = bkpf.belnr 
     and ac.rbukrs = bkpf.bukrs 
     and ac.gjahr = bkpf.gjahr    
left outer join j_1bbranch
     on ac.rbukrs = j_1bbranch.bukrs   
     and j_1bbranch.branch = bseg.bupla
left outer join lfa1 
     on ac.lifnr = lfa1.lifnr
left outer join kna1
     on ac.kunnr = kna1.kunnr
left outer join abusinesspartner
     on ac.lifnr = abusinesspartner.supplier 
     and ac.kunnr = abusinesspartner.customer
left outer join dfkkbptaxnum    
     on  dfkkbptaxnum.partner = abusinesspartner.supplier   
     or  dfkkbptaxnum.partner = abusinesspartner.customer 
left outer join makt
     on ac.matnr = makt.matnr  
     and makt.spras = 'E'
left outer join t8g02t
     on  ac.linetype = t8g02t.linetype    
     and  t8g02t.langu = 'E' 
left outer join finsts_slalittyt
     on ac.slalittype = finsts_slalittyt.slalittype
     and finsts_slalittyt.langu = 'E'
left outer join  tabwt     
     on ac.anbwa =   tabwt.bwasl 
     and tabwt.spras = 'E'
left outer join finsc_bttype_t
     on  ac.bttype = finsc_bttype_t.txt
     and finsc_bttype_t.langu = 'E'
left outer join finsc_custbttypt
     on ac.cbttype = finsc_custbttypt.cbttype
     and finsc_custbttypt.langu = 'E'
left outer join skat
     on skat.saknr = ac.racct
     and skat.spras = 'E'
     and skat.ktopl = 'COMPANYNAME'
left outer join  edoineinv  as e
     on  bkpf.xblnr =  e.inv_num 
     and bseg.bupla = e.bupla 
{
View fields
}
where ac.rldnr = '0L'
and ac.bstat != 'C'

The performance is very poor. Can any one some points or idea to improve this or new way to handle this requirement.

0 REPLIES 0