Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Aggregate value through on the fly calculation from BSEG table.

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 replied

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

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question