# Physical Inventory Count Differences and Recount Analysis Report by Material and Storage Location

> A custom ALV report that reads all physical inventory documents of a period and shows, per material and storage location, the difference quantity, the difference value, recounts and how many times the same material produced a difference. Warehouse and cost teams easily find the materials and storage locations that keep producing differences.

- Type: Report, Custom development, ALV report
- Module: MM
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/physical-inventory-count-differences-recount-report/


## Why is the standard not enough?

MI20 lists the differences in individual inventory documents and MI24 shows the inventory documents of one material; but neither shows how many times the same material produced a difference within a period, which items went to a recount and the difference value totalled by material group and storage location together. The custom report combines the count history and makes recurring sources of difference visible.

### Closest standard alternatives

- MI20: Lists differences in inventory documents; no repeat-difference count or period totals.
- MI24: Shows inventory documents per material; offers no value analysis or recount chain.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| IKPF | Inventory document header: plant, storage location, count and posting date (driving table) | Read | - | ECC + S/4 |
| ISEG | Inventory item: book and counted quantity, difference value, recount document | Read | ISEG-IBLNR = IKPF-IBLNR AND ISEG-GJAHR = IKPF-GJAHR | ECC + S/4 |
| MARA | Material group and type | Read | MARA-MATNR = ISEG-MATNR | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = ISEG-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| MBEW | Price for valuing unposted differences | Read | MBEW-MATNR = ISEG-MATNR AND MBEW-BWKEY = T001W-BWKEY | ECC + S/4 |
| T001W | Plant to valuation area mapping | Read | T001W-WERKS = ISEG-WERKS | ECC + S/4 |
| I_PhysInvtryDocItem | CDS view that can replace ISEG in S/4HANA | Read | PhysicalInventoryDocument = ISEG-IBLNR | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | ISEG-WERKS | Yes |
| S_LGORT | Storage location | Range / multiple | ISEG-LGORT | No |
| S_MATNR | Material | Range / multiple | ISEG-MATNR | No |
| S_MATKL | Material group | Range / multiple | MARA-MATKL | No |
| S_ZLDAT | Count date range | Range / multiple | IKPF-ZLDAT | Yes |
| P_MINVAL | Minimum absolute difference value | Single value | - | No |
| P_REPEAT | Repeat difference threshold (number of counts) | Single value | - | No |
| P_POSTED | Posted differences only | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Plant | ISEG-WERKS |
| Storage location | ISEG-LGORT |
| Material | ISEG-MATNR |
| Material description | MAKT-MAKTX |
| Material group | MARA-MATKL |
| Inventory document | ISEG-IBLNR |
| Count date | IKPF-ZLDAT |
| Book quantity | ISEG-BUCHM |
| Counted quantity | ISEG-MENGE |
| Difference qty | Calculated: ISEG-MENGE − ISEG-BUCHM |
| Unit | ISEG-MEINS |
| Difference value | Calculated: ISEG-DMBTR (signed) if posted; otherwise difference qty × MBEW price ÷ MBEW-PEINH |
| Difference % | Calculated: Difference qty ÷ ISEG-BUCHM × 100 |
| Recount document | ISEG-NBLNR |
| Counts with difference | Calculated: Number of counts in the period with a non-zero difference for the same material and storage location |
| Repeat difference | Calculated: X if counts with difference ≥ threshold |

## How does the report work?

1. IKPF is read by plant, storage location and count date (ZLDAT).
2. ISEG items are read; items not counted (XZAEL blank) and deleted items (XLOEK) are skipped. Difference quantity = counted quantity (MENGE) − book quantity (BUCHM).
3. If the difference was posted (XDIFF = X), the value comes from ISEG-DMBTR; otherwise it is estimated as difference quantity × MBEW price (VERPR or STPRS depending on VPRSV) ÷ PEINH.
4. If ISEG-NBLNR is filled, the item was sent to a recount; the recount document is shown and the last count in the chain is used.
5. The number of counts with a difference in the period is calculated per material and storage location; if it reaches the threshold on the selection screen, the row is flagged as a "repeat difference". The material group comes from MARA and the description from MAKT.

## Authorization objects

- M_ISEG_WIB: Physical inventory document display authorization by plant
- M_ISEG_WDB: Plant authorization related to difference posting (viewing difference values)
- M_MATE_WRK: Material data authorization by plant

## Frequently asked questions

### How is the value of differences not yet posted calculated?

If the difference has not been posted, ISEG-DMBTR is empty. The difference quantity is then multiplied by the moving average (VERPR) or standard price (STPRS) from MBEW, depending on price control, and divided by the price unit. The value is an estimate; after posting the real value comes from ISEG.

### Are items sent to a recount counted twice?

No. The recount chain is followed via ISEG-NBLNR; only the last count in the chain is included in the difference count and value. The first inventory document stays visible.

### Does the report work on S/4HANA?

Yes. IKPF and ISEG keep the same structure in S/4HANA. For a clean core approach, the CDS views I_PhysInvtryDocHeader and I_PhysInvtryDocItem can be used; difference postings are written to the material document (MATDOC).

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=mm-physical-inventory-differences-recount
