Stock Aging Report
Short answer: 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, 180+ days) its stock value falls into. It makes slow-moving and dead stock visible together with its value.
- Estimated effort
- M · 4–7 working days
- System
- ECC and S/4HANA
- Tables
- 8
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
MB52 gives current stock and value but not stock age. MC50 and MC46 analyze non-moving stock, but their results depend on up-to-date LIS information structures and do not split value into age buckets. Aging is usually done by merging a stock list with material movements in Excel.
Who uses it? Warehouse managers, inventory controllers, cost accounting and finance teams.
Closest standard alternatives
- MB52 List of Warehouse Stocks on Hand. Gives current stock and value; no last receipt date and no stock age.
- MC50 Dead Stock Analysis. Analyzes non-moving stock; does not split value into age buckets and depends on LIS updates.
- MB5B Stocks for Posting Date. Gives stock at a past date; does not show how long a material has been waiting.
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 | Unrestricted stock per plant and storage location (driving table) | — | ECC + S/4 |
| MARAGeneral Material Data | Material type, material group and base unit | MARA-MATNR = MARD-MATNR | ECC + S/4 |
| MAKTMaterial Descriptions | Material description in the logon language | MAKT-MATNR = MARD-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| MBEWMaterial Valuation | Unit price for stock value | MBEW-MATNR = MARD-MATNR AND MBEW-BWKEY = değerleme alanı (üretim yeri) | ECC + S/4 |
| MKPFMaterial Document Header | Posting date of the goods receipt | MKPF-MBLNR = MSEG-MBLNR AND MKPF-MJAHR = MSEG-MJAHR | ECC only |
| MSEGMaterial Document Item | Receipt movements (movement type, material, storage location) | MSEG-MATNR = MARD-MATNR AND MSEG-WERKS = MARD-WERKS AND MSEG-LGORT = MARD-LGORT | ECC only |
| MATDOCMaterial Documents (S/4HANA) | In S/4HANA, receipt movements and posting date in one table | MATDOC-MATNR = MARD-MATNR AND MATDOC-WERKS = MARD-WERKS AND MATDOC-LGORT = MARD-LGORT | S/4HANA only |
| I_MaterialDocumentItem_2Material Document Item (CDS) | In S/4HANA it can replace MATDOC with a clean core approach | Material = MARD-MATNR AND Plant = MARD-WERKS | S/4HANA only |
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.
- MKPF → MATDOC: In S/4HANA new material documents are written to MATDOC; reading MKPF works through a compatibility view. Use MATDOC or I_MaterialDocumentItem_2 directly in new reports.
- MSEG → MATDOC: In S/4HANA MATDOC replaces MSEG; reading MSEG works through a compatibility view but is slow at high volumes.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | MARD-WERKS | Yes | 1000 |
| S_LGORT | Storage location | Range / multiple | MARD-LGORT | No | 0001 |
| S_MATNR | Material | Range / multiple | MARD-MATNR | No | RM-1001 |
| S_MTART | Material type | Range / multiple | MARA-MTART | No | ROH |
| S_MATKL | Material group | Range / multiple | MARA-MATKL | No | 01 |
| P_KEYDT | Key date for the age calculation (default: today) | Single value | SY-DATUM | Yes | 16.11.2026 |
| P_BKT1 | Bucket 1 upper limit (days) | Single value | — | No | 30 |
| P_BKT2 | Bucket 2 upper limit (days) | Single value | — | No | 90 |
| P_BKT3 | Bucket 3 upper limit (days) | Single value | — | No | 180 |
| P_NOZERO | Hide zero stock | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Plant | MARD-WERKS |
| 2 | Storage loc. | MARD-LGORT |
| 3 | Material | MARD-MATNR |
| 4 | Description | MAKT-MAKTX |
| 5 | Material type | MARA-MTART |
| 6 | Unrestricted | MARD-LABST |
| 7 | Unit | MARA-MEINS |
| 8 | Unit price | Calculated MBEW-STPRS if MBEW-VPRSV = S, MBEW-VERPR if V; ÷ MBEW-PEINH |
| 9 | Stock value | Calculated Unrestricted stock × unit price |
| 10 | Last receipt | Calculated Latest posting date of receipt movement types (ECC: MKPF-BUDAT, S/4HANA: MATDOC-BUDAT) |
| 11 | Age (days) | Calculated Key date − last receipt date |
| 12 | Age bucket | Calculated Bucket of the age by the P_BKT1, P_BKT2, P_BKT3 limits |
Sample output
| Plant | Storage loc. | Material | Description | Material type | Unrestricted | Unit | Unit price | Stock value | Last receipt | Age (days) | Age bucket |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | 0001 | RM-1001 | Carton box 40x30 | ROH | 2,000 | PC | 4.25 | 8,500 | 10/28/2026 | 19 | 0–30 |
| 1000 | 0001 | RM-2040 | Steel sheet 2 mm | ROH | 350 | KG | 61.20 | 21,420 | 06/02/2026 | 167 | 91–180 |
| 1000 | 0002 | FG-5001 | Packed product A | FERT | 120 | PC | 310 | 37,200 | 09/14/2025 | 428 | 180+ |
| 2000 | 0001 | RM-3105 | Solvent-based paint | ROH | 80 | L | 142 | 11,360 | 08/20/2026 | 88 | 31–90 |
How does the report work?
- Unrestricted-use stock is read from MARD for the selection; with “Hide zero stock” selected, lines without stock are skipped.
- Material type and base unit come from MARA, and the description in the logon language from MAKT.
- The unit price comes from MBEW: standard price (STPRS) when price control is S, moving average price (VERPR) when it is V, divided by the price unit (PEINH).
- The last goods receipt date is the latest posting date per material + plant + storage location for receipt movement types (e.g. 101, 501, 561). It is read from MKPF/MSEG in ECC and from MATDOC or I_MaterialDocumentItem_2 in S/4HANA.
- Age = key date − last receipt date. The age is assigned to a bucket using the limits on the selection screen.
Performance notes
In ECC, MSEG can be very large. Find the last receipt date in one aggregated query (MAX posting date per material + plant + storage location) and restrict movement types. In S/4HANA, push the aggregation down to the database on MATDOC or the CDS view.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the material opens the MMBE stock overview.
- Export to Excel
- Runs as a background job Can run automatically at month-end close.
Authorization objects
- M_MSEG_WMBMaterial document display authorization by plant
- M_MATE_WRKMaterial master authorization by plant
Frequently asked questions
How is stock age calculated?
In this template, age is the number of days since the last goods receipt into the storage location. If needed, each receipt lot can be aged separately with FIFO logic; that increases the effort range.
What changes on S/4HANA?
Goods movements live in MATDOC instead of MKPF/MSEG, and MARD stock quantities are calculated on the fly from MATDOC. Written on MATDOC or I_MaterialDocumentItem_2, the report is both faster and clean-core friendly.
Can the age buckets be changed?
Yes. The bucket limits are selection-screen parameters; each team can save its own limits as a variant.
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 …
Open Purchase Orders by Vendor Report
A custom ALV report that shows, per vendor, the quantity not yet received, the open order value and the days of delay since the delivery date in a …
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.