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.
| Table | Role | Join | System |
|---|---|---|---|
| MARDStorage Location Data for Material | Stock quantities per storage location (driving table) | — | ECC + S/4 |
| MARAGeneral Material Data | Material type, group and base unit | MARA-MATNR = MARD-MATNR | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = MARD-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| MBEWMaterial Valuation | Price for stock value | MBEW-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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| MATNR | Material | Range / multiple | MARD-MATNR | No | RM-1001 |
| WERKS | Plant | Range / multiple | MARD-WERKS | No | 1000 |
| LGORT | Storage location | Range / multiple | MARD-LGORT | No | 0001 |
| CHARG | Batch | Range / multiple | MCHB-CHARG | No | B2026-10 |
| MTART | Material type | Range / multiple | MARA-MTART | No | ROH |
| MATKL | Material group | Range / multiple | MARA-MATKL | No | 01 |
| NOZERO | No zero stock lines | Checkbox | — | No | X |
| NOVALUE | No values | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Material | MARD-MATNR |
| 2 | Plant | MARD-WERKS |
| 3 | Storage loc. | MARD-LGORT |
| 4 | Description | MAKT-MAKTX |
| 5 | Unit | MARA-MEINS |
| 6 | Unrestricted | MARD-LABST |
| 7 | Value unrestricted | Calculated Unrestricted stock × MBEW price ÷ price unit |
| 8 | In quality insp. | MARD-INSME |
| 9 | Blocked | MARD-SPEME |
Sample output
| Material | Plant | Storage loc. | Description | Unit | Unrestricted | Value unrestricted | In quality insp. | Blocked |
|---|---|---|---|---|---|---|---|---|
| RM-1001 | 1000 | 0001 | Carton box 40x30 | PC | 2,000 | 8,500 | 0 | 0 |
| RM-2040 | 1000 | 0001 | Steel sheet 2 mm | KG | 350 | 21,420 | 50 | 0 |
| FG-5001 | 1000 | 0002 | Packed product A | PC | 120 | 37,200 | 0 | 20 |
How does the report work?
- Storage location stocks are read from MARD for the selection (batch stocks are read separately for batch-managed materials).
- Material type, group and base unit come from MARA, the description from MAKT.
- Unless “No values” is selected, the stock value is calculated with the price in MBEW.
- 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
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 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.