Skip to Content
0
May 14, 2018 at 10:22 PM

Reading large tables; trying to get GL acct usage dates

71 Views

I'm trying to build a rule in Info Steward to evaluate GL accounts for inactivity (date last used).

To do this, I've tried to build a list of accounts and date of the most recent transaction for each one. A "group by" with max() would work, for example.

The apparent obvious answer is to read table BSEG, but it has millions and millions of records. I can't read it directly with Data Services or Info Steward, without timing out.

I tried looking at some tables behind it like BSIS an BSAS, but they're pretty much just as big.

I looked at FAGLFLEXT also, thinking perhaps I could just look at non-zero values. But some accounts net to zero each period, so they have activity even if the balance is zero, so that doesn't help me.

Anyone have any other ideas on how to find GL account activity efficiently from DS or IS? Or more general techniques for handling large tables? Thanks for any tips or advice.