# 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 their values. It is one of the most used reports for daily stock control.

- Type: Report, Standard SAP, ALV report
- Module: MM
- Estimated effort: S (1–3 working days)
- Last updated: 2026-11-16
- URL: https://nekuhub.com/en/transactions/mb52/


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

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| MARD | Stock quantities per storage location (driving table) | Read | - | ECC + S/4 |
| MARA | Material type, group and base unit | Read | MARA-MATNR = MARD-MATNR | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = MARD-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| MBEW | Price for stock value | Read | MBEW-MATNR = MARD-MATNR AND MBEW-BWKEY = değerleme alanı (üretim yeri) | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| MATNR | Material | Range / multiple | MARD-MATNR | No |
| WERKS | Plant | Range / multiple | MARD-WERKS | No |
| LGORT | Storage location | Range / multiple | MARD-LGORT | No |
| CHARG | Batch | Range / multiple | MCHB-CHARG | No |
| MTART | Material type | Range / multiple | MARA-MTART | No |
| MATKL | Material group | Range / multiple | MARA-MATKL | No |
| NOZERO | No zero stock lines | Checkbox | - | No |
| NOVALUE | No values | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Material | MARD-MATNR |
| Plant | MARD-WERKS |
| Storage loc. | MARD-LGORT |
| Description | MAKT-MAKTX |
| Unit | MARA-MEINS |
| Unrestricted | MARD-LABST |
| Value unrestricted | Calculated: Unrestricted stock × MBEW price ÷ price unit |
| In quality insp. | MARD-INSME |
| Blocked | MARD-SPEME |

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

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

---
Let us extend this report for your needs: https://nekuhub.com/en/request-a-quote/?report=mm-mb52-warehouse-stock
