MM Report Custom development ALV report

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

  • MI20 Print List of Differences. Lists differences in inventory documents; no repeat-difference count or period totals.
  • MI24 Physical Inventory List. Shows inventory documents per material; offers no value analysis or recount chain.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
IKPFPhysical Inventory Document HeaderInventory document header: plant, storage location, count and posting date (driving table)—ECC + S/4
ISEGPhysical Inventory Document ItemsInventory item: book and counted quantity, difference value, recount documentISEG-IBLNR = IKPF-IBLNR AND ISEG-GJAHR = IKPF-GJAHRECC + S/4
MARAGeneral Material DataMaterial group and typeMARA-MATNR = ISEG-MATNRECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = ISEG-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
MBEWMaterial ValuationPrice for valuing unposted differencesMBEW-MATNR = ISEG-MATNR AND MBEW-BWKEY = T001W-BWKEYECC + S/4
T001WPlants/BranchesPlant to valuation area mappingT001W-WERKS = ISEG-WERKSECC + S/4
I_PhysInvtryDocItemPhysical Inventory Document ItemCDS view that can replace ISEG in S/4HANAPhysicalInventoryDocument = ISEG-IBLNRS/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

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multipleISEG-WERKSYes1000
S_LGORTStorage locationRange / multipleISEG-LGORTNo0001
S_MATNRMaterialRange / multipleISEG-MATNRNoRM-1001
S_MATKLMaterial groupRange / multipleMARA-MATKLNo01
S_ZLDATCount date rangeRange / multipleIKPF-ZLDATYes01.01.2026 – 31.10.2026
P_MINVALMinimum absolute difference valueSingle value—No1000
P_REPEATRepeat difference threshold (number of counts)Single value—No2
P_POSTEDPosted differences onlyCheckbox—No—

Output columns

#ColumnSource
1PlantISEG-WERKS
2Storage locationISEG-LGORT
3MaterialISEG-MATNR
4Material descriptionMAKT-MAKTX
5Material groupMARA-MATKL
6Inventory documentISEG-IBLNR
7Count dateIKPF-ZLDAT
8Book quantityISEG-BUCHM
9Counted quantityISEG-MENGE
10Difference qtyCalculated ISEG-MENGE − ISEG-BUCHM
11UnitISEG-MEINS
12Difference valueCalculated ISEG-DMBTR (signed) if posted; otherwise difference qty × MBEW price ÷ MBEW-PEINH
13Difference %Calculated Difference qty ÷ ISEG-BUCHM × 100
14Recount documentISEG-NBLNR
15Counts with differenceCalculated Number of counts in the period with a non-zero difference for the same material and storage location
16Repeat differenceCalculated X if counts with difference ≥ threshold

Sample output

PlantStorage locationMaterialMaterial descriptionMaterial groupInventory documentCount dateBook quantityCounted quantityDifference qtyUnitDifference valueDifference %Recount documentCounts with differenceRepeat difference
10000001RM-1002Stretch film 50 cm01010000231510/28/20261,4501,385-65KG-2,502.50-4.503X
10000002PK-1180Packing tape 45 mm02010000231610/28/20263,2003,020-180PC-1,188-5.6001000023312X
10000001RM-2040Steel sheet 2 mm03010000231510/28/202682083616KG979.2021
20000005CH-0315Solvent-based paint04010000234010/30/2026410372-38L-5,396-9.304X
A view built with fictional sample data; not real system data.

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.

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

WM Package Custom

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 …

4 components · v1.0

Related reports

MM Report Standard ALV report

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 …

MARD · MARA · MAKT · MBEW

MM Report Custom ALV report

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, …

MARD · MARA · MAKT · MBEW

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.

Related report: Physical Inventory Count Differences and Recount Analysis Report by Material and Storage Location