Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance Issue with BSIS(open accounting items)

Hey All,

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.

Thanks

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question