tables order to improve performance
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.