# Open-Period Estimated Actual Unit Cost Report (Before the Material Ledger Close)

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

- Type: Report, Custom development, ALV report
- Module: CO
- Estimated effort: M (12–18 working days)
- Last updated: 2026-11-19
- URL: https://nekuhub.com/en/reports/open-period-estimated-actual-unit-cost-report/


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

### Closest standard alternatives

- CKM3N: Material price analysis; shows differences collected in the period but makes no pre-close estimate or roll-up.
- CKMLCP: Actual costing closing cockpit; produces the final periodic price only at period end.
- KKBC_ORD: Cost analysis of a single production order; does not aggregate unit costs per material.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| MBEW | Material's standard price, price unit and stock quantity (driving table) | Read | - | ECC + S/4 |
| CKMLHD | Material ledger header: cost estimate number | Read | CKMLHD-MATNR = MBEW-MATNR AND CKMLHD-BWKEY = MBEW-BWKEY | ECC + S/4 |
| CKMLCR | Standard and periodic unit price per period | Read | CKMLCR-KALNR = CKMLHD-KALNR | ECC + S/4 |
| ACDOCA | Price difference items and production order actual costs (S/4HANA) | Read | ACDOCA-MATNR = MBEW-MATNR AND ACDOCA-KALNR = CKMLHD-KALNR | S/4HANA only |
| MATDOC | Goods receipts of the period (S/4HANA) | Read | MATDOC-MATNR = MBEW-MATNR AND MATDOC-WERKS = MBEW-BWKEY | S/4HANA only |
| MSEG | Goods receipts of the period (ECC) | Read | MSEG-MATNR = MBEW-MATNR AND MSEG-WERKS = MBEW-BWKEY | ECC only |
| COEP | Production order actual costs (ECC) | Read | COEP-OBJNR = AUFK-OBJNR | ECC only |
| EKBE | Purchase order history: goods receipt and invoice values | Read | EKBE-MATNR = MBEW-MATNR AND EKBE-WERKS = MBEW-BWKEY | ECC + S/4 |
| RSEG | Invoice items and invoice price difference | Read | RSEG-MATNR = MBEW-MATNR AND RSEG-WERKS = MBEW-BWKEY | ECC + S/4 |
| AUFK | Production orders with movements in the period | Read | - | ECC + S/4 |
| AFRU | Production confirmations and delivered quantity | Read | AFRU-AUFNR = AUFK-AUFNR | ECC + S/4 |
| KEKO | Product cost estimate header (for the roll-up) | Read | KEKO-MATNR = MBEW-MATNR AND KEKO-WERKS = MBEW-BWKEY | ECC + S/4 |
| CKIS | Cost estimate items: component quantities | Read | CKIS-KALNR = KEKO-KALNR | ECC + S/4 |

## BAPIs and functions used

- K_KKB_CO_OBJECT_READ: Reads the cost object of the production order
- CONVERSION_FACTOR_GET: Converts between receipt and stock units

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| P_BWKEY | Valuation area (plant) | Single value | MBEW-BWKEY | Yes |
| P_BDATJ | Year | Single value | CKMLCR-BDATJ | Yes |
| P_POPER | Period | Single value | CKMLCR-POPER | Yes |
| S_MATNR | Material | Range / multiple | MBEW-MATNR | No |
| S_MTART | Material type | Range / multiple | MARA-MTART | No |
| P_ROLL | Roll component differences up to the higher-level material | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Material | MBEW-MATNR |
| Price control | MBEW-VPRSV |
| Standard price | CKMLCR-STPRS |
| Receipt quantity in period | Calculated: Sum of goods receipts and production deliveries in the period |
| Purchase/invoice difference | Calculated: ACDOCA price difference items (goods receipt and invoice) |
| Production variance | Calculated: Order actual cost − delivered quantity × standard price |
| Roll-up difference | Calculated: Component unit difference × cost estimate quantity |
| Estimated actual unit cost | Calculated: (Standard value + differences) / receipt quantity of the period × price unit |
| Difference % | Calculated: (Estimated actual − standard) / standard × 100 |
| Previous period periodic price | CKMLCR-PVPRS |
| Currency | CKMLCR-WAERS |

## How does the report work?

1. 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.
2. 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.
3. 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.
4. 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.
5. 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.
6. The report is an estimate; it does not replace the material ledger close and posts nothing.

## Authorization objects

- K_ML_VA: Display by material ledger valuation area
- M_MATE_WRK: Material 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=co-open-period-actual-unit-cost
