Skip to Content

Reading large tables; trying to get GL acct usage dates

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 17 at 07:20 AM

    If your company has BO BI platform, then ask BI team to create some group by Table for you. then you can direct create connection and use that table to analyze.

    Add comment
    10|10000 characters needed characters exceeded