# Material Quantity and Value Reconciliation Report (Opening, Receipts, Issues, Closing)

> A custom ALV report that shows, for each material and the selected periods, opening stock, receipts, issues and closing stock in quantity and value side by side and checks the equation "opening + receipts − issues = closing". Value differences that break the equation (price changes, invoice differences, revaluations) appear in a separate column.

- Type: Report, Custom development, ALV report
- Module: CO
- Estimated effort: M (5–8 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/material-quantity-and-value-reconciliation-report/


## Why is the standard not enough?

MB5B shows stock on a date and the movements in between, but it does not total receipts and issues by type (purchasing, production, consumption, sales, scrap) and does not check the quantity and value equation. MC.9 and CKM3 serve other purposes. At month-end close the reconciliation is usually built by combining several reports in Excel. The custom report gives the reconciliation and the difference on one line.

### Closest standard alternatives

- MB5B: Shows stock on a posting date and the movements in between; no movement type groups and no reconciliation difference.
- MC.9: Gives total receipts and issues in the stock analysis; does not show the value reconciliation or the source of the difference.
- CKM3: Gives the price history of one material where material ledger is used; it is not a multi-material reconciliation list.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| MBEW | Current stock quantity and value, valuation class (driving table) | Read | - | ECC + S/4 |
| MBEWH | History of period-end stock quantity and value | Read | MBEWH-MATNR = MBEW-MATNR AND MBEWH-BWKEY = MBEW-BWKEY | ECC + S/4 |
| MSEG | Goods movements in the periods: quantity, value, movement type | Read | MSEG-MATNR = MBEW-MATNR AND MSEG-WERKS = MBEW-BWKEY | ECC + S/4 |
| MKPF | Posting date of the material document | Read | MKPF-MBLNR = MSEG-MBLNR AND MKPF-MJAHR = MSEG-MJAHR | ECC + S/4 |
| T156 | Movement type attributes (for receipt/issue grouping) | Read | T156-BWART = MSEG-BWART | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = MBEW-MATNR | ECC + S/4 |
| MATDOC | Material documents on S/4HANA instead of MSEG/MKPF | Read | MATDOC-MATNR = MBEW-MATNR | S/4HANA only |
| ACDOCA | Stock value changes without goods movements on S/4HANA | Read | ACDOCA-MATNR = MBEW-MATNR | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_BWKEY | Valuation area | Range / multiple | MBEW-BWKEY | Yes |
| S_MATNR | Material | Range / multiple | MBEW-MATNR | No |
| S_BKLAS | Valuation class | Range / multiple | MBEW-BKLAS | No |
| P_GJAHR | Fiscal year | Single value | MBEWH-LFGJA | Yes |
| P_PERFR | From period | Single value | MBEWH-LFMON | Yes |
| P_PERTO | To period | Single value | MBEWH-LFMON | Yes |
| P_DIFF | Only materials with a difference | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Valuation area | MBEW-BWKEY |
| Material | MBEW-MATNR |
| Description | MAKT-MAKTX |
| Valuation class | MBEW-BKLAS |
| Opening quantity | MBEWH-LBKUM |
| Opening value | MBEWH-SALK3 |
| Receipt quantity | Calculated: Σ MSEG-MENGE, receipt movement types |
| Receipt value | Calculated: Σ MSEG-DMBTR, receipt movement types |
| Issue quantity | Calculated: Σ MSEG-MENGE, issue movement types |
| Issue value | Calculated: Σ MSEG-DMBTR, issue movement types |
| Closing quantity | Calculated: MBEWH-LBKUM for the end period; MBEW-LBKUM if there is no record |
| Closing value | Calculated: MBEWH-SALK3 for the end period; MBEW-SALK3 if there is no record |
| Quantity difference | Calculated: Opening + receipts − issues − closing (quantity) |
| Value difference | Calculated: Opening + receipts − issues − closing (value) |

## How does the report work?

1. Materials are selected by valuation area (MBEW-BWKEY, usually the plant), material and valuation class (BKLAS).
2. Opening quantity and value are the values at the end of the period before the start period: the first MBEWH record for that period or later (LBKUM, SALK3) is taken; if there is none, the current value in MBEW is used. Closing values are found with the same rule for the end period.
3. Movements in the periods are read from MSEG/MKPF by posting date (MKPF-BUDAT). Movement types are split by a settings list into receipts (purchasing 101, production receipt 101 with order, returns) and issues (consumption for production 261, sales 601, issue to cost center 201, scrap 551, plant-to-plant transfer); reversals fall into the same group with the opposite sign.
4. Quantity comes from MSEG-MENGE and value from MSEG-DMBTR; the debit/credit indicator (SHKZG) decides receipt or issue. Storage location transfers within the same valuation area (311) are left out because they do not change value.
5. Difference = opening + receipts − issues − closing. The quantity difference is normally zero; a value difference comes from postings that change stock value without a goods movement (price change, invoice difference posted to stock, material ledger closing).
6. On S/4HANA movements can be read from MATDOC and values from the material ledger and ACDOCA; the report structure does not change.

## Authorization objects

- M_MSEG_WMB: Material document display authorization by plant
- M_MATE_WRK: Authorization to display material and valuation data by plant

## Frequently asked questions

### Why does the quantity reconcile but the value does not?

A value difference comes from postings that change stock value without a goods movement: a material price change, a price difference posted to stock at invoice, or the material ledger period closing. The report shows this difference in a separate column; to find its source, accounting documents outside material documents can also be listed.

### Can the movement type groups be changed?

Yes. Which movement type falls into which receipt or issue group is kept in a settings list. The company's own movement types are added during setup.

### Does it work on S/4HANA?

Yes. MSEG, MKPF and MBEWH can be read as compatibility views on S/4HANA; for better performance movements are read directly from MATDOC. Value differences can be explained with the material lines in ACDOCA.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=co-material-quantity-reconciliation
