Open-Period Estimated Actual Unit Cost Report (Before the Material Ledger Close)
Short answer: A report that calculates an estimated actual unit cost per material from the actual purchase and production costs of the current period, before the month is closed and before material ledger actual costing runs. Standard price, price differences in the period, invoice differences and production order variances are shown together, so pricing and profitability decisions do not have to wait for period end.
- Estimated effort
- M · 12–18 working days
- System
- ECC and S/4HANA
- Tables
- 13
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
The actual unit cost (periodic unit price) only exists after the material ledger close (CKMLCP) has run. During the period CKM3N shows only the price differences collected so far; it does not roll them up across levels or include variances of production orders not yet settled. When raw material prices change quickly, teams want a cost estimate without waiting for month end and prepare it in Excel.
Who uses it? Cost accountants, controlling teams, sales pricing teams and production managers.
Closest standard alternatives
- CKM3N Material Price Analysis. Material price analysis; shows differences collected in the period but makes no pre-close estimate or roll-up.
- CKMLCP Actual Costing Cockpit. Actual costing closing cockpit; produces the final periodic price only at period end.
- KKBC_ORD Analyze Order. Cost analysis of a single production order; does not aggregate unit costs per material.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| MBEWMaterial Valuation | Material's standard price, price unit and stock quantity (driving table) | — | ECC + S/4 |
| CKMLHDMaterial Ledger: Header Record | Material ledger header: cost estimate number | CKMLHD-MATNR = MBEW-MATNR AND CKMLHD-BWKEY = MBEW-BWKEY | ECC + S/4 |
| CKMLCRMaterial Ledger: Period Totals (Values) | Standard and periodic unit price per period | CKMLCR-KALNR = CKMLHD-KALNR | ECC + S/4 |
| ACDOCAUniversal Journal Entry Line Items | Price difference items and production order actual costs (S/4HANA) | ACDOCA-MATNR = MBEW-MATNR AND ACDOCA-KALNR = CKMLHD-KALNR | S/4HANA only |
| MATDOCMaterial Documents (S/4HANA) | Goods receipts of the period (S/4HANA) | MATDOC-MATNR = MBEW-MATNR AND MATDOC-WERKS = MBEW-BWKEY | S/4HANA only |
| MSEGMaterial Document Item | Goods receipts of the period (ECC) | MSEG-MATNR = MBEW-MATNR AND MSEG-WERKS = MBEW-BWKEY | ECC only |
| COEPCO Object: Line Items (by Period) | Production order actual costs (ECC) | COEP-OBJNR = AUFK-OBJNR | ECC only |
| EKBEPurchasing Document History | Purchase order history: goods receipt and invoice values | EKBE-MATNR = MBEW-MATNR AND EKBE-WERKS = MBEW-BWKEY | ECC + S/4 |
| RSEGDocument Item: Incoming Invoice | Invoice items and invoice price difference | RSEG-MATNR = MBEW-MATNR AND RSEG-WERKS = MBEW-BWKEY | ECC + S/4 |
| AUFKOrder Master Data | Production orders with movements in the period | — | ECC + S/4 |
| AFRUOrder Confirmations | Production confirmations and delivered quantity | AFRU-AUFNR = AUFK-AUFNR | ECC + S/4 |
| KEKOProduct Costing Header Data | Product cost estimate header (for the roll-up) | KEKO-MATNR = MBEW-MATNR AND KEKO-WERKS = MBEW-BWKEY | ECC + S/4 |
| CKISUnit Costing and Product Costing Items | Cost estimate items: component quantities | CKIS-KALNR = KEKO-KALNR | ECC + S/4 |
S/4HANA notes
- MBEW: In S/4HANA the Material Ledger is mandatory and valuation data is read through a compatibility view. Prices remain readable; validate value calculations against the currency and valuation view in use.
- MSEG → MATDOC: In S/4HANA MATDOC replaces MSEG; reading MSEG works through a compatibility view but is slow at high volumes.
- COEP → ACDOCA: In S/4HANA actual CO line items are stored in ACDOCA; reads on COEP go through the compatibility view V_COEP.
BAPIs and functions used
- K_KKB_CO_OBJECT_READRead Cost Totals of a CO Object. Reads the cost object of the production order
- CONVERSION_FACTOR_GETGet Unit Conversion Factor. Converts between receipt and stock units
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_BWKEY | Valuation area (plant) | Single value | MBEW-BWKEY | Yes | 1100 |
| P_BDATJ | Year | Single value | CKMLCR-BDATJ | Yes | 2026 |
| P_POPER | Period | Single value | CKMLCR-POPER | Yes | 011 |
| S_MATNR | Material | Range / multiple | MBEW-MATNR | No | HT-* |
| S_MTART | Material type | Range / multiple | MARA-MTART | No | ROH, HALB, FERT |
| P_ROLL | Roll component differences up to the higher-level material | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Material | MBEW-MATNR |
| 2 | Price control | MBEW-VPRSV |
| 3 | Standard price | CKMLCR-STPRS |
| 4 | Receipt quantity in period | Calculated Sum of goods receipts and production deliveries in the period |
| 5 | Purchase/invoice difference | Calculated ACDOCA price difference items (goods receipt and invoice) |
| 6 | Production variance | Calculated Order actual cost − delivered quantity × standard price |
| 7 | Roll-up difference | Calculated Component unit difference × cost estimate quantity |
| 8 | Estimated actual unit cost | Calculated (Standard value + differences) / receipt quantity of the period × price unit |
| 9 | Difference % | Calculated (Estimated actual − standard) / standard × 100 |
| 10 | Previous period periodic price | CKMLCR-PVPRS |
| 11 | Currency | CKMLCR-WAERS |
Sample output
| Material | Price control | Standard price | Receipt quantity in period | Purchase/invoice difference | Production variance | Roll-up difference | Estimated actual unit cost | Difference % | Previous period periodic price | Currency |
|---|---|---|---|---|---|---|---|---|---|---|
| HM-PAMUK-01 | S | 82.50 | 120,000 | 540,000 | 0 | 0 | 87 | 5.45 | 84.10 | TRY |
| YM-IPLIK-30 | S | 148 | 64,000 | 0 | 211,200 | 172,800 | 154 | 4.05 | 150.20 | TRY |
| HT-NEV-220 | S | 610 | 9,500 | 0 | -38,000 | 66,500 | 613 | 0.49 | 607.50 | TRY |
| KM-BOYA-12 | V | 245 | 3,200 | 12,800 | 0 | 0 | 249 | 1.63 | 246 | TRY |
How does the report work?
- For the selected plant and period, each material’s standard price and stock quantity are read from MBEW, the material ledger number and period prices from CKMLHD/CKMLCR.
- Purchased materials: goods receipts (MATDOC in S/4HANA, MSEG in ECC) and invoices (RSEG, EKBE) in the period are summed; goods receipt and invoice differences are taken from the price difference items in ACDOCA (per material and period). Estimated actual unit cost = (standard value + price differences of the period) / receipt quantity of the period.
- Produced materials: the actual costs of the period’s production orders (ACDOCA in S/4HANA, COEP in ECC) and the delivered quantity (AFRU confirmations, goods receipts) are read. Because the order is not yet settled, the variance is calculated as actual cost − delivered quantity × standard price and spread per unit.
- Optional single-level roll-up: the estimated unit cost difference of components is multiplied by the quantities from the product cost estimate (KEKO/CKIS) and added to the higher-level material. This way a raw material price change is roughly reflected in the finished product cost.
- The result shows per material the standard price, the estimated actual unit cost, the difference percentage and its source (purchasing, invoice, production, roll-up). The previous period’s final periodic unit price is taken from CKMLCR for comparison.
- The report is an estimate; it does not replace the material ledger close and posts nothing.
Performance notes
Restrict ACDOCA by plant (valuation area), period and the relevant business transaction types and read it aggregated per material. For production orders select only those with movements in the period. Keep the roll-up step optional and run the report in the background for large plants.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Drill down from the material to CKM3N and to the documents behind the difference.
- Runs as a background job
- Export to Excel
Authorization objects
- K_ML_VADisplay by material ledger valuation area
- M_MATE_WRKMaterial master by plant
Frequently asked questions
Why can the figure in the report differ from the periodic unit price at period end?
The material ledger close finalises the multi-level roll-up, the distribution between ending stock and consumption and invoices not yet received. The report estimates from the movements so far; as the period progresses and invoices arrive, the estimate approaches the final value.
Does it work in ECC systems without the material ledger?
The basic calculation can be done with MBEW, MSEG, RSEG/EKBE and COEP; only the previous period periodic price column stays empty. In S/4HANA the material ledger is mandatory, so all columns are filled.
Does the report post anything?
No. It only reads and produces an estimate; valuation and posting are still done by the standard material ledger close.
Related reports
Mass Material Price Change and Inventory Debit/Credit Posting
A custom program that posts moving average or standard price corrections and debits/credits to inventory value from a file, for company and project …
Production Order Target vs Actual Cost Variance Report
A custom ALV report that compares the actual cost of production orders in a plant with the target cost from delivered quantity × standard price, and …
Let us build this report for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.