# Materials Below Safety Stock with Open Purchase Order Coverage Report

> A custom ALV report that lists materials whose stock has fallen below safety stock or the reorder point, and shows whether the shortage is covered by open purchase orders and requisitions. Planners see in one list which material is not covered at all and when the earliest delivery is due.

- Type: Report, Custom development, ALV report
- Module: MM
- Estimated effort: M (4–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/materials-below-safety-stock-open-po-coverage-report/


## Why is the standard not enough?

MB52 shows stock, and MD04 shows the stock and requirements of one material at a time. MD07 gives a collective view but focuses on exception messages and does not subtract open order and requisition quantities from the safety stock shortage to show the net coverage with the earliest delivery date on one line. Planners check critical materials one by one in MD04 every morning.

### Closest standard alternatives

- MD04: Shows stock and requirements of one material in detail; gives no net coverage list for many materials.
- MB52: Lists warehouse stock; no comparison with safety stock, open orders or requisitions.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| MARC | Safety stock, reorder point, MRP controller and planned delivery time (driving table) | Read | - | ECC + S/4 |
| MARD | Unrestricted stock per storage location | Read | MARD-MATNR = MARC-MATNR AND MARD-WERKS = MARC-WERKS | ECC + S/4 |
| MARA | Material type and base unit | Read | MARA-MATNR = MARC-MATNR | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = MARC-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| EKPO | Open order items (not deleted, not delivery completed) | Read | EKPO-MATNR = MARC-MATNR AND EKPO-WERKS = MARC-WERKS | ECC + S/4 |
| EKET | Open quantity and delivery date | Read | EKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELP | ECC + S/4 |
| EBAN | Requisition quantity not yet ordered | Read | EBAN-MATNR = MARC-MATNR AND EBAN-WERKS = MARC-WERKS | ECC + S/4 |
| MARM | Conversion from order unit to base unit | Read | MARM-MATNR = EKPO-MATNR AND MARM-MEINH = EKPO-MEINS | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | MARC-WERKS | Yes |
| S_MATNR | Material | Range / multiple | MARC-MATNR | No |
| S_DISPO | MRP controller | Range / multiple | MARC-DISPO | No |
| S_EKGRP | Purchasing group | Range / multiple | MARC-EKGRP | No |
| S_MTART | Material type | Range / multiple | MARA-MTART | No |
| S_LGORT | Storage location | Range / multiple | MARD-LGORT | No |
| P_INCPR | Include open requisitions in coverage | Checkbox | - | No |
| P_UNCOV | Uncovered only | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Material | MARC-MATNR |
| Description | MAKT-MAKTX |
| Plant | MARC-WERKS |
| MRP controller | MARC-DISPO |
| Purchasing group | MARC-EKGRP |
| Unit | MARA-MEINS |
| Unrestricted stock | Calculated: Σ MARD-LABST |
| Safety stock | MARC-EISBE |
| Reorder point | MARC-MINBE |
| Shortage | Calculated: Threshold (MINBE, else EISBE) − unrestricted stock |
| Open PO qty | Calculated: Σ (EKET-MENGE − EKET-WEMNG), in base unit |
| Open PR qty | Calculated: Σ (EBAN-MENGE − EBAN-BSMNG) |
| Net coverage | Calculated: Unrestricted stock + open PO qty + open PR qty − threshold |
| Earliest delivery | EKET-EINDT |
| Planned delivery time (days) | MARC-PLIFZ |
| Status | Calculated: Red / yellow / green: net coverage and earliest delivery compared with today + PLIFZ |

## How does the report work?

1. MARC is read by plant, MRP controller and purchasing group; materials with safety stock (EISBE) or reorder point (MINBE) above zero and no deletion flag (LVORM) remain.
2. Unrestricted stock = Σ MARD-LABST over storage locations (with an optional storage location filter).
3. Threshold = MINBE if a reorder point is maintained, otherwise EISBE. Shortage = threshold − stock; materials without a shortage are skipped.
4. The open order quantity is summed from EKPO/EKET (EKET-MENGE − EKET-WEMNG on items that are not deleted or delivery completed) and the earliest EKET-EINDT is taken; a different order unit is converted to the base unit with the MARM factors. Optionally, the open requisition quantity from EBAN (MENGE − BSMNG) is added.
5. Net coverage = stock + open orders + open requisitions − threshold. Status: red (not covered), yellow (covered only by requisitions or after the planned delivery time), green (covered by orders in time).

## Authorization objects

- M_MTDI_ORG: MRP display authorization by plant and MRP controller
- M_BEST_WRK: Purchase order display authorization by plant
- M_BANF_WRK: Requisition display authorization by plant

## Frequently asked questions

### Is quality inspection or blocked stock counted?

By default only unrestricted stock (MARD-LABST) is used. Quality inspection stock (MARD-INSME) can be added with a separate option if needed.

### Are reservations and sales order requirements subtracted?

The base version focuses on the safety stock shortage and does not subtract requirements. If reservations (RESB) or sales requirements should be subtracted as well, the scope and effort increase.

### Does this report work on S/4HANA?

Yes. In S/4HANA the MARD stock quantities are read from MATDOC through a compatibility view, and the report keeps using the same fields. For clean core, stock can be read with I_StockQuantityCurrentValue_2.

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