Aggregate value through on the fly calculation from BSEG table.
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.
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.