Skip to Content
Author's profile photo Former Member

Increase the performance of MB51 by adding Material document year in MB51 selection

One way to increasing the performance of MB51 and MB59 reports is by using the Material document year in the input screen on MB51 and MB59 reports.

To increase the performance of the MB51. Include the material document Year field (MKPF-MJAHR) in the selction screen of the MB51 through the below mentioned SPRO path.

Configuration Path:

Path for configuration change is SPRO-MM-Inventory management and physical inventory-Reporting-Define field selection for material document list…which is as shown in screen shot one.

ScreenHunter_05 Sep. 05 17.49.jpg

In the screen shot shown below select the tick mark of field MKPF-MJAHR for selection.

Click on Save.

ScreenHunter_01 Sep. 05 16.54.jpg

After saving the configuration, we will be able to see the material document filed in MB51 input screen as shown below.

ScreenHunter_04 Sep. 05 16.57.jpg

Now Do the test for performance:

In this MB51 screen, Give Plant, storage location and One month period in posting date fields.

Test the report with above inputs with Material document year and without Material document year.

See the difference.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli


      Thank u for sharing your Knowledge. I hope it is better to write step by step how you added field in input screen and other things.

      This is very useful to others also. 

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli

      Thank u Ravi Kumar.

      Author's profile photo Jürgen Lins
      Jürgen Lins

      this is old information, it is already since 1999 that "the database selects the optimum access strategy to material documents by means of the entered selection criteria"

      If you really want increase the performance of MB51, then you should read the OSS notes for MB51 new design in Service Market place or just the blog series here in SCN that starts in this blog:

      Redesigning of the MB51 Standard SAP report 1\3

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      I have gone through the Note which says adding fields MKPF in MSEG and updating the data.

      But this Material document year is best one I have ever seen. I mean restricting Input posting date should increase the speed of the report but this one material document year is best one.

      Thought of sharing the information which might help others.  Thanks for sharing the Info.



      Author's profile photo Jürgen Lins
      Jürgen Lins

      A proper selection is always the quickest way to a result.

      As you have done this change you can give the proof in numbers

      Execute the selection for your material once using the Year field with value 2012 like you suggested, and then do it again by using the the posting date field  with a range from 01.01.2012 to 31.12.2012 and leaving the year field empty