Now accepting guest editorial from SAP, Oracle, Workday and ServiceNow practitioners.Pitch a guide
The Sign-Off Table

Lesson 4 of 6

Reading stock overviews and reservations

9 min

"How many rotors do we have?" sounds like one question. In SAP it is several: how many are in plant 1710 or 1720, in which storage location, in which stock type, how many are reserved, how many are on the way, and what are they worth. Stock reports answer each question differently, and knowing which one to use saves arguments.

The main stock reports

Report or appAnswersNotes
MMBE (stock overview)Stock of one product across company code, plant, storage location and stock typesThe classic quick look; shows special stocks too
Stock - Single Material (Fiori)Stock of one product by plant, storage location and stock type, with historyIncludes a chart of stock over time
Stock - Multiple Materials (Fiori)Stock for many products at onceGood for cycle counting and review
MB52 (warehouse stocks)Stock and value per product and storage locationLists many products; can show values
MB5B (stock on posting date)Stock and value at a past dateUsed for period-end and audit questions
MB51 / Material Documents OverviewWhich movements happenedThe audit trail behind every stock figure
MD04 (stock/requirements list)Stock plus incoming and outgoing quantities over timeThe planner's view; includes reservations and POs

Which report answers which stock question.

Company code 1710Total CMC-RTR-200: 1,850
Plant 1710 Detroit1,600
Storage location 171A1,200: unrestricted 1,000 · quality inspection 150 · blocked 50
Storage location 171B400 unrestricted
Plant 1720 Chicago250 in 172A unrestricted
Stock of CMC-RTR-200 as MMBE presents it, from company code down to stock type.
The Sign-Off Table · thesignofftable.com/academy/sap-mm-203

Stock types and availability

Only unrestricted-use stock is free to be used. Quality inspection and blocked stock are on hand and valuated, but not available. When a planner says "we have 1,200 in 171A" and production says "we can only use 1,000", they are both right. Always state the stock type.

Reservations: on hand but promised

A reservation is a request to keep stock ready for a future withdrawal. Production orders create reservations for their components automatically; users can create manual reservations (for example, for a maintenance job). Reserved stock still sits in unrestricted use, but it is promised. Availability checks and MRP treat reservations as requirements, so stock can be on hand while not being available for a new order.

  1. Stock1,000 rotors unrestricted in 171A
  2. ReservationsProduction orders for CMC-ALT-100 reserve 800 rotors for next week
  3. AvailabilityOnly 200 remain for other demand, depending on the checking rule
  4. New requestAn engineering request for 300 rotors fails the availability check
  5. Goods issueIssuing against a reservation reduces both stock and the reservation
Why on-hand stock and available stock are not the same thing.
The Sign-Off Table · thesignofftable.com/academy/sap-mm-203

Quantity versus value

Stock overviews show quantities; finance cares about value. For a product with standard price, value is quantity times standard price per plant: 1,600 rotors in plant 1710 at $40 is $64,000. MB52 and MB5B can show values, and the inventory G/L account balance should match the sum of product stock values for that valuation class. That match is one of the most important inventory reconciliations.

Total, nowMB52 or Stock - Multiple Materials for current totals
Detailed, nowMMBE or Stock - Single Material for one product by location and type
Total, pastMB5B for stock and value at a posting date
Detailed, pastMB51 / Material Documents Overview for each movement
Picking the right stock report.
The Sign-Off Table · thesignofftable.com/academy/sap-mm-203

What would you do?

Production says there are not enough rotors for tomorrow, but MMBE shows 1,200 in 171A. What is the best explanation to check?

Key points
  • Use MMBE or Stock - Single Material for one product; MB52 for many; MB5B for the past; MB51 for movements.
  • Only unrestricted-use stock is available; inspection and blocked stock are on hand but not usable.
  • Reservations promise stock, so availability can be lower than on-hand stock.
  • Stock value per valuation class should reconcile with the inventory G/L balance.

Check your understanding · not graded

Lesson check

  1. 1. Which transaction gives a quick stock overview of one product across plants and stock types?

  2. 2. Which report shows stock at a past posting date?

  3. 3. Why can on-hand stock be higher than available stock?

  4. 4. Which report lists the individual movements behind a stock figure?