SAP MB51 — Material Document List
Every posting in MIGO creates a material document. MB51 lists them. If a stock figure looks wrong, this is the report that shows you every movement behind it, in order, with who posted it and when.
It is the natural partner to MMBE. MMBE tells you what is there now; MB51 tells you how it got that way. Most stock investigations use both: MMBE to see the discrepancy, MB51 to find the movement that caused it.
The most useful filter is movement type. Filtering to 101 shows every goods receipt; 601 every issue against a delivery; 551 everything scrapped. That turns a wall of movements into an answer.
When you would actually use MB51
- A stock balance is wrong and you need the movement history behind it.
- Checking what was actually received against a purchase order and when.
- Finding everything scrapped, returned or written off in a period.
- Supporting a stock count variance with the movements around the count date.
What the screen looks like
Selection
| Mat. Doc. | Item | MvT | Posting Date | Qty in UnE | UnE | SLoc | User |
|---|---|---|---|---|---|---|---|
| 5000018841 | 1 | 101 | 05.08.2026 | 500 | PC | 0001 | DMANCUSO |
| 5000018902 | 1 | 102 | 05.08.2026 | 500- | PC | 0001 | DMANCUSO |
| 5000018903 | 1 | 101 | 05.08.2026 | 450 | PC | 0001 | DMANCUSO |
The fields, in plain English
MSEG-MATNRWhich material to trace. Ranges are allowed, though the output is most readable one material at a time.
Watch out: Leading zeros again — the stored value is usually zero-padded even where the screen shows it trimmed.
MSEG-BWARTThe most valuable filter on the screen. Several can be listed at once — 101 and 102 together show receipts alongside their reversals, which is how you spot a correction cycle.
MKPF-BUDATThe period to report. Effectively mandatory: material document tables grow faster than almost anything else in the system.
Narrows to a site or a specific location within it. Leaving storage location blank is how you catch stock that moved somewhere unexpected.
MKPF-USNAMWho posted the movement. Useful when tracing an unexpected posting to a person or to an interface account.
Step by step
- 1Enter the material, and the plant if you know it.
- 2Set a posting date range — do not leave it open.
- 3Add movement types if you are looking for a specific kind of movement.
- 4Execute (F8).
- 5Read the quantity column: positive figures increase stock, negative decrease it.
- 6Double-click a document to open it in full.
- 7Cross-check the closing position in MMBE.
Errors you will hit, and what they mean
No documents found for the selection
Why: Date range, plant or movement type filter too narrow — or leading zeros on the material number.
Fix: Widen the date range and clear the movement type first, then narrow again once you have results.
Report runs very slowly
Why: Unbounded date range against a high-volume material.
Fix: Always restrict the posting date. Run in background for a genuinely large extract.
Quantities do not agree with MMBE
Why: Usually a stock-type difference — quality inspection and blocked stock are on hand but not unrestricted.
Fix: Compare by stock type, not just total quantity, before assuming an inconsistency.
Common questions
What is the difference between MB51 and MB52?
MB51 lists MOVEMENTS — the history. MB52 lists current stock ON HAND by material and location. Use MB52 for the position, MB51 for how it got there.
How do I see everything received against one purchase order?
Filter on movement type 101 and enter the PO number in the further-selections block. The purchase order history in ME23N shows the same thing from the other direction.
Can I see stock as at a past date?
Not directly here — MB5B reconstructs the stock position at a historical date. MB51 gives you the movements, from which you can work it out.
Transactions that go with MB51
Reading about it only gets you so far
Practise SAP transactions in a safe simulated environment and keep what you learn.
Practise SAP transactions hands-on
Interactive modules, games, and an AI tutor — free to start.
Get started free →