tables order to improve performance

[Former Member]

hi all,

I am working on a report to calculate G/L balances. I am following teh logic,

1. fetch G/L accounts from SKB1 based on comp code.

2. get relevent data from BSIS , for all entries in SKB1

3. get amount from GLT0 for all entries in SKB1

4. move relevant data to final internal table and download.

This takes a long time to fetch data and throws dump, comment on the above logic being used.

I appropriate ur comments.

[Former Member]

Hi,

my sugestion is you don't read entries from table GLT0. you get amount in BSIS/BSEG. better use BSIS. if you use BSEG, you must use index in your prg.

[ThomasZloch]

Balances are in GLT0, why do you need BSIS additionally?

Also, without seeing the exact code we cannot analyse where the problem is.

You can analyse yourself by starting a SE30 runtime analysis and sort the hit list top down by net processing time. This will show the problematic bits of your code, that you can paste here if you can't work it out yourself.

Thomas

[Sathish]

GLT0 by itself is ennough to fetch the G/L account balances.

If there is a requirement to use SKB1 then accounts can be checked with SKA1 table and field KTOPL.

This would not have bad performance. Otherwise reading records from BSIS has a big impact on performance, then secondary indexes need to be created for BSIS to improve the performance.

Edited by: Sathish K on Oct 16, 2008 4:03 PM