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.

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Jürgen L

    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

    (0) 
    1. Ravi Kumar Veesam 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.

      Regards

      Ravi

      (0) 
      1. Jürgen L

        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

        (0) 

Leave a Reply