Aggregate value through on the fly calculation from BSEG table.

[Former Member]

Hi Experts,

I am a new bird in SAP SFIN. I am going through different SFIN blog posts and documents and getting confused on some of the points. It would be really thankful to you if you would clear my below doubts.

How the system will calculate the aggregate values on the fly in BSEG table as the materialized aggregate tables have been already obsoleted in SAP SFIN?

Materialized view (BSIS,BSAS,BSIK,BSAK etc.) and Materialized aggregate(GLT0,FAGLFLEXT etc.) are now obsolete in SFIN but still exist with compatibility view. what does it mean?

Appreciate your early feedback.

Regards,

Mohammed Kalim

[Former Member · Accepted solution]

Hey Mohammed,

Please refer one of the existing thread where this issue was discussed:-

http://scn.sap.com/thread/3775286

About your query, the idea of having aggregates and index was for faster reporting.

But with Hana you can have aggregates very quickly,

So all the old tables ( as mentioned by you) are replaced by view, which will not have data footprint and will collate data on the Fly when referred.

Hope this helps,

Please close the thread.

Regards,

Rishab

[Former Member · Accepted solution]

Hi Rishab,

Thanks again for your quick reply. Above thread cleared my some doubts, but I am still have one doubt regarding the calculation of aggregate value on the fly in BSEG with HANA.

Please could you clear me "what is on the fly" calculation.

Regards,

Mohammed Kalim

[Former Member · Accepted solution]

Hey Mohammed,

By on the Fly, SAP means that you can get the sum / total values very quickly. That means the reporting  will be made quicker and on data model side there will be less number of tables.

Previously we would have total's / index table to enable faster reporting, now with HANA this is not needed.

I think your question is how

With HANA db there are a lot of changes, faster access, Row-Column storage etc.

So this is my take:-

1) BSEG may be a column table ( could not verify this), so summation at db level becomes faster.

2) Other aspect can be views which are available on BSEG which may help in faster reporting of aggregates

Found one ( my guess )

Hope this helps,

I wish I could better explain this point but not an expert in HANA.

If this is clear please close the thread.

Regards

Rishab

[NathanGenez · Accepted solution]

"on the fly" = "in memory".  HANA has lots of memory.