Register Login

Procedure for correcting the material master

Updated May 18, 2018

Data inconsistencies occurred in your system between the material documents and the material stock or between the accounting documents and the material valuation.

If the error could be reproduced, we have provided a separate note to inform you about the cause of the data inconsistency. Possible source code corrections were also specified in this note.
Furthermore, we have repaired your material master. This note describes the general procedure for such a correction.

The SAP System writes a material document and, if required, an accounting document for each material movement. From these documents, you can later determine the stock situation of the materials. This is being used by the reports from Note 32236, in particular MBSTOCK, MBQUANT, and MBVALUE during analysis and correction. If the documents no longer fully exist in your system, it may no longer be possible to calculate the values completely.

Changes made by the correction programs are logged and can be displayed using the report RM07SHUP. As of version 19, the report RM07SHUP is contained in Note 32236. However, you can also install it separately using Note 1096356.

The material master correction was performed in several steps:

1. In a first step, the material stocks were compared with the material documents. The correct stock was determined from the material documents and written to the material master. In this case, no material document was created. As a result, the material stock was compared with the stock determined from the documents.

This stock does not need to match the stock contained physically in the warehouse. The comparison with the physical warehouse stock is to be made by means of a physical inventory count.
If the Warehouse Management system is activated in a storage location, you have to make a stock comparison between MM and WM to transfer the WM quantities to inventory management (transaction LX23). If required, you must carry out a physical inventory in Warehouse Management before the stock comparison.
If you use QM, see also Note 48815.
If you use the material ledger, you can use transaction CKMC to check whether the stock tables match the material ledger.

The determination of the material stock from the material documents may result in a negative stock. This means that according to the documents too much of the material was withdrawn. To correct the negative stock, a receipt posting had to be made for the material in question.

2. Afterwards, the quantity in the valuation table (MBEW, accounting view in the material master) is compared with the stocks and corrected, if required. During this step, the stock values are also corrected based on the current price, in other words
value difference = quantity difference * current price / price unit.
3. After the correction of the material stocks, the values of the materials were compared with the accounting documents. The following procedure was used in the case of differences:
In the case of material controlled by the moving average price, the value and the price of the material were corrected in the material master according to the documents. In this case, no accounting document was created because the stock accounts matched the accounting documents. Please check the new moving average prices of the materials in question.
The same procedure as for the moving average price was used for materials controlled by the standard price. Then the standard price was reset to the old value by posting a price change.

If the total of all FI documents for a material resulted in a negative value, even though the material had a positive stock, SAP posted a price change after the correction that did not change the price. As a result, the total value of the material is recalculated and the difference that may exist is posted to the price change account.
The amount with a price change was also brought to zero for materials without stock, for which the total of FI documents did not result in zero.
Contact your responsible agent if you have any further questions concerning this procedure or in the case of problems that occurred in your system especially during the correction.

1. Since correcting the data inconsistencies is very time-consuming, SAP can only make corrections in your production system. It is not possible to make this correction in two systems.
2. During analysis and repair, the reports may lead to reduced performance in your system. Furthermore, materials need to be blocked during repair. This may lead to error messages (material blocked) when processing or posting materials. However, this CANNOT be prevented.
3. During analysis and repair, the reports may also need to take materials of plants into account that were not reported to have errors. This is required to check the consistency of the system. All these changes are logged and can therefore be traced back.
4. As of Release 4.5A, stocks and stock values of past periods are stored in history tables. These tables solely serve for the analysis of stock inconsistencies in the current period by SAP Support. If further material documents were posted in subsequent periods after a stock inconsistency occurred, the history tables created after the inconsistency also contain incorrect stocks or stock values for the relevant material. However, these history tables are not repaired since they are not required for your SAP system to function.
1) History tables of the previous year are required for the year-end closing.
2) History tables of the previous period, if posting to the previous period is not possible due to an incorrect history table.
Thus, analyzing history tables using customer reports is not supported.