Profitability analysis with SAP S/4HANA Finance is an extremely important area for FICO users of the new suite.
It provides detailed analysis of the profitability of a company, thus enabling accurate contribution margin calculation. It can calculate the profitability on the level of numerous characteristics, which can be configured when implementing SAP S/4HANA.
But what exactly is profitability analysis and how has it evolved in SAP? What are the differences between the two types of profitability analysis? This blog will lay it out.
Profitability Analysis Overview
For a long time, profitability analysis was a core component of controlling in SAP because it provides answers to the most important questions for high-level management: How profitable is the company? How well is this segment performing? How profitable is this product? What is the contribution margin of that division? And so on.
But the power and flexibility of profitability analysis mostly lies in its multidimensional structure. You can analyze profitability not in only one or two dimensions, but in as many dimensions as are needed and configured in the system. Therefore, profitability analysis is often referred to as a multidimensional cube, as shown below:
The dimensions are the different characteristics by which the data is sliced and diced from a profitability analysis point of view, such as material, customer, sales organization, and so on. Each posting transferred to profitability analysis contains several characteristics, which together constitute a multidimensional profitability segment.
There are two types of profitability analysis that you can perform with SAP S/4HANA: account-based and costing-based. We’ll explain these types in detail in the following sections.
Costing-Based Profitability Analysis
Costing-based profitability analysis (sometimes referred to as CBCOPA) analyzes profitability using value fields such as material costs, discounts, revenues, and so on. These value fields can be regarded as buckets into which similar values are grouped. Costing-based profitability analysis was the most used type of profitability analysis in previous SAP releases.
Costing-based profitability analysis is very powerful because these value fields can be defined as required in each SAP client, thus allowing for a great degree of flexibility. From a data point of view, costing-based profitability analysis uses the following tables:
- CE1xxxx (actual line item table)
- CE2xxxx (plan line item table)
- CE3xxxx (segment level)
- CE4xxxx (segment table)
In this nomenclature, xxxx stands for the operating concern name. For example, if the operating concern is 1000, the actual line item table will be CE11000, the plan line item table will be CE21000, and so on.
There are some limitations to costing-based profitability analysis. For example, it’s quite challenging to reconcile costing-based profitability analysis with financial accounting. This stems from the very essence of costing-based profitability analysis: the value fields don’t match the accounts used in financial accounting.
Furthermore, there are differences in the value flow to financial accounting and the value flow to profitability analysis. The basic sales process involves creating a sales order, then delivery with goods issue, and finally sending an invoice document to the customer. In financial accounting, the cost of goods sold is posted with the goods issue and the sales revenue with the invoice. In costing-based profitability analysis, however, both the sales revenue and cost of goods sold are transferred with the invoice document. This leads to mismatches between financial accounting and profitability analysis at month-end.
These considerations prompted many companies to use account-based profitability analysis.
Account-Based Profitability Analysis
Account-based profitability analysis (ABCOPA) uses accounts (cost elements) to collect profitability values. Therefore, by design, it’s very easy to reconcile it with financial accounting. However, in SAP ERP and earlier versions, it had some considerable limitations. The cost of goods sold couldn’t be split among different cost components, which is possible in costing-based profitability analysis.
Also, variance analysis was only possible for totals variance, but not by variance category. That made costing-based profitability analysis the choice for most companies prior to SAP S/4HANA, and account-based profitability analysis was sometimes implemented in parallel to facilitate the accounting reconciliation process.
SAP has made a huge improvement to profitability analysis with SAP S/4HANA, and more specifically to account-based profitability analysis. Now in SAP S/4HANA the advantages of costing-based profitability analysis are available in account-based profitability analysis, combined with easy reconciliation with financial accounting.
Cost component split is now possible in account-based profitability analysis. Also, variance analysis is made possible by variance categories. Therefore, in SAP S/4HANA it’s possible to construct a profit and loss statement with a contribution margin calculation, very much like in costing-based profitability analysis.
From a technical point of view, account-based profitability analysis doesn’t create any additional tables. The segment postings update table ACDOCA, the Universal Journal, thus making the profitability analysis fully integrated with financial accounting.
Based on all of this, the preferred method of performing profitability analysis with SAP S/4HANA is the account-based approach. This is the default, required option SAP S/4HANA customers are given; however, you can activate costing-based profitability analysis in addition if you choose.
If you’re planning on a greenfield SAP S/4HANA implementation, however, it is suggested to use only account-based profitability analysis. You have all the benefits of the costing-based now in the account-based version. For brownfield implementations, it makes more sense to continue using the costing-based approach together with the now mandatory account-based approach.
Editor’s note: This post has been adapted from a section of the book Configuring SAP S/4HANA Finance by Stoil Jotev.