Lesson 4 of 5
Reporting margins
10 min
Listen to this lesson
A margin report is a contribution margin scheme read across characteristics. The scheme is the rows: revenue, deductions, COGS by component, variances, overhead. The characteristics are the way you cut it: by customer, by product, by sales district. Because the data sits in the Universal Journal, the same report can be run by any characteristic without rebuilding anything.
Reading a contribution margin report
| Line | Great Lakes Fleet Services | Aftermarket distributors | Total |
|---|---|---|---|
| Revenue | 48,000 | 36,000 | 84,000 |
| Sales deductions | −1,440 | −3,600 | −5,040 |
| Net revenue | 46,560 | 32,400 | 78,960 |
| COGS material and material overhead | −17,600 | −13,200 | −30,800 |
| COGS labor and machine | −10,000 | −7,500 | −17,500 |
| COGS production overhead | −2,400 | −1,800 | −4,200 |
| Contribution margin after COGS | 16,560 | 9,900 | 26,460 |
| Margin % | 35.6% | 30.6% | 33.5% |
A simplified July contribution margin view for CMC-ALT-100 (illustrative, USD).
The aftermarket sale used 150 units at USD 240 list, with larger deductions. Reading across, the aftermarket channel's deductions eat a bigger share of revenue, and that is where the margin gap comes from, not from production cost. That is the kind of conclusion margin analysis is for.
- Margin figureAftermarket contribution margin 9,900
- LineSales deductions −3,600
- AccountCustomer rebate and discount accounts
- Journal entryBilling documents for the distributors
- SourcePricing conditions on the billing document
Where to run it
In the SAP Fiori launchpad, margin analysis is reported through analytical apps on the Universal Journal and through queries that read the market segment fields. App names, catalogs and key figure schemes vary by release and by the roles assigned, so confirm the apps your controllers will use during design. SAP's learning material notes that actual data for margin analysis comes from ACDOCA, while plan data is stored separately. Whatever the tool, a controller should be able to drill from any figure to the journal entry and then to the billing document or goods issue that created it.
| Tool | What it is good for | Notes |
|---|---|---|
| Market Segments – Actuals (Fiori, F0943) | Slicing actual revenue and COGS by characteristics, drilling to journal entries | Reads ACDOCA; some predefined characteristics are not offered as dimensions |
| Product Profitability (Fiori analytical app) | Contribution margin by product with product attributes | Standard characteristics only; user-defined WW characteristics are not shown |
| Display Line Items / Journal Entry Analyzer (Fiori) | Reading the individual lines behind a figure, with market segment fields | The fastest way to see a missing characteristic |
| KE30 drilldown reports (SAP GUI) | Existing CO-PA report forms reused for margin analysis | Private Edition and on-premise only; no SAP GUI in Public Edition |
| CDS-based queries and SAP Analytics Cloud stories | Margin packs, plan/actual and management decks | Build on released CDS views, not on direct table reads (clean core) |
Common ways to report margin analysis in SAP S/4HANA 2025 Private Edition. App availability depends on release and roles; confirm the IDs in the SAP Fiori apps reference library.
Fixed and variable
To show a true contribution margin, variable and fixed cost must be separated. In margin analysis SAP's learning material describes using the total amount and the fixed amount on the same account: the variable part is total minus fixed, calculated in the report. This works only if the cost component split carried fixed and variable parts from the standard cost estimate, which is a design decision made in product costing.
| Question | Characteristic to use | What to watch |
|---|---|---|
| Which customers are most profitable? | Customer | Unassigned customer on COGS or variance lines |
| Which products carry the margin? | Product | Variances not assigned to products |
| Fleet versus aftermarket? | Distribution channel or market channel | Manual adjustments without the channel |
| Which region performs best? | Sales district | Customer master data quality |
Quantities and prices behind the margin
A margin figure on its own invites the wrong discussion. Always show quantity next to value: 200 alternators to Great Lakes Fleet Services at a net price of USD 240 and a standard cost of USD 150 tells sales and production what to talk about. Margin analysis in SAP S/4HANA carries quantities on the journal lines, so revenue per unit and cost per unit can be calculated in the report. If revenue per unit moves while cost per unit is flat, the conversation is about pricing and deductions; if cost per unit moves, it is about production and purchasing, and the cost component split points to which one.
What would you do?
Grace asks for a quick margin by sales district for the steering committee. The report shows 22% of COGS in "not assigned" for sales district. What should you do before sending it?
- A margin report is a contribution margin scheme sliced by characteristics.
- Every figure should drill down to the journal entry and source document.
- Fixed and variable cost come from the cost component split and are separated in reporting.
- Always check the "not assigned" values before drawing conclusions.
Check your understanding · not graded
Lesson check
1. Where does margin analysis read its actual data from?
2. A margin report shows a large "not assigned" row for customer. What does it indicate?
3. How is variable cost shown in margin analysis reporting, according to SAP's material?