Does SAP S/4HANA Actually Have a Simplified Data Model & Faster Financial Reconciliation?

Executive Summary

  • SAP has proposed that HANA and S/4HANA has a simplified data model.
  • We validated these claims including different account silos, faster reconciliation, understanding the performance of the columnar database.

Introduction: A Simplified Data Model?

SAP has been very consistent in pointing to the benefits of S/4HANA’s simplified data model and as part of its SAP Run Simple marketing program.

However, after listening to this sometimes, and reading on quite a bit of SAP marketing literature, I began to question this assertion of the SAP Run Simple program. In this article, you will learn whether S/4HANA has a simplified data model.

Interpreting SAP Run Simple Related to S/4HANA and HANA

When watching a presentation by SAP, or reading through documents related to S/4HANA and HANA generally, the proposed benefits “come at you” very fast.

It takes some time to sit down and look at each of the proposals individually to determine if they are either true or likely to be true.

Importance of Verifying the Simplified Data Model for SAP Run Simple

Understanding the concept of SAP’s proposal regarding a simplified data model is important as it is used as a foundation on which to build an argument for other benefits, one of the most important beings that overall S/4HANA is more simple to use. However, the one I will use in this article is the proposed benefits to financial reconciliation.

The SAP states clearly regarding S/4HANA having a simplified data model for SAP Run Simple.

Jens Kruger from SAP has a video on S/4HANA, and he states that.

“S/4HANA offers a simplified data model.”

And that…

“All data is available without reconciliation, leaving financial departments to strategic tasks instead of just doing administrative functions. How can this be done? This is based upon a simplified data model. The simplified data model enables insights into financials data. “

He then goes on to say:

 “All of those silos required a reconciliation in order to get a consistent view on the data. And therefore getting instant insight into data across all silos is not possible. Therefore, the power of SAP HANA underneath the universal journal entry creates a single source of truth, and there is no reconciliation needed.”

 “Under a traditional close, it is consists of a lot of steps. They must be performed in a batch fashion since they are just running too long. With the SAP HANA platform we are now able to reduce this.”

And Jen also provides specific speed improvements.

Here is where the proposed speed improvements are declared by SAP. This is interesting because I had never heard that reconciliation was negatively impacting so many global FI/CO implementations, which is what Jens Kruger is proposing. 

Different Accounting Silos?

Jens identification of Financial Accounting Documents, Controlling Documents and Profitability Documents as separate silos are strange. These are all integrated transactions within the FI/CO module currently in ECC. However, his point seems to be that reconciliation times in ECC presently make them break into different silos.

This video from SAP also makes the claim that financial reconciliation is greatly improved.

S/4HANA’s Data Model

Let us clarify what a data model is before we go through to validate the claim regarding its simplification.

A data model is the set of tables and the relationship between tables that are used — in this case — for the application to call upon. I have included just a small part of the data model in SAP ECC related to Work Centers, the Bill of Materials and the Production Version.

A simplified data model would mean that the tables and the relationships, as well as the primary versus secondary or supporting tables, are simplified. However, it can only partially say to be true of HANA. Here is why: 

  1. The Use of Columnar Tables
  2. Relationships Between the Tables
  3. Fewer Indices and Aggregation Tables

The Use of Columnar Tables

HANA uses columnar tables, which means that many tables are a single column. This of course significantly increases the number of tables that are necessary, and because the previous tables need to be emulated for people that need to see and work with the data, the data model is not simplified.

Relationships Between the Tables

SAP’s point is probably that they cleaned up the relationships, and having reviewed many previous SAP tables and modeled the tables in ERD diagrams, I can say that many of the tables and the relationships between the tables were indeed convoluted in their design.

When software development happens, the idea is that all the tables are laid out ahead of time, but the reality is that often the tables are added in a way that is more holistic, and much of ECC was written before more advanced data modeling tools were available.

Fewer Indices and Aggregation Tables

There are fewer database speeding mechanisms needed like aggregates and indices, but this is not the actual data model. SAP may be using a shorthand here that when they refer to the term “data model” they mean all of the tables used in the database. I think that could be a fair point. It is true that columnar databases tend to need fewer supporting tables. However, HANA still uses aggregates, although they call it something else. In fact, it is right on the SAP HANA website. Aggregates are beneficial because they are precomputed combinations that are always reused.

What should be apparent from the bullet points above is that the “data model” simplification that is so breezily referred to by SAP is not definitive in any shape or form. With a columnar database, some areas become more simple, other areas more involved. Overall, there are also complexities involved with a new database, so I would predict that HANA will be more complicated than a company’s previous database installation. That is the issue with new products, and the more new, the more unpredictable outcomes.

I cover these type of risk interpretation topics in the book Rethinking Enterprise Software Risk: Controlling the Main Risk Factors on IT Projects. One of the issues I bring up in the book is if the software vendor has too much influence over the consulting company, the outcome can be highly risky projects being proposed.

SAP and SAP’s surrogates have pushed the idea that HANA provides simplification of an IT environment. For example, in an article on HANA, John Appleby (an SAP surrogate) made the following statement.

“Most organizations spend a substantial amount on BI projects, and with BW on HANA they will either spend less (fewer full time employees or consultants) or achieve more for the same, in a shorter elapsed time. Our benchmarking suggests that project build times are 20-30% less with BW on HANA, leading to an overall saving of 10-12% or more for capital projects.”

We analyzed SAP’s proposal that HANA’s data model is simplified in the article Does HANA Have a Simplified Data Model?

In this article, we will evaluate this proposal of simplification from another dimension.

Lack of Simplification to HANA

The following quotation is from a reliable and verified source that works in databases (but one who prefers to remain anonymous).

“On the overall topic of “simplification” from the database layer into application tier point of view currently HANA looks like anything but simplification forcing significant re-mapping of functionality between different, new modules, the deployment of the Universal journal, the 400 page HANA simplification guide, etc etc.”

These are of course the areas of HANA that customers tend to not find out about until after they have either engaged in a HANA POC or implemented HANA.

“In essence SAP have partially switched from the need to develop and regression test over multiple AnyDB choices to sustain the PAM / Client NetWeaver platform choice, to forced client migration of functionality between modules and cloud (SCM is a good example roughly half the function lands in S/4HANA, roughly half in the Cloud based IBP functionality) with multiple version / functional interdependencies.

Also, HANA appliance building block sizes are not very granular.

This to me simply looks switching one set of challenges for another, it’s not really simplification.”

Simplified Data Model = Faster Reconciliation as Part of SAP Run Simple?

Is it the simplified data model that speeds reconciliation and therefore creates a single version of the truth? As I just discussed, using a columnar database uses fewer assisting or secondary tables, But it also creates a lot more tables, with many more relationships, in addition to having to generate the views of the previous tables of ECC. As it is illogical to work with just a bunch of columnar tables.

If you go into ECC on HANA, you will see all the same tables that you have seen before because they are emulated by HANA — so how much this is simpler depends upon your point of view.

Understanding the Performance of the Columnar Database

Secondly, a columnar database like HANA will underperform a standard row based (aka relational database) in transaction processing — and this includes year-end close (all other things being equal).

When HANA is proposed to be universally virtuous in performance in all situations, remember that a columnar database only outperforms relational databases for analytical applications. However S/4HANA is intended to sit only on HANA (although I see this exclusivity changing in the future), but HANA uses much more expensive and higher speed hardware, so the increase in speed, in this apparent non-analytical application, will come from more costly and higher speed hardware only.

Therefore, the statement that HANA’s “simplified data model” will lead to faster reconciliation is not true.

Why Faster Hardware is Actually What Will Lead to Faster Reconciliation

However, if we give it some consideration, this faster settlement will be equally available a company that would simply port its current ECC system to faster hardware.

Multiple Versions of the Truth?

It seems that SAP is changing the previous story on ECC to make points for S/4HANA. I don’t think that SAP would be talking about how terribly slow its reconciliation and period closing is in ECC if they were not trying to sell S/4HANA (call me cynical). If this is all true about reconciliation latency, then the question is do other software vendors face this issue.

To find out I reached out to two financials vendors, Intacct and FinancialForce, two accomplished vendors in the area of financial applications, to determine if they have similar reconciliation problems. Neither of them uses an in-memory database. Neither of them seemed to have heard of the problems with reconciliation and period closing that is described by SAP. When I spoke to FinancialForce they had the following to say about reconciliation and period closing in their system:

“You need to do all the things to setup the year end, and we have an automated button that performs all of the reconciliation. The a button is hit and the journals are created for you. This is not even a batch job process — in that it may take 30 minutes to 2 hours, with 2 hours being on the very long side.”

Therefore, what amounts to a quarterly or yearly process takes in most cases roughly 45 minutes. So if we take SAP’s proposal, S/4HANA will cause save 420 hours on the quarterly close. If that is the number of hours saved, how many total hours are present ECC systems taking exactly? That just sounds terrible.

Something which is not being adequately explained by SAP is that there are things to check before reconciliation is performed.

Reconciliation Speed Issues?

ECC’s hardware, not the data model of ECC versus S/4HANA is what is attributed to reconciliation speed changes. But secondly, two financial vendors are unaware of the batch problems in their systems that SAP has attributed to ECC.

Here are some important things to consider when interpreting the message of reconciliation and period closing as described by SAP:

  • It should be remembered quarterly closing is only a small portion of the activities performed within FI/CO.
  • Finance is not an area which requires a lot of computing power, and SAP is stretching here to find something that can help sell S/4 Simple Finance.


The information provided by SAP on this topic is convoluted, and once broken down into its constituent pieces it does not add up. Jens Kruger of SAP is commingling several different topics to make a case for S/4HANA Simple Finance, but the items that he attributes to HANA are not related to what he calls out. All of this is part of the attempt to fit into the SAP Run Simple marketing program. However, SAP Run Simple has little to do with reality. SAP Run Simple is nothing more than a marketing construct.

There is also appears to be the exaggeration on the part of SAP as to the impact of quarterly closes. This is not the first time I have seen this type of proposal from SAP. SAP also uses the example of long run times for MRP used to justify Simple Logistics. Why these issues have not been brought up more on articles on S/4HANA is a concern. However, I suppose that gives me the opportunity to provide some very good value to my readers and my clients. But it brings up a lot of issues regarding either the knowledge level or the independence of many of the media outlets that carry stories and are supposed to analyze SAP. For software buyers, if you have a consulting company that is proposing to you that the SAP S/4HANA data model is simplified, that would bear explanation on their part as to why that is. If they are just blindly agreeing with SAP on everything, then they will be limited in how much they can help you.


My recommendation is that the time required for reconciliation and quarterly closes be benchmarked in the client’s current ECC system to determine whether or not this is an issue. Statements about the reconciliation and quarterly close time should not be looked at in a separate matter but checked against what other software vendors in the area have to say on the topic.

Curious about the reality of S/4HANA implementations? See our The S/4HANA Implementation Study, for real story and details on actual S/4HANA implementations.

SAP’s Inaccurate Messaging on S/4HANA as Communicated in SAP Videos

Fact-Checking SAP Information on S/4HANA

This video is filled with extensive falsehoods. We will address them in the sequence they are stated in this video.

SAP Video Accuracy Mesurement

Appleby's StatementAccuracy % of the CommentExplanationLink to Analysis Article
S/4HANA is what allows key processes to be digitized.
ECC was already fully digitized and digitized across key business functions.The Problem with Using the Term Digital Transformation on IT Projects
HANA is a Platform
HANA is not a platform, it is a database.How to Deflect You Were Wrong About HANA
Fiori is a major advantage for S/4HANA.
In S/4HANA implementations Fiori is infrequently used when S/4HANA. How Accurate Was SAP on the Number of Fiori Apps?
Fiori is far more efficient than what came before.
In testing Fiori and S/4HANA, Sven Deneken's statements did not hold up. There was a particular weakness in actually making changes after noticing something needed to be changed, and we found the efficiency below that of ECC with of course SAPGUI.
S/4HANA is innovative as it brings "real time inventory."
Sven Deneken brings up the topic of "real-time capabilities," however there is nothing particularly real-time or different in terms of a reaction than ECC. Whenever you make a change in ECC or any other ERP systems for that matter, the entry is real-time. Sven Deneken states that "the physical inventory is the same as the digital inventory." However, under what system would this not be true?What Happened to the Term Perpetual Inventory?
S/4HANA is innovative because it allows access to supplier information.
Sven Deneken states that information about the supplier is "just a fingertip away." Sven Deneken may be familiar with ECC, where supplier data is also a fingertip, or say mouse click away. It called the Vendor Master in ECC.
Sven Deneken says that the cycle could be changed to daily or sub-daily.
Why would that occur? This is a very strange scenario that is being laid out.
S/4HANA is innovative because it allows MRP to be rerun interactively for a product location.
Sven Deneken is extremely confused when he states that S/4HANA allows a fresh MRP run to be performed for a specific product location and that this is a differentiator for S/4HANA. For a single product location, there is no ERP system that cannot run MRP for a single location. Secondly re-running MRP does not remove uncertainties. MRP can be re-run when something changes. For example, when the forecast changes.Performance Problems with HANA and MRP
Sven Deneken states this demo shows SAP has reimagined inventory management.
However, all of this functionality, save for several of the graphics shown in the video have already been available in ECC for many years, in fact, decades.

The Problem: A Lack of Fact-Checking of S/4HANA

There are two fundamental problems around S/4HANA. The first is the exaggeration of S/4HANA, which means that companies that purchased S/4HANA end up getting far less than they were promised. The second is that the SAP consulting companies simply repeat whatever SAP says. This means that on virtually all accounts there is no independent entity that can contradict statements by SAP.

Being Part of the Solution: What to Do About S/4HANA

We can provide feedback from multiple HANA accounts that provide realistic information around S/4HANA — and this reduces the dependence on biased entities like SAP and all of the large SAP consulting firms that parrot what SAP says. We offer fact-checking services that are entirely research-based and that can stop inaccurate information dead in its tracks. SAP and the consulting firms rely on providing information without any fact-checking entity to contradict the information they provide. This is how companies end up paying for a database which is exorbitantly priced, exorbitantly expensive to implement and exorbitantly expensive to maintain. When SAP or their consulting firm are asked to explain these discrepancies, we have found that they further lie to the customer/client and often turn the issue around on the account, as we covered in the article How SAP Will Gaslight You When Their Software Does Not Work as Promised.

If you need independent advice and fact-checking that is outside of the SAP and SAP consulting system, reach out to us with the form below or with the messenger to the bottom right of the page.

Financial Disclosure

Financial Bias Disclosure

Neither this article nor any other article on the Brightwork website is paid for by a software vendor, including Oracle, SAP or their competitors. As part of our commitment to publishing independent, unbiased research; no paid media placements, commissions or incentives of any nature are allowed.

S/4HANA Implementation Research

We offer the most accurate and detailed research into S/4HANA and its implementation history. It is information not available anywhere else and is critical correctly interpreting S/4HANA, as well as moderating against massive amounts of inaccurate information pushed by SAP and their financially biased consulting ecosystem.

Select the description that best matches you.

Option #1: Do You Work in Sales for a Vendor?

See this link for an explanation to sales teams.

Option #2: Do You Work for an Investment Entity that Covers SAP?

See this link for an explanation for investment entities. 

Option #3: Are You a Buyer Evaluating S/4HANA?

For companies evaluating S/4HANA for purchase. See this link for an explanation to software buyers

Search Our Other HANA Simplification Content


Marketing constucts like SAP Run Simple and simplified data models that have nothing do do with reality detract from implementing beneficial programs. I cover how to interpret risk for IT projects in the following book.