Performance Issue with BSIS(open accounting items)
I am having serious performance issue with a accrual report which gets all open GL items, and need some tips for optimization.
The main issue is that I am accesing large tables like BSIS, BSEG, BSAS etc without proper indexes and that I am dealing with huge amounts of data.
The select itself take a long time and after that as I have so much data overall execution is slow too.
The select which concerns me the most is:
SELECT zuonr hkont gjahr belnr buzei budat blart wrbtr shkzg xblnr waers bukrs INTO TABLE i_bsis FROM bsis WHERE bukrs = '1000' AND hkont in r_hkont AND budat <= p_lcdate AND augdt = 0 AND augbl = space AND gsber = c_ZRL1 AND gjahr BETWEEN l_gjahr2 AND l_gjahr AND ( blart = c_re "Invoice OR blart = c_we "Goods receipt OR blart = c_zc "Invoice Cancels OR blart = c_kp ). "Accounting offset
I have seen other related threads, but was not that helpful.
We already have a secondary index on bukrs hkont and budat, and i have checked in ST05 that it does use it. But inspite that it takes more than 15 hrs to complete(maybe because of huge data).
Any Input is highly appreciated.