Materials Below Safety Stock with Open Purchase Order Coverage Report
Short answer: 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.
- Estimated effort
- M · 4–5 working days
- System
- ECC and S/4HANA
- Tables
- 8
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
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.
Who uses it? MRP controllers, buyers and warehouse managers.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| MARCPlant Data for Material | Safety stock, reorder point, MRP controller and planned delivery time (driving table) | — | ECC + S/4 |
| MARDStorage Location Data for Material | Unrestricted stock per storage location | MARD-MATNR = MARC-MATNR AND MARD-WERKS = MARC-WERKS | ECC + S/4 |
| MARAGeneral Material Data | Material type and base unit | MARA-MATNR = MARC-MATNR | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = MARC-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| EKPOPurchasing Document Item | Open order items (not deleted, not delivery completed) | EKPO-MATNR = MARC-MATNR AND EKPO-WERKS = MARC-WERKS | ECC + S/4 |
| EKETPurchasing Schedule Lines | Open quantity and delivery date | EKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELP | ECC + S/4 |
| EBANPurchase Requisition | Requisition quantity not yet ordered | EBAN-MATNR = MARC-MATNR AND EBAN-WERKS = MARC-WERKS | ECC + S/4 |
| MARMUnits of Measure for Material | Conversion from order unit to base unit | MARM-MATNR = EKPO-MATNR AND MARM-MEINH = EKPO-MEINS | 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.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | MARC-WERKS | Yes | 1000 |
| S_MATNR | Material | Range / multiple | MARC-MATNR | No | RM-1001 |
| S_DISPO | MRP controller | Range / multiple | MARC-DISPO | No | 001 |
| S_EKGRP | Purchasing group | Range / multiple | MARC-EKGRP | No | 001 |
| S_MTART | Material type | Range / multiple | MARA-MTART | No | ROH |
| S_LGORT | Storage location | Range / multiple | MARD-LGORT | No | 0001 |
| P_INCPR | Include open requisitions in coverage | Checkbox | — | No | X |
| P_UNCOV | Uncovered only | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Material | MARC-MATNR |
| 2 | Description | MAKT-MAKTX |
| 3 | Plant | MARC-WERKS |
| 4 | MRP controller | MARC-DISPO |
| 5 | Purchasing group | MARC-EKGRP |
| 6 | Unit | MARA-MEINS |
| 7 | Unrestricted stock | Calculated Σ MARD-LABST |
| 8 | Safety stock | MARC-EISBE |
| 9 | Reorder point | MARC-MINBE |
| 10 | Shortage | Calculated Threshold (MINBE, else EISBE) − unrestricted stock |
| 11 | Open PO qty | Calculated Σ (EKET-MENGE − EKET-WEMNG), in base unit |
| 12 | Open PR qty | Calculated Σ (EBAN-MENGE − EBAN-BSMNG) |
| 13 | Net coverage | Calculated Unrestricted stock + open PO qty + open PR qty − threshold |
| 14 | Earliest delivery | EKET-EINDT |
| 15 | Planned delivery time (days) | MARC-PLIFZ |
| 16 | Status | Calculated Red / yellow / green: net coverage and earliest delivery compared with today + PLIFZ |
Sample output
| Material | Description | Plant | MRP controller | Purchasing group | Unit | Unrestricted stock | Safety stock | Reorder point | Shortage | Open PO qty | Open PR qty | Net coverage | Earliest delivery | Planned delivery time (days) | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RM-1001 | Carton box 40x30 | 1000 | 001 | 001 | PC | 1,200 | 2,000 | 3,000 | 1,800 | 5,000 | 0 | 3,200 | 11/21/2026 | 10 | Green |
| RM-2040 | Steel sheet 2 mm | 1000 | 002 | 001 | KG | 350 | 1,000 | 0 | 650 | 0 | 1,500 | 850 | 21 | Yellow | |
| SP-7720 | Bearing 6205 | 1000 | 003 | 002 | PC | 4 | 20 | 0 | 16 | 0 | 0 | -16 | 14 | Red | |
| RM-3105 | Solvent-based paint | 1000 | 001 | 001 | L | 80 | 200 | 250 | 170 | 300 | 0 | 130 | 12/08/2026 | 7 | Yellow |
How does the report work?
- 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.
- Unrestricted stock = Σ MARD-LABST over storage locations (with an optional storage location filter).
- Threshold = MINBE if a reorder point is maintained, otherwise EISBE. Shortage = threshold − stock; materials without a shortage are skipped.
- 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.
- 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).
Performance notes
Narrow the MARC selection by plant and MRP controller, and take the MARD, EKET and EBAN totals for the material list in SQL with GROUP BY. For large plants, run the report every morning as a background job and email it to the planners.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the material opens the MD04 stock/requirements list.
- Export to Excel
- Runs as a background job
- Send the result by email Red and yellow lines can be sent to each MRP controller every morning.
Authorization objects
- M_MTDI_ORGMRP display authorization by plant and MRP controller
- M_BEST_WRKPurchase order display authorization by plant
- M_BANF_WRKRequisition 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.
Packages that include this solution
Inventory Control and GR/IR Pack
A five-report pack that tracks stock value and stock accuracy with one plant and storage location selection: stock aging, materials below safety …
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 …
Released Purchase Requisitions Not Yet Converted to Purchase Orders Report
A custom ALV report that lists released purchase requisition items not yet converted to a purchase order, with open quantity, open value and days …
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.