SAP Material Ledger Actual Costing: From Variances to Real Product Costs
SAP Controlling Conference attendees participating in a presentation

Search Posts

By John Jordan

A finished product can come off the line at standard cost even when its components cost more than expected. Where do those differences go? In SAP S/4HANA, Material Ledger Actual Costing follows them from purchase and production through to inventory, consumption, and cost of goods sold (COGS).

This blog is based on a presentation by Marjorie Wright & Rogerio Faleiros at the SAP Controlling Conference.

Start with Material Price Analysis

Rogerio Faleiros and Marjorie WrightMaterial Ledger is mandatory in SAP S/4HANA. Actual Costing is optional. In the presenters’ example, the materials use standard price control and price determination 3 for single- and multilevel price determination. Goods movements are initially valued at standard price. Material Price Analysis (CKM3, also accessed as CKM3N depending on the release) shows the preliminary valuation, price differences, and exchange rate differences for a material, plant, and period.

Read the screen in order. Beginning inventory and receipts make up cumulative inventory. Consumption shows what left stock, including COGS for materials sold. Ending inventory shows what remained. Expand the relevant lines to see the transactions behind each amount. You can investigate posted differences during the month and review their final allocation after the costing run.

From Standard Price to Periodic Unit Price

In the finished-product example, there was zero opening inventory. Production received 14,300 pairs, sales consumed 10,000 pairs, and 4,300 pairs remained in stock. The standard price was 43,595 per 10,000 pairs. The period’s actual costing run calculated a periodic unit price of 51,271 per 10,000 pairs, about 17.6% higher.

SAP calculates the periodic unit price from the cumulative inventory line. It adds the applicable signed price and exchange rate differences to the preliminary value, divides by cumulative quantity, and multiplies by the material’s price unit. Check that price unit before comparing the two prices. The price in this example is expressed per 10,000 pairs.

The presenters enabled both inventory and consumption revaluation. In their example, this meant part of the difference went to COGS for the pairs sold and part went to ending inventory. The periodic unit price measures the cost for the closed period. The standard price remains the benchmark for routine postings and variance analysis until it is changed separately.

Follow Variances Through the Actual Quantity Structure

When a semifinished material is consumed to make a finished product, SAP uses the actual quantity structure to roll up the applicable share of its price differences. Those differences may come from purchase price variances on inputs or production order variances at an earlier level. In CKM3, drill from the finished product to the semifinished material to see where a difference started. For variances incurred at the finished-product level, reconcile the settlement line to the production order and the corresponding FI posting.

Multilevel analysis can also explain a timing mismatch. If inventory carries into the next period, the cost associated with that inventory can flow into consumption when the stock is used or sold. That’s why the amount revalued in COGS this month can differ from the variances posted this month.

Use the Actual Cost Component Split to Explain What Changed

The periodic unit price tells you how much the material cost. The actual cost component split, when active, helps explain what drove the difference. The presenters compared direct materials, personnel time, machine time, and production overhead. Use the level and lower-level views to distinguish costs incurred on the displayed material from differences rolled up from its components. Where consumption revaluation uses the original account assignment, the adjustment can also carry the relevant profitability characteristics into Margin Analysis, depending on configuration.

Review Exceptions Before Posting the Close

The Value Flow Monitor gives controllers a run-level view of what was allocated to consumption, inventory, and, where applicable, work in process. Review any amounts flagged as not distributed or not allocated before posting the closing entries. A late freight invoice against little or no remaining stock is one example the presenters discussed. Start with the affected material in CKM3, then follow the chain to the source. For plants with interplant flows in the same company code, coordinate their inclusion in the closing run so differences can follow the material.

This blog is based on the presentation by Marjorie Wright & Rogerio Faleiros, “Deep Dive into the Heart of SAP Material Ledger in S/4HANA Controlling,” at the SAP Controlling Conference. To watch the full session and explore other SAP Controlling topics, sign up for ERPCorp membership.