Lesson 2 of 5
Account-based margin analysis
10 min
Listen to this lesson
SAP has offered two ways of doing Profitability Analysis for many years. Costing-based CO-PA stores values in its own value fields and tables. Account-based CO-PA stores values by account. In SAP S/4HANA, the account-based form is called margin analysis and is fully integrated into the Universal Journal.
Why it reconciles by design
In margin analysis, the market segment is simply a set of fields on the journal entry line. When a billing document posts revenue, the revenue line in table ACDOCA carries the account, the amount, the profit center and the characteristics. There is no second document and no copy. That is why a margin analysis report and the income statement agree by design: they read the same lines. SAP's learning material describes margin analysis as keeping management and financial accounting reconciled, with costs and revenues posting to both at the same time.
| Costing-based CO-PA | Margin analysis (account-based) | |
|---|---|---|
| Where values are stored | Own tables per operating concern, in value fields | Universal Journal lines, by G/L account |
| Reconciliation with FI | Not guaranteed; timing and valuation can differ | By design: the same journal lines |
| Cost of goods sold timing | Typically transferred with the billing document | Posted at goods issue |
| Cost component detail | Via value fields | Via COGS split accounts |
| SAP S/4HANA Cloud Public Edition | Not available | Available |
| Future investment | Still supported in Private Edition and on-premise; new functions go to margin analysis | SAP's recommended approach and where new functions land |
What costing-based CO-PA still offers
Costing-based CO-PA had strengths that kept it popular in SAP ECC: flexible value fields, valuation with conditions (for example an estimated commission at billing), and several cost estimates in parallel. Practitioner sources note that margin analysis has closed many gaps, including quantities, COGS split by component and variance split by category, but not every feature. In SAP S/4HANA Private Edition and on-premise you can activate both; in SAP S/4HANA Cloud Public Edition only margin analysis is available.
| Capability | In margin analysis (SAP S/4HANA) | What to test at Contoso |
|---|---|---|
| Quantities | Quantities carried on revenue and COGS lines | Revenue per unit and cost per unit by customer |
| COGS by cost component | COGS split to one G/L account per component at goods issue | Component accounts add up to the COGS line |
| Variances by category | Price differences split by variance category to separate accounts | Variance accounts per category after settlement of production order 1001200 |
| Top-down distribution | KE28 distributes values posted at a high level (for example a rebate accrual) to detailed market segments | Distributed totals equal the source amount |
| Planning | Plan data in the Universal Journal plan table (ACDOCP), used by SAP Analytics Cloud-based planning | Plan/actual comparison by customer group |
What margin analysis covers in SAP S/4HANA that account-based CO-PA in ECC did not (check details for your release).
- Is this SAP S/4HANA Cloud Public Edition?Yes → margin analysis only · No → next question
- Do reports depend on costing-based features with no margin analysis equivalent?Yes → consider running both for a transition period · No → margin analysis alone
- Is there a plan and an owner to retire costing-based CO-PA?Yes → document the end date · No → set one before go-live
Contoso's decision in the conversion
Contoso's ECC system EP1 ran costing-based CO-PA, and finance's monthly margin pack was built on it. For the conversion, Dan decided to activate margin analysis as the target, rebuild the margin pack on it, and keep costing-based CO-PA active in parallel through the first fiscal year-end as a comparison. After year-end, costing-based reports are retired. The decision, its end date and its owner are recorded in the finance design document.
- ExploreDesignCharacteristics, COGS split and variance split defined for margin analysis
- Mock 1 and 2Build and compareMargin pack rebuilt; costing-based and margin analysis compared per period
- Go-live (Q3)Parallel runBoth active; differences explained monthly
- After year-endRetireCosting-based reports switched off; margin analysis is the only source
A practical consequence for testers: in a conversion, the reference for margin analysis is not the old costing-based report but the general ledger. Revenue, sales deductions and cost of goods sold in margin analysis must equal those accounts in the trial balance for the same period, because they are the same lines. The comparison with the old costing-based report is a second, explanatory check that helps business users trust the new numbers; it is not the pass or fail criterion.
What would you do?
During mock conversion 2, Ana notices that margin analysis shows June COGS of USD 1.20 million while the old costing-based report shows USD 1.15 million. Revenue matches. What is the most likely explanation?
- Margin analysis is account-based and stores market segments on Universal Journal lines.
- It reconciles with financial accounting by design.
- Costing-based CO-PA can run in parallel in Private Edition and on-premise, not in Public Edition.
- Plan a parallel run with explained differences and a retirement date.
Check your understanding · not graded
Lesson check
1. Why does margin analysis agree with the income statement?
2. Which form of Profitability Analysis is available in SAP S/4HANA Cloud Public Edition?
3. When does margin analysis record cost of goods sold for a sale?
4. What happens when Contoso adds a new WW characteristic in SAP S/4HANA?