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.
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.
In the screen shot shown below select the tick mark of field MKPF-MJAHR for selection.
Click on Save.
After saving the configuration, we will be able to see the material document filed in MB51 input screen as shown below.
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.
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.
Thank u Ravi Kumar.
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
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.
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