Physical Inventory Count Differences and Recount Analysis Report by Material and Storage Location
Short answer: 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.
- Estimated effort
- M · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
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.
Who uses it? Warehouse managers, inventory controllers, cost accounting and internal audit.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| IKPFPhysical Inventory Document Header | Inventory document header: plant, storage location, count and posting date (driving table) | — | ECC + S/4 |
| ISEGPhysical Inventory Document Items | Inventory item: book and counted quantity, difference value, recount document | ISEG-IBLNR = IKPF-IBLNR AND ISEG-GJAHR = IKPF-GJAHR | ECC + S/4 |
| MARAGeneral Material Data | Material group and type | MARA-MATNR = ISEG-MATNR | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = ISEG-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| MBEWMaterial Valuation | Price for valuing unposted differences | MBEW-MATNR = ISEG-MATNR AND MBEW-BWKEY = T001W-BWKEY | ECC + S/4 |
| T001WPlants/Branches | Plant to valuation area mapping | T001W-WERKS = ISEG-WERKS | ECC + S/4 |
| I_PhysInvtryDocItemPhysical Inventory Document Item | CDS view that can replace ISEG in S/4HANA | PhysicalInventoryDocument = ISEG-IBLNR | S/4HANA only |
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.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | ISEG-WERKS | Yes | 1000 |
| S_LGORT | Storage location | Range / multiple | ISEG-LGORT | No | 0001 |
| S_MATNR | Material | Range / multiple | ISEG-MATNR | No | RM-1001 |
| S_MATKL | Material group | Range / multiple | MARA-MATKL | No | 01 |
| S_ZLDAT | Count date range | Range / multiple | IKPF-ZLDAT | Yes | 01.01.2026 – 31.10.2026 |
| P_MINVAL | Minimum absolute difference value | Single value | — | No | 1000 |
| P_REPEAT | Repeat difference threshold (number of counts) | Single value | — | No | 2 |
| P_POSTED | Posted differences only | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Plant | ISEG-WERKS |
| 2 | Storage location | ISEG-LGORT |
| 3 | Material | ISEG-MATNR |
| 4 | Material description | MAKT-MAKTX |
| 5 | Material group | MARA-MATKL |
| 6 | Inventory document | ISEG-IBLNR |
| 7 | Count date | IKPF-ZLDAT |
| 8 | Book quantity | ISEG-BUCHM |
| 9 | Counted quantity | ISEG-MENGE |
| 10 | Difference qty | Calculated ISEG-MENGE − ISEG-BUCHM |
| 11 | Unit | ISEG-MEINS |
| 12 | Difference value | Calculated ISEG-DMBTR (signed) if posted; otherwise difference qty × MBEW price ÷ MBEW-PEINH |
| 13 | Difference % | Calculated Difference qty ÷ ISEG-BUCHM × 100 |
| 14 | Recount document | ISEG-NBLNR |
| 15 | Counts with difference | Calculated Number of counts in the period with a non-zero difference for the same material and storage location |
| 16 | Repeat difference | Calculated X if counts with difference ≥ threshold |
Sample output
| Plant | Storage location | Material | Material description | Material group | Inventory document | Count date | Book quantity | Counted quantity | Difference qty | Unit | Difference value | Difference % | Recount document | Counts with difference | Repeat difference |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | 0001 | RM-1002 | Stretch film 50 cm | 01 | 0100002315 | 10/28/2026 | 1,450 | 1,385 | -65 | KG | -2,502.50 | -4.50 | 3 | X | |
| 1000 | 0002 | PK-1180 | Packing tape 45 mm | 02 | 0100002316 | 10/28/2026 | 3,200 | 3,020 | -180 | PC | -1,188 | -5.60 | 0100002331 | 2 | X |
| 1000 | 0001 | RM-2040 | Steel sheet 2 mm | 03 | 0100002315 | 10/28/2026 | 820 | 836 | 16 | KG | 979.20 | 2 | 1 | ||
| 2000 | 0005 | CH-0315 | Solvent-based paint | 04 | 0100002340 | 10/30/2026 | 410 | 372 | -38 | L | -5,396 | -9.30 | 4 | X |
How does the report work?
- IKPF is read by plant, storage location and count date (ZLDAT).
- ISEG items are read; items not counted (XZAEL blank) and deleted items (XLOEK) are skipped. Difference quantity = counted quantity (MENGE) − book quantity (BUCHM).
- 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.
- 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.
- 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.
Performance notes
Restrict IKPF by count date and plant; read ISEG with a JOIN on the IBLNR/GJAHR key. Read the MBEW price only for unposted differences via FOR ALL ENTRIES. For yearly analyses a background job is recommended.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the inventory document opens MI03; double-clicking the material opens MI24.
- Export to Excel
- Runs as a background job
- Send the result by email Repeat differences can be sent to warehouse and cost managers at month end.
Authorization objects
- M_ISEG_WIBPhysical inventory document display authorization by plant
- M_ISEG_WDBPlant authorization related to difference posting (viewing difference values)
- M_MATE_WRKMaterial 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).
Packages that include this solution
Physical Inventory Count and Difference Pack
A four-component pack that runs a count campaign from start to finish: storage bins due for counting, bulk entry of count results from handheld …
Related reports
MB52 – List of Warehouse Stocks on Hand
MB52 is the standard SAP report (program RM07MLBS) that lists current material stocks per plant and storage location by stock type, together with …
Stock Aging Report
A custom ALV report that shows how many days each material has been in stock since its last goods receipt and which age bucket (0–30, 31–90, 91–180, …
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.