Skip to Content
Author's profile photo Former Member

How to Add Fields in Standard Report MB51

Dear All,

Here I am going to tell you how to add fields in Standard Report MB51, so that they can appear while executing it or on selection screen.

Fallow the Path

SPRO >> IMG>>Materials Management>>Inventory Management and Physical Inventory>>Reporting>>Define Field Selection for Material Document List

NewPicture023.jpg

Click on “Define Field Selection for Material Document List”

NewPicture025.jpg

MSEG:Document Segment: Material or simply list of material document.

MKPF:Header: Material Document

So in SE11 or in SE16N you can check which filed you want in MB51

Now, press Push button New Entries

eg: SGTXT i.e Text field in MSEG.

NewPicture026.jpg

on the extreme right side you are watching  two columns. Selection Field and Output field, so here you have luxury of selection as well as display only. After this save in request and transport it.

The SGTXT Field is found in the item>Where tab in MIGO

NewPicture027.jpg

Now after this configuration when you will run MB51 you will have this filed

NewPicture028.jpg

so this way you can add fields in MB51, you can also take the help of SAP Note: 357187

Thanking you!

Ashish Mishra

Assigned Tags

      37 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Leo Thilak M.S
      Leo Thilak M.S

      Hi Ashish

      These is good document , i already tried it by introducing GL and its working fine

      Thanks and Regards

      Leo

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

      Dear Leo

      Thanks for telling about the documents.

      Thanking you!

      Ashish Mishra

      Author's profile photo Former Member
      Former Member

      Hi Ashish,

           its very good document, i have requirement for trx ME5A list ofpurchase requsition report in input screan add on one field its possible.

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

      Dear Veeraprathap:

      Thanks for praising the documents created by me.

      For you requirement please see the below link:

      http://scn.sap.com/message/9898845

      Thanking you!

      Ashish Mishra

      Author's profile photo Former Member
      Former Member

      Hi,

         if you have any configaration is there, like that above document.

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

      Dear Veera

      Sure will make one and will share with you soon.

      Thanking you!

      Ashish Mishra

      Author's profile photo Former Member
      Former Member

      Excellent congratulations  Jurguen. 😘

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

      your congratulations have to go to Ashish Mishra

      I am unfortunatly listed because I did a little moderation at this document

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

      Respected Sir,

      You are not Unfortunatly listed there, in fact for me its like having "Panchamrita" when finding someone like you here.

      Thanking you!

      Ashish

      Author's profile photo Former Member
      Former Member

      Hey Ashish,

      This is really very helpful document for us, You have done a great work.

      Regards

      AJC

      Author's profile photo Former Member
      Former Member

      hi asish i saw ur answers, very intresting how can i add ur id?

      Author's profile photo Sijin Chandran
      Sijin Chandran

      Nice documentation.

      Author's profile photo Former Member
      Former Member

      thanks ashish ...this is really nice article.

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

      Thanks

      SAP HUB.

      Author's profile photo Narasimhulu Konnipati
      Narasimhulu Konnipati

      Hey Ashish,

      Indeed, it helps the users not only from MM and also for FICO. Good one and i appreciate for your contribution.

      Keep up the good work

      Thanks,

      Narasimhulu

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

      Dear Narasimhulu

      Thank you so much for encouraging me...Good to know that you like my document.

      Thanking you!

      Ashish Mishra

      Author's profile photo Ranjit Simon John
      Ranjit Simon John

      Very good document. Its a real helpful document.

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

      Dear Ranjit

      Thank you so much...

      Regards

      Ashish Mishra

      Author's profile photo Srinivas Salpala
      Srinivas Salpala

      Hi Ashish,

      Good interpretation skills. Helping a lot all the users... Keep doing it.....

      Regards

      Srinivas Salpala

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

      Dear Srinivas

      Thanks for your kind words..

      Regards

      Ashish Mishra

      Author's profile photo Former Member
      Former Member

      Good work Ashish...really nice article.

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

      Dear Umar

      Thanks for your kind support.....

      Regards

      Ashish Mishra

      Author's profile photo Former Member
      Former Member

      Dear Ashish,

      Thanks alot....for you great inputs.

      Thanks,

      LN

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

      Dear Lakshmi

      Thanks!

      Ashish

      Author's profile photo Former Member
      Former Member

      Hi Ashish

      These is good document, thanks a lot.

      Keep up the good work

      Author's profile photo Former Member
      Former Member

      Hi Ashish,

      Very nice document..

      Thanks

      Prasanna

      Author's profile photo Former Member
      Former Member

      Nice Sharing

      Author's profile photo Sanjeet Kumar Yadav
      Sanjeet Kumar Yadav

      Thanks dear. very nice.

      Regards

      Sanjeet Kumar

      Author's profile photo Former Member
      Former Member

      Thanks,It is very helpful

      Regards

      Sandeep

      Author's profile photo Former Member
      Former Member

      Great work Mishra.

      Author's profile photo Gurunath Kumar Dadamu
      Gurunath Kumar Dadamu

      Thanks for sharing the blog.

      Regards,

      Gurunath

      Author's profile photo Bisweswar Sahu
      Bisweswar Sahu

      Nice Information. Thanks for sharing.

      Regards,

      Bisweswar

      Author's profile photo Former Member
      Former Member

      Good One...Many Thanks.

      Best Regards,

      Naresh K.

      Author's profile photo Former Member
      Former Member

      Nice and easy to use document, thanks. Can be usefull to filter on users' name who created the material document.

      Kind regards,

      Génia.

      Author's profile photo Former Member
      Former Member

      Hi Ashish

      Its a very nice document. Thanks a lot. 🙂

      Author's profile photo prathamesh lonkar
      prathamesh lonkar

      Hi Ashish,

      Thanks a lot for your inputs

      Best Regards,

      Prathamesh

      Author's profile photo Siddhesh Keni
      Siddhesh Keni

      Respected, Greetings!!

      The documentation is indeed well versed for the attaining the objective of the report. Thanks.

      May i ask one query - can we add other program/table related field (example - Table SER03 Serial number field) to be also displayed in the output for material ageing report calculation.

      As serial number is one of the critical fields in the material document report MB51 which is needed to identify the material movement status whether received or still pending at the vendor's site.

       

      Warm Regards,

      siddhesh keni