# 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, 180+ days) its stock value falls into. It makes slow-moving and dead stock visible together with its value.

- Type: Report, Custom development, ALV report
- Module: MM
- Estimated effort: M (4–7 working days)
- Last updated: 2026-11-16
- URL: https://nekuhub.com/en/reports/stock-aging-report/


## 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.

### Closest standard alternatives

- MB52: Gives current stock and value; no last receipt date and no stock age.
- MC50: Analyzes non-moving stock; does not split value into age buckets and depends on LIS updates.
- MB5B: Gives stock at a past date; does not show how long a material has been waiting.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| MARD | Unrestricted stock per plant and storage location (driving table) | Read | - | ECC + S/4 |
| MARA | Material type, material group and base unit | Read | MARA-MATNR = MARD-MATNR | ECC + S/4 |
| MAKT | Material description in the logon language | Read | MAKT-MATNR = MARD-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| MBEW | Unit price for stock value | Read | MBEW-MATNR = MARD-MATNR AND MBEW-BWKEY = değerleme alanı (üretim yeri) | ECC + S/4 |
| MKPF | Posting date of the goods receipt | Read | MKPF-MBLNR = MSEG-MBLNR AND MKPF-MJAHR = MSEG-MJAHR | ECC only |
| MSEG | Receipt movements (movement type, material, storage location) | Read | MSEG-MATNR = MARD-MATNR AND MSEG-WERKS = MARD-WERKS AND MSEG-LGORT = MARD-LGORT | ECC only |
| MATDOC | In S/4HANA, receipt movements and posting date in one table | Read | MATDOC-MATNR = MARD-MATNR AND MATDOC-WERKS = MARD-WERKS AND MATDOC-LGORT = MARD-LGORT | S/4HANA only |
| I_MaterialDocumentItem_2 | In S/4HANA it can replace MATDOC with a clean core approach | Read | Material = MARD-MATNR AND Plant = MARD-WERKS | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | MARD-WERKS | Yes |
| S_LGORT | Storage location | Range / multiple | MARD-LGORT | No |
| S_MATNR | Material | Range / multiple | MARD-MATNR | No |
| S_MTART | Material type | Range / multiple | MARA-MTART | No |
| S_MATKL | Material group | Range / multiple | MARA-MATKL | No |
| P_KEYDT | Key date for the age calculation (default: today) | Single value | SY-DATUM | Yes |
| P_BKT1 | Bucket 1 upper limit (days) | Single value | - | No |
| P_BKT2 | Bucket 2 upper limit (days) | Single value | - | No |
| P_BKT3 | Bucket 3 upper limit (days) | Single value | - | No |
| P_NOZERO | Hide zero stock | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Plant | MARD-WERKS |
| Storage loc. | MARD-LGORT |
| Material | MARD-MATNR |
| Description | MAKT-MAKTX |
| Material type | MARA-MTART |
| Unrestricted | MARD-LABST |
| Unit | MARA-MEINS |
| Unit price | Calculated: MBEW-STPRS if MBEW-VPRSV = S, MBEW-VERPR if V; ÷ MBEW-PEINH |
| Stock value | Calculated: Unrestricted stock × unit price |
| Last receipt | Calculated: Latest posting date of receipt movement types (ECC: MKPF-BUDAT, S/4HANA: MATDOC-BUDAT) |
| Age (days) | Calculated: Key date − last receipt date |
| Age bucket | Calculated: Bucket of the age by the P_BKT1, P_BKT2, P_BKT3 limits |

## How does the report work?

1. Unrestricted-use stock is read from MARD for the selection; with "Hide zero stock" selected, lines without stock are skipped.
2. Material type and base unit come from MARA, and the description in the logon language from MAKT.
3. 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).
4. 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.
5. Age = key date − last receipt date. The age is assigned to a bucket using the limits on the selection screen.

## Authorization objects

- M_MSEG_WMB: Material document display authorization by plant
- M_MATE_WRK: Material 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=mm-stock-aging
