At SAP, we set out to change how finance is done. Traditional systems relied on inflexible models, precomputed data, and slow computational systems. With SAP HANA and SAP Simple Finance we changed that, to give you a more agile approach to financial management and planning. By eliminating things such as needleless duplication and precomputation of data which clogs other systems, we have significantly lowered your cost of managing Financials.
SAP HANA Makes Redundant Data Obsolete
Redundant data refers to data that is physically stored in a database but could be derived by calculating it from other data in the database, Redundancy is a frequent source of inconsistency and anomalies. As redundant data needs to be kept in sync on updates, redundancy in a data model leads to slower updates. To reduce redundancy, database normalization techniques such as normal forms have been introduced.
Building on SAP HANA’s in-memory technology, it has now been possible to non-disruptively transform the Financials system into a purely line-item-based Simple Finance that gets rid of all redundant financials data. Thus, SAP Simple Finance overcomes the associated costs such as reduced transactional throughput and increased database footprint. At the same time, SAP Simple Finance is a non-disruptive innovation of the classical ERP Financials because it replaces the materialized views with non-materialized compatibility views. All applications that have read from the materialized views, be it SAP standard reports or customer modifications, continue to access the views as before without requiring any changes.
A New, Non-disruptive Data Model with Zero Redundancy
The fundamental and essential data tuples of every financial accounting system are the accounting documents and line items, in this case stored in the tables BKPF and BSEG, respectively. The traditional data model of SAP ERP Financials – which is running on SAP HANA as part of SAP Business Suite powered by SAP HANA (in the following: Suite on HANA) – additionally contained materialized views that allowed fast access on disk-based database systems to open and cleared line items, separated by accounts receivable, accounts payable, and general ledger accounts. As calculations and observations in future installments of this deep dive series will show, SAP HANA’s in-memory database makes materialization obsolete thanks to the improved performance. Hence, the decision for SAP Simple Finance was clear: the previously existing materialized views have been removed and replaced by compatibility views. These compatibility views transparently provide access to the same information calculated on the fly to ensure that the changes are non-disruptive.Benefits of SAP Simple Finance in Summary
The data model of SAP Simple Finance is now exclusively consisting of line items. It is “simply” recording all business transactions as they happen. Everything else is being calculated on-the-fly by algorithms on the data. This implies that the previously needed modifying operations to maintain the materialized views are no longer necessary, thereby simplifying the program code and increasing the transactional throughput.The fact that it is feasible to remove the redundancy from the Financials data model demonstrates that in-memory database systems enable new levels of flexibility. Instead of pre-defining materialized views and materialized aggregates, it is possible to aggregate flexibly directly on the line items. Instead of being restricted to specific analysis questions supported by the underlying model of materialization, all questions are feasible that can be answered based on the actual items themselves via any aggregation on top of them. An improved and user-friendly user experience adds to that and allows unprecedented user productivity and novel insights .
Still have to come more on Finance ...no limits and sky is wide .