expertsask994@gmail.com
My Account
  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account
Blog
Home General SAP Useful reports in Material Management
General SAPMM

Useful reports in Material Management

ERP College September 10, 2020 0 Comments

If someone asks what makes ERP so special? My answer would be the ability to manage inventory. ERP enables us to track live movements of inventory. And if that’s the biggest part of ERP, then we should definitely explore the biggest ERP-SAP.

In this blog, we will know about different kinds of reports in Material Management and how they can help us to track the material’s movement/to manage inventory.

Let’s start with a transaction which will guide you to find available reports in SAP:

Execute SAP1 transaction code

SAP1

This transaction will redirect you to easy access of the report selection screen, expand any of the above folders, and find out the reports specific to each module.

We will see the reports available in Material Management

SAP1 – Material Management

The reports further sorted with IM, WM, Purchasing and Physical Inventory.

Let’s expand the Warehouse Management – Master data folder:

SAP1 transaction is worth to remember, it will help you to find reports/data easily across any module.

MB51 – Material Document List

This report is used roughly in MM and really useful for a consultant and end user as well for analyzing the movements of material.

Selection screen:

MB51

The report can be executed with the various combination of Material, Plant, Vendor, Movement type, and sales order. Which gives us the flexibility to view material movement from various aspects.

In and Out of the Material is colored with green and red respectively.

This series of report keeps going on like this:

  • MB51: Material Document List
  • MB52: List of Warehouse Stocks on Hand
  • MB53: Display Plant Stock Availability
  • MB54: Consignment Stocks
  • MB58: Consgmt and Ret Packag at Customer
  • MB59: Material Document List

MMBE – Stock Overview

This transaction is one of the tools that can be considered as a display at any given moment of information about the stock situation of an individual material. It gives a material stock position on every organizational level along with the information of batches and special stock.

Selection screen:

MMBE

It can be noticed this transaction can be executed for specific plant and/or storage location and/or batch.

On lower side of the selection screen we can select the display level of stock.

On the left-hand side of this report, the organization levels can be seen. And the highlighted area displays whether the stock is in unrestricted use or blocked under the order or in quality inspection.

So this report will be read like Material 1234 of qty. 20 under plant ABC is in unrestricted use and material 1234 of qty. 50 is blocked in order.

Now we will discuss about the most unknown but most useful report:

MBMAPCHANGES – Report for Moving average price analysis

This report gives us a detailed breakdown of moving average price, how the MVP changes with every movement of material, it can be analyzed in this report.

Execute SA38 and enter the program name MBMAPCHANGES and execute

MBMAPCHANGES

Selection screen requires Plant and Material number

And here you go with the old price and new price changed with each material document

And this brings us to the end of the blog… we will keep updating this blog with new and useful reports in MM and WM…. Stay tuned.

If you have any suggestions or questions do let us know in the comment section or you can also write us directly. 

Sign up with us to get an update of a new blog post.

Till then you can have look at our ebooks.

98
4269 Views
AboutERP College
ERP College is a knowledge portal for all of those who want to learn SAP. This is a one-stop reference for your entire SAP needs. Here you will find blogs that will help you to point out daily support issues. The blog covers technical, educational, and psychological aspects of working with SAP, mostly from the point of view of consultants or people responsible for implementing SAP software.
In Socials:
Tips and tricks on Bank Reconciliation in SAPPrevTips and tricks on Bank Reconciliation in SAPAugust 30, 2020
Ways to find Tables and Transaction codes in SAPNovember 9, 2020Ways to find Tables and Transaction codes in SAPNext

Related Posts

General SAP

Ways to find Tables and Transaction codes in SAP

One thing is for sure that we cannot remember every table and transaction related to...

ERP College November 9, 2020
General SAP

Investing in your personal and professional growth

Investing in your personal and professional growth will not only yield future...

ERP College August 25, 2020

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

  • Home
  • About
  • Contact
Categories
  • ABAP 8
  • FICO 23
  • General SAP 29
  • MM 1
  • SD 2
Products
  • SAP Sales and Purchase Tax Training
    Rated 4.50 out of 5
    ₹899.00 ₹699.00
  • SAP Accounts Payable (AP) Training
    Rated 4.00 out of 5
    ₹1,999.00 ₹1,699.00
  • SAP Asset Accounting (AA) Training ₹1,399.00 ₹1,199.00
  • Controlling - Profitability analysis (CO-PA): Comprehensive coverage of the SAP CO-PA module
    Rated 4.40 out of 5
    ₹449.00 ₹299.00
Sign Up to get update of latest Blogs

Find Us

Address
123 Main Street
New York, NY 10001

Hours
Monday–Friday: 9:00AM–5:00PM
Saturday & Sunday: 11:00AM–3:00PM

About This Site

This may be a good place to introduce yourself and your site or include some credits.

Contacts
Website: https://erpcollege.co/
Email: expertsask994@gmail.com
Terms & Condition

Copyright © 2020 ERP College by Smarksys Technologies. All Rights Reserved.