Skip to Content
Author's profile photo Dibyendu Patra

Uses of Movement type group for stock analysis in MB5B

Business Scenario:

We execute the report MB5B to check stock as on posting date along with we can check the stock analysis from the same transaction code. We choose the tick option of “Totals Only” to see the sum of these columns ‘Opening Stock, Total Receipt Quantities, Total Issue Quantities, Closing Stock. If we don’t select the totals only, then we can able to see all movement type’s line items with regards to our selection criteria. Here we can see all movement types which is related to all modules (MM SD QM etc.). To see line items for some specific movement type (e.g. how many quantity has posted with regards to the movement type 101,105,109 etc.), you need to choose the filter option. But with the help of movement type group, you can see selected line items by choosing the movement type group and you can see only these line items which have been grouped under the selected movement type group.

Suppose, you need to find line items for these movement types which are causes of goods issue. We know these movement types (suppose 201, 221, 333, 551 etc.) are used for goods issue. It may be able to achieve this by filtering these movement types from MB51 or MB5B. SAP has given the facility of movement type group, so that you do not have to choose the movement type manually, You just need to assign the movement type to movement type group, then you can able to see all line items with regards to movement type.


Assignment:


It’s a very simple configuration that you need to do in IMG activity. You just need to assign the movement type to movement type group in this IMG path SPRO – IMG – Materials Management – Inventory Management and Physical Inventory – Reporting – Group Movement Types for Stock Lists.

/wp-content/uploads/2015/02/1_652116.jpg

Here, choose your movement type and assign the movement type group as per your requirement. Movement type group is a free text field; you can enter any text in this field (as quite same like as account modifier for movement type). Do it for these movement types which you want to see in MB5B stock analysis report when you will choose the movement type group. You can also select your custom movement type (as per your business requirement). System read the table T156S for the movement type. You can’t able to create any entry here. All movement types are created from OMJJ transaction will be updated here with blank movement type group automatically.

(Note: You will be able to see a warning message as “Do not make any changes (SAP entry)”. Read the message carefully and do that accordingly which is explained in the procedure section.)


Result:


Run the report MB5B without choosing the option ‘Totals only’. You can see all line items for all movement types. Now choose the movement type group from the screen layout as below:

/wp-content/uploads/2015/02/2_652117.jpg

Here, the field name will be ‘Group f. Stock Anal.’ (As you can see the above screen shot)

Then you can see the field movement type group in the output list. Also here you can see a default value as ‘REST’ for those entries which haven’t assigned to any movement type group. That means if you will not assign any movement type group with regards to movement type in IMG, then you can see the value ‘REST’ for these line items in this output list. It is designed by system.

/wp-content/uploads/2015/02/3_652154.jpg

Now you can see your selected movement type’s line items by sorting or filtering the movement type group. Just filter the tab movement type group as per your assigned group.

/wp-content/uploads/2015/02/4_652155.jpg

Conclusion:

This is just an extra facility from SAP to check the stock analysis and it is only used for reporting purpose at the section inventory management. You can’t use this movement type group in selection screens. You can’t use this facility in MB51 transaction; it is only applicable for MB5B stock analysis transaction. You can keep the output layout by saving the adjusted layout, if you want to see the same later. The assigned value of movement type group is stored in table T156Q as per movement type. You can also select special stock wise movement type during the assignment of movement type group. You should not select specific movement type in MB5B in selection field as because of incorrect result. If you will select any specific movement type in MB5B, then system will through a warning message “If there are restrictions acc. to movement type, results may be incorrect”. So you need to run the report without selecting movement type and then use the movement type group to see the stock analysis with regards to your required movement type.


SAP help document : Group Movement Types for Stock Lists

Assigned Tags

      15 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mehmet Ozgur Unal
      Mehmet Ozgur Unal

      Hi Dev ;

      Have a nice implementation , thanks

      M.Ozgur Unal

      Author's profile photo B V Yadav
      B V Yadav

      Hi Dev Sir,

      Simply superb document again. thanks for sharing this document.

      Regards,

      B V

      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      Its a new learning for me. Thanks for sharing this Dev.

      Thank$

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli

      Thnks for sharing helpful document.

      Author's profile photo Former Member
      Former Member

      Hi Dev,

      Good One  Dev  Thanks For Sharing. ๐Ÿ™‚ ๐Ÿ˜‰

      Author's profile photo Tapas Das
      Tapas Das

      Hi Dev,

      Thank you so much for sharing this blog. ๐Ÿ™‚

      Regards,

      Tapas

      Author's profile photo Vignesh Veerasamy
      Vignesh Veerasamy

      Good document...thank you

      Regards,

      Vignesh.V

      Author's profile photo Narendra Konnipati
      Narendra Konnipati

      Nice document dear.

      BR

      KNR

      Author's profile photo Osvaldo Lopez
      Osvaldo Lopez

      Excellent doc!

      Thanks for share !!!

      Author's profile photo Former Member
      Former Member

      Hi,

      Thanks for sharing helpful document...

      Author's profile photo Darren Taylor
      Darren Taylor

      Very useful

      Thanks for sharing

      Going to update our system right now!

      Regards

      Darren

      Author's profile photo Former Member
      Former Member

      Hi Dev,

      Thanks for taking your time out to share this info with us.

      Br,

      Raghu

      Author's profile photo kumar kumar
      kumar kumar

      Hi Dev, once again you done a good job,very informative document Thanks & Regards Kumar

      Author's profile photo Narayana N
      Narayana N

      Hi Dev,

      Nice document. Keep sharing ๐Ÿ™‚ thank you.

      Best Regards,

      Narayana N

      Author's profile photo Almiro Sengo
      Almiro Sengo

      Very nice document, thanks for sharing

       

      May you please show me the filter, I couldnยดt find it.

       

      Thanks