MM Report Standard SAP ALV report

MB52 — List of Warehouse Stocks on Hand

Short answer: MB52 is the standard SAP report (program RM07MLBS) that lists current material stocks per plant and storage location by stock type, together with their values. It is one of the most used reports for daily stock control.

Estimated effort
S · 1–3 working days
System
ECC and S/4HANA
Tables
4
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

How can we extend this report?

MB52 can be extended without modifying it: a custom version can add last receipt date and stock age, ABC class, shelf-life expiry date or a weekly automatic email. The standard program is not changed; a separate report reads the same data.

Who uses it? Warehouse teams, inventory controllers and production planning.

Program: RM07MLBS

Tables used

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

TableRoleJoinSystem
MARDStorage Location Data for MaterialStock quantities per storage location (driving table)—ECC + S/4
MARAGeneral Material DataMaterial type, group and base unitMARA-MATNR = MARD-MATNRECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = MARD-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
MBEWMaterial ValuationPrice for stock valueMBEW-MATNR = MARD-MATNR AND MBEW-BWKEY = değerleme alanı (üretim yeri)ECC + S/4

S/4HANA notes

  • MARD → MATDOC: In S/4HANA stock quantities are no longer stored physically; reading MARD returns values calculated on the fly from MATDOC through a compatibility view. Reads still work, but test performance on very large selections.
  • 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
MATNRMaterialRange / multipleMARD-MATNRNoRM-1001
WERKSPlantRange / multipleMARD-WERKSNo1000
LGORTStorage locationRange / multipleMARD-LGORTNo0001
CHARGBatchRange / multipleMCHB-CHARGNoB2026-10
MTARTMaterial typeRange / multipleMARA-MTARTNoROH
MATKLMaterial groupRange / multipleMARA-MATKLNo01
NOZERONo zero stock linesCheckbox—NoX
NOVALUENo valuesCheckbox—No—

Output columns

#ColumnSource
1MaterialMARD-MATNR
2PlantMARD-WERKS
3Storage loc.MARD-LGORT
4DescriptionMAKT-MAKTX
5UnitMARA-MEINS
6UnrestrictedMARD-LABST
7Value unrestrictedCalculated Unrestricted stock × MBEW price ÷ price unit
8In quality insp.MARD-INSME
9BlockedMARD-SPEME

Sample output

MaterialPlantStorage loc.DescriptionUnitUnrestrictedValue unrestrictedIn quality insp.Blocked
RM-100110000001Carton box 40x30PC2,0008,50000
RM-204010000001Steel sheet 2 mmKG35021,420500
FG-500110000002Packed product APC12037,200020
A view built with fictional sample data; not real system data.

How does the report work?

  1. Storage location stocks are read from MARD for the selection (batch stocks are read separately for batch-managed materials).
  2. Material type, group and base unit come from MARA, the description from MAKT.
  3. Unless “No values” is selected, the stock value is calculated with the price in MBEW.
  4. The result is shown in ALV with a separate column for each stock type (unrestricted, quality inspection, blocked).

Performance notes

With many plants selected, value calculation increases run time; use "No values" when only quantities are needed.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Export to Excel
  • Runs as a background job

Frequently asked questions

Does MB52 show stock at a past date?

No. MB52 shows current stock only. For stock at a past posting date, use MB5B.

Can new columns be added to MB52?

Modifying the standard program is not recommended. A separate custom report that reads the same tables and adds the wanted columns (e.g. last receipt date, stock age) is safer and unaffected by upgrades.

Related reports

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 extend this report for your needs

Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.

Related report: MB52 – List of Warehouse Stocks on Hand