SAP MB51 – Material Document List

When searching for materials movement history in SAP MB51 is the transaction you are going to use. It is a flexible and neat report that you will find very useful.

In SAP, all transactions that create goods movements (sales, goods receipt, transfers, etc.) creates material documents. These material documents have details of that movements (like date, user, locations, invoice nr, etc.). Therefore they are used for tracking material movement history.

In order to effectively track movement history, you need to be informed about movement types in SAP. Movement type shows at a glance, what kind of movement is done to a material (sales, transfer, etc.). You can get information about most used movement types in the post: common movement types.

When you first call SAP MB51 transaction, the first screen you are going to see will be the filter screen.


This screen has a wide variety of filter for your different filtering needs. Most common filters you are likely to use are:

  • Material
  • Plant (for multi-pant systems)
  • Batch
  • Movement Type
  • Posting Date
  • User Name

An important detail is clicking on this option to avoid struggling with ugly multi row lists. When you click on this option, your list will be created in datasheet layout.


When you search for a material, you get a list of movements of that material. Default list you are going to get will look like the one below:


This list doesn’t have much information as it is. But since a material document has much more information, you can choose to display more in here. This can be done as shown below.


Material Document in detail (MIGO-Display authorization is required):


This amount of information should be enough to start using SAP MB51 effectively. By checking all available options and additional columns, you can master this report in no time.

You may also like...

19 Responses

  1. I am now not certain where you are getting your information, however good topic.
    I needs to spend some time studying much more or working
    out more. Thanks for fantastic information I used to be in search of
    this info for my mission.

  2. Hlaing Bwar Oo says:

    How can i add reference in MB51?

  3. Neil Salaver says:

    How do i know the material document number in SAP that has been GR already?

  4. Lorenzo says:

    Is there a way to export the material document list as spreadsheet?

  5. Ed says:

    When did MB51 start requiring access to MIGO, in order to display the detailed report? I have a 7.31 ECC system that does not require MIGO for drilldown in MB51. I inherited a 7.40 ECC system that requires MIGO for drilldown.

  6. Victor says:

    Question no 1 . MB51 able to check multiple material document list
    Question no 2 How to export in to excel

    • melih says:

      MB51 can check multiple material documents. But you can’t search by doc. by default. You need to use other fields.
      To export, click on the button on top left. It should read file or something like that. You will see the option there.

  7. Siham says:

    How to find an article average annual consumption plz?
    Thank you

  8. Saby says:

    Hi I am new to sap, but I need to learn all, how is it possible

  9. mohan kumar says:

    how can i use Material Document no in MB51

  10. Elise says:

    What does negative quantity and negative amounts in MB51 mean?

    • melih says:

      It shows the movements that creates a decrease in your stock locations. Based on the movement type, they can mean a stock location change or sales/consumption,etc.

  11. joe says:

    how do I identify where parts have come from? i.e what vendor send the parts

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.