Learn SAP from the Experts | The SAP PRESS Blog

Profitability Analysis with SAP S/4HANA Finance

Written by SAP PRESS | Nov 19, 2019 2:00:00 PM

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 post 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.

 

Two types of profitability analysis exist: account-based (margin analysis) 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 (Margin Analysis)

Margin analysis 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 margin 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 margin 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.

 

With these considerations in mind, in SAP S/4HANA, margin analysis is not only the recommended approach but also the required approach. You can activate costing-based profitability analysis in addition if you choose. However, our recommendation for a greenfield SAP S/4HANA implementation is to only use margin analysis. You'll enjoy all the benefits of costing-based profitability analysis now in the account-based version. For brownfield implementations, continuing to use the costing-based approach together with the new mandatory account-based approach makes sense.

 

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.

 

Editor’s note: This post has been adapted from a section of the book Configuring SAP S/4HANA Finance by Stoil Jotev.