01-10-2024 4:52 AM
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.