MM Report Custom development ALV report

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

  • MD04 Display Stock/Requirements Situation. Shows stock and requirements of one material in detail; gives no net coverage list for many materials.
  • MB52 List of Warehouse Stocks on Hand. Lists warehouse stock; no comparison with safety stock, open orders or requisitions.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
MARCPlant Data for MaterialSafety stock, reorder point, MRP controller and planned delivery time (driving table)—ECC + S/4
MARDStorage Location Data for MaterialUnrestricted stock per storage locationMARD-MATNR = MARC-MATNR AND MARD-WERKS = MARC-WERKSECC + S/4
MARAGeneral Material DataMaterial type and base unitMARA-MATNR = MARC-MATNRECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = MARC-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
EKPOPurchasing Document ItemOpen order items (not deleted, not delivery completed)EKPO-MATNR = MARC-MATNR AND EKPO-WERKS = MARC-WERKSECC + S/4
EKETPurchasing Schedule LinesOpen quantity and delivery dateEKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELPECC + S/4
EBANPurchase RequisitionRequisition quantity not yet orderedEBAN-MATNR = MARC-MATNR AND EBAN-WERKS = MARC-WERKSECC + S/4
MARMUnits of Measure for MaterialConversion from order unit to base unitMARM-MATNR = EKPO-MATNR AND MARM-MEINH = EKPO-MEINSECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multipleMARC-WERKSYes1000
S_MATNRMaterialRange / multipleMARC-MATNRNoRM-1001
S_DISPOMRP controllerRange / multipleMARC-DISPONo001
S_EKGRPPurchasing groupRange / multipleMARC-EKGRPNo001
S_MTARTMaterial typeRange / multipleMARA-MTARTNoROH
S_LGORTStorage locationRange / multipleMARD-LGORTNo0001
P_INCPRInclude open requisitions in coverageCheckbox—NoX
P_UNCOVUncovered onlyCheckbox—No—

Output columns

#ColumnSource
1MaterialMARC-MATNR
2DescriptionMAKT-MAKTX
3PlantMARC-WERKS
4MRP controllerMARC-DISPO
5Purchasing groupMARC-EKGRP
6UnitMARA-MEINS
7Unrestricted stockCalculated Σ MARD-LABST
8Safety stockMARC-EISBE
9Reorder pointMARC-MINBE
10ShortageCalculated Threshold (MINBE, else EISBE) − unrestricted stock
11Open PO qtyCalculated Σ (EKET-MENGE − EKET-WEMNG), in base unit
12Open PR qtyCalculated Σ (EBAN-MENGE − EBAN-BSMNG)
13Net coverageCalculated Unrestricted stock + open PO qty + open PR qty − threshold
14Earliest deliveryEKET-EINDT
15Planned delivery time (days)MARC-PLIFZ
16StatusCalculated Red / yellow / green: net coverage and earliest delivery compared with today + PLIFZ

Sample output

MaterialDescriptionPlantMRP controllerPurchasing groupUnitUnrestricted stockSafety stockReorder pointShortageOpen PO qtyOpen PR qtyNet coverageEarliest deliveryPlanned delivery time (days)Status
RM-1001Carton box 40x301000001001PC1,2002,0003,0001,8005,00003,20011/21/202610Green
RM-2040Steel sheet 2 mm1000002001KG3501,000065001,50085021Yellow
SP-7720Bearing 62051000003002PC42001600-1614Red
RM-3105Solvent-based paint1000001001L80200250170300013012/08/20267Yellow
A view built with fictional sample data; not real system data.

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

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

MM Package Custom

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 …

5 components · v1.0

Related reports

MM Report Standard ALV report

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 …

MARD · MARA · MAKT · MBEW

MM Report Custom ALV report

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 …

EKKO · EKPO · EKET · LFA1

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.

Related report: Materials Below Safety Stock with Open Purchase Order Coverage Report