Skip to Content
Author's profile photo MA JAMIL

Redesigning of the MB51 Standard SAP report 2\3


Download it in your system and transport it to your SAP system.


Access the Tcode SE38 for the creation of the Z File within your SAP system in the customer namespace. Enter the Program name and select Create button. In our case we have changed the program name from


Place the name exactly the same as mentioned in the SAP Note.


Fill out the program attributes as shown below and make it the Executable program


Enter the package name which would be in the customer namespace


Now assigning this newly created program object to the same change request that had already been created using the Developer account


Within the ABAP editor of the just created program, Select the below mentioned path from the Menu bar.

Utilities->More Utilities->Upload/Download->Upload


From this option you can directly import the file from your system directory.

Import the file that has been downloaded from the SAP Note 1516684 attachments. After importing Activate the file.


Now on the initial screen of the SAP ABAP editor choose execute button to run the file.


This would be the initial Selection screen of the file just imported.


Before running the program, create the TMP index in MSEG DB Table.


Access Tcode SE11 for changing the MSEG table. Enter table name and select change


System will prompt an information message stating to make the changes only if they are urgent. Select ok


Select Indexes… button from the Application toolbar besides the Technical Settings button


All the Indices of the MSEG table would have been shown. From the create button mentioned below, choose Create index option for the TMP index to be created for MSEG table.


Enter the Index Name i.e. TMP.


System will prompt a Warning message stating that we did not place it within the customer namespace


Select ok. System will again prompt the same message about the namespace. Ignore it and press Enter.


Select Maintain in Logon Language button from the options provided on the popup message.


Enter the Short description for the index. This is not given in the SAP note 1516884. It can be any but be descriptive. Select Table Fields button copying the fields from the MSEG table to be included within the TMP index.


Select the fields from their check boxes mentioned in the SAP note 1516884 and press Copy button. Fields with their short descriptions would copy to the index creation frame


The fields have been copied.


Save the index and assign it to the same change request which we have already created so that all the objects be transported correctly and simultaneously.


Activate the index.


You need not worry about the warnings. Select No to ignore the warnings.


Object has been successfully activated as it can be seen from the status bar below.


You can now view the TMP index from the list of MSEG indices. TMP has been highlighted in the snapshot below.


Moving on to the more indices to be create over the same SAP DB table MSEG, follow the same procedure to create the BUD, M1 and M2 indices for MSEG table which would help in executing the program in an efficient manner in terms of the records access.

Important: We also have to modify the Standard M SAP Index for MSEG


Again follow the same procedure to add BUDAT_MKPF field within the M index. Save and activate the index. System will give an information message stating the error messages and prompting to view the log information.


View the log information. From here the error message is that “INDX MSEG~M was not activated”.

The SAP system will itself provide the solution to activate the index and that would be the conversion of the Index which can be performed from the tcode SE14


Follow the procedure to convert the Index.


From the MSEG list of indices BUD, M1 and M2 would be in Active state while M index would be in InActive state. For it to be activated as well, we would now convert the index through SE14.


Access tcode SE14. MSEG table would be pre entered in the input field. Press Enter and you will be given the below mentioned snapshot. SelectActivate and adjust database with Save data option and select Yes to execute the selected option


Redesigning of the MB51 Standard SAP report 3\3

Assigned Tags

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

      I read the blog above, I found it that its a detail and wonderful work to solve the issue.

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

      It looks like the access to many screen shots is broken. Can you update?

      The link to the 3rd part does as well not work.

      further you should add a link back to part 1 (as well in part 3 back to part 1 and 2), this makes it easier for the community to get all pieces together.

      Further I recommend to add  these tags to make it visible as well from MM space overview page as related content:

      mm, materials_management

      Author's profile photo Former Member
      Former Member

      this is not really SAP on Windows related, why then blogging on SAP on Windows?

      Author's profile photo M. Abdul Jamil
      M. Abdul Jamil
      Blog Post Author

      hi Peter,

      Hopefully, You are doing well

      Dear, the SAP installed on window in my company and Users were facing issue regarding slow speed of MB51. so, I made this document and upload on this forum and Now I edit this blog and as per suggestion of Jurgen I also make a part of mm, Materials_management.


      Author's profile photo Former Member
      Former Member

      Well, in a SAP on Windows blog I expect windows related information.
      The information you posted is application and database related and has no operating system specific information.

      Think about, what is happening to this blog if every problem, enhancement to any Netweaver component will also posted here only because the application server is running on a Windows operating system!