Stock Inconsistency
目录
- Introduction
- Possible Reasons for Stock Inconsistency
- Errors during Inventory Transactions
- Transactions where we can check the stocks
- Various transactions which are used to find stocks in SAP are
- Possible causes of inconsistency and their solution
- Solution
- Cause and Prerequisites
- Solution
- Useful Reports to Analyze Inconsistencies
- Conclusion
- Thread
Community
Topics
Groups
Answers
Blogs
Events
Programs
Resources
What's New
Home
Community
Blogs
Ask a Question
Write a Blog Post
Former Member
January 30, 2015 4 minute read
Stock Inconsistency
51635,615
Introduction
Very often we get issues like stock shown in Material Master record with Stock available in MMBE . At the same time, valuated stock will not match with codes/reports like MCBE, MC.9, MB53. It is very important in Inventory Management to check that the stocks are properly maintained for their correctness in terms of quantity and value. These type of inconsistencies cause instability of system in terms of incorrect reporting, false stock statements and incorrect decisions.
This document deals with possible causes of stock inconsistencies and the analysis required for finding the same and taking corrective measures.
Possible Reasons for Stock Inconsistency
Prolonged usage of inventory management transactions like MIGO, MB1B for stock posting.
Archiving of documents.
Wrong postings with negative stock\
History tables MBEWH, MARDH, MSEG, MKPF not updated properly
Errors during Inventory Transactions
Whatever may be the reason, system would become inconsistent which may provide error message like any of the following :
M7 308 ‘Stock value and qty are unrealistic: & / &
M7 309 ‘Stock value is negative: &
M7 310 ‘Valuated stock is negative: &
M7 314 ‘Valuated stock becomes negative: &
The possible reason is, there exist no actual stock in the system, though MMBE shows some stock. Most of the time this could be the reason for error messages.
Transactions where we can check the stocks
Various transactions which are used to find stocks in SAP are
MMBE – Stock Overview Report
MM03 – Accounting view of material master fetches data from MBEW (table for valuated stock)
MB53 – Plant Stock Availability
MB52 – Warehouse Stock Availability
Possible causes of inconsistency and their solution
1. Difference between storage location stock and batch stock
Sometimes, the sum of all batch stocks from MCHB table for a particular material differ from storage location stock available from table MARD. This is not applicable to spacial stock like Sales Order stock or Project Stock.
The possible reason for this inconsistency could be when you use a modification for batch number assignment. One batch is assigned several times (e.g. use of a dummy batch number or the actual date)
Solution
Check your modification in batch number assignment, in particular in Function Module VB_NEXT_BATCH_NUMBER.
A second option to find whether the inconsistency is a result of such a modification is to call transaction MSC3N for the relevant batch and display the change documents. If there there several change documents with the content “Batch created”, this usually hints to a modification in batch number assignment.
To avoid further inconsistencies, delete your modifications. Implement Notes 1035372 and 1062164 and set the parameter ALLOW_EXISTING_BATCH in the existing user exit EXIT_SAPLV01Z_002 to make postings to the existing batch. If the system now issues the error message M3 204 ‘Batch & already exissts in plant &’ or M# 556 ‘Batch & already exists for material &’ , you must repopulate the batch number in the user exit EXIT_SAPMM07M_010.
2. Wrong Goods Receipt
In your system, there is a GR for PO, in which an item in the material document contains the material number of the previous purchase order item.
3. A material has inconsistent data
The stock in Accounting View (Table MBEW) does not correspond to the stock in the Stock Overview. You have own programs which cary out an update on MBEW.
Cause and Prerequisites
Table MBEW contains valuation data of material , for example the total stock and total value. These fields are updated with every goods movement. With these frequent changes in the table, each updatem which doesnot lock the table correctly, can cause data inconsistency.
Solution
Do not use your own programs to change fields LBKUM, SALK3, SALKV, VKSAL, STPRS, VERPR, VPRSV of table MBEW.
If you use own programs which changes other fields of table MBEW, always use the addition SET. Thus, on the database only, fields specified with command SET are changed. Stock postings which may be carried out at the same time remains unaffected.
4. Non-generation of Accounting Document in MIGO
When Goods Movement is posted, a material document is generated. However, no update on the dependent stock tables, such as MARD and MBEW are carried out. In addition, no accounting document gets generated.
Causes and Prerequisites
Following procedure causes incorrect update.
i. You post goods movement with transaction MB11 or MB1A
ii. You enter movement type, plant and storage location in initial screen and choose Enter
iii. You enter material number in the following overview screen and confirm your entry by choosing Enter.
iv. Since you did not fill the field quantity, you reach the detail field automatically. Your system generates warning message M7 129 ‘Enter a quantity’.
v. You display the movable quantity using Key combination Shift + F5, and exit the dialog box (F12).
vi. Enter the entry quantity in the following detail screen and confirm it by choosing Enter.
vii. Then press cancel (F12)
viii. You reach the Overview screen again and post goods movement (F11)
5. Due to Period Closing Issues
In period closing for material master (MMPV), goods movement are done during the interval between Last Day of the Old Period and First Day of the New Period.
It is recommended not to post any documents whilst the period closing programs are running. Before the period closing program runs, check in transaction SM13 whether outstanding update terminations of goods movement are still displayed. These must be cleared and closed before the period closing program runs.
Useful Reports to Analyze Inconsistencies
RM07SHUP – Shows updates recorded in table mminkon_up.
MBANEKBE – Display of a purchase order history
MBCKBSEG – This report checks Materials having balance in FI with no entry in MBEW, Materials with wrong valuation class in MBEW as a result of which account determination gets different account as in BSEG , Materials which have a different actual value in MBEW as in BSEG, Manual Postings or with posting key not equal to BSX for stock accounts
MBCKBSIM – This report checks whether for all BSEG entries, a BSIM entry exists
MBTRAMEW – This report will try to find inconsistencies caused by Stock Transfer Orders with active ingredient batches. This report also allows posting the correction using transaction MWBE
RM07HIST – routine to read history stock from history tables.
MBUPDATE – This report allows modification of MM-IM table fields. Updated values are stored in table MMINKON_UP
MBLABST – Shows general information and Stocks for a specified material in a specified plant.
MBMSSQCR – Using this report, user may change the content of field MSSQ-KZBWS (special stock valuation indicator) when the special stock is 0.
Conclusion
Although there are many reasons for stock inconsistencies, some of possible reasons and there solutions have been discussed. Finding out inconsistencies and their corrections will improve the stock management thereby, reducing the inventory costs.
FollowLikeRSS Feed
Alert Moderator
Assigned Tags
MM (Materials Management)
goods movement error
goods movements
inventory controlling
inventory management
stock inconsistencies
Similar Blog Posts
Tips & Tricks about MM-IM*
By Fabio AlmeidaSep 08, 2013
Negative Stock Although Not Allowed in Customizing
By PRASOON AKAug 05, 2015
Customizing of Material Type and MM Inconsistency Prevention
By Jimmy ZhangMay 07, 2010
Related Questions
Material to Material transfer
By Former MemberJan 15, 2012
MARD and MBEW stock Inconistency
By Former MemberJul 03, 2017
MSEG-BPMNG not in quantity table/not consistent
By Former MemberAug 06, 2009
Join the Conversation
SAP TechEd
Tune in for tech talk. Stay for inspiration. Upskill your future.
SAP BTP Learning Group
SAP Business Technology Platform Learning Journeys.
Coffee Corner
Join the new Coffee Corner Discussion Group.
5 Comments
Osvaldo Lopez
January 30, 2015 at 11:27 am
Thank you very very very much !
Keep doing this docs !
Regards,
Oswald
Like 0
Reply
Alert Moderator
Share
PRASOON AK
January 30, 2015 at 11:37 am
Hi,
Good attempt. There are many notes and standard programs related to the same. It would be even better if you can enhance the document by adding the related notes or KBA's like
1. 1618888 - How to deal with stock inconsistency?
2. 76926 - Checklist for stock inconsistencies
3. 204393 - Inconsistencies between stocks of MARD and MBEW
4. 2010127 - Inappropriate customizing change of material type may cause stock inconsistency.
5. 32236 - Incorrect stock qty or stock value in material master
6. 392205 - Analysis of stock in transit/correction for split valuation
7. 1908994 - MMPV: Error M3705 - Period closing terminated due to negative stock
8. 945346 - MMINKON stock inconsistency tool: Enhancements to standard
9. 92550 - Stock inconsistency due to customer enhancement (exit, BAdI)
Many more standard documents are available.
Thanks & Regards,
Prasoon
Like 0
Reply
Alert Moderator
Share
Mehmet Ozgur Unal
February 25, 2015 at 7:44 pm
Hi all ;
Good document for everyone. I want to add somethingelse like belowed.
32236 - Incorrect stock qty or stock value in material master
935755 - Negative stock even though this is not permitted in Customizing
Tips & Tricks about MM-IM*
Thread
BIG PROBLEM / Negative stock altough not allowed in customizing
REPORTS with SE38 :MBSTOCK
MBFIRST
Regards.
M.Ozgur Unal
Like 0
Reply
Alert Moderator
Share
Former Member
March 9, 2015 at 12:55 pm
Excellent document !! Thank you for sharing.
Best Regards,
Jaydip
Like 0
Reply
Alert Moderator
Share
...
