GL total balance

[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.

[satsrockford · Accepted solution]

hi

use the GL index tables BSIS and BSAS. Secondly, all of the amounts in these tables are positive. You have to take into account the debit credit indicator SHKZG. If all you are interested in is the GL balances, you can use table GLT0 (GL totals).

regards

Satish

[Former Member]

Hi ,

thanks for ur quick response, My question is , is it necessary to take SKB1 table into account ? or just fetch all G/L's from BSIS ,