Description
With the Stock Consistency Check report (RM07KO01_ALV), you cancheck the consistency of your stock data at company code level,valuation level, or material level. Possible errors in your stocks canthus be determined at an early stage before they cause major problems.
In detail, the report provides the following functions:

• For the stock values for anonymous stock (MBEW), valuated sales order
stock (EBEW), and valuated project stock (QBEW), the program checks thefollowing:
If the quantity of the total valuated stock matches the sum of theindividual lower-level segments of this stock
If the specified price matches the value/quantity quotient
If there is a negative price for a positive quantity of a material
If a negative value exists for a material if nonegative stocks arepermitted in Customizing
If there is a value if the corresponding material has zero stocks

• With split valuation the
program checks whether:
The quantity of the total valuated stock matches the sum of theindividual lower-level segments of this stock
Per material, the total valuated stock of the sum of all valuation typescorresponds to this material
The program also checks whether:

• For each material, a cost estimate number
exists that updates the index for the accounting documents for thematerial (table CKMI1)

• For materials with a batch
management requirement, the quantity of the storage location stockmatches the sum of the individual lower-levelbatches

• If the material ledger is
active, the tables in inventory management match the tables in thematerial ledger
Note:
We recommend you run this report at regular intervals, for example, onceper month after the period-end closing or when working on theyear-end closing. To do so,choose Periodic Processing -> Consistency Check.

Output
If the report finds stock data with errors, it outputs a list with thefollowing information about each material.


• Corresponding valuation area


• Total stock quantity (actual quantity)


• The sum of all stocks from the lower-level segments of this stock


• Base unit of measure


• Stock value in the
local currency

• Price of the material with
price control specified

• Price unit


• Comments on the material and incorrect tables

If you select a material, you can go to the detail screen by choosingEdit -> Choose.
For a material that is blocked at the time of the consistency check, thesystem informs you that it was not checked. You can subsequently checkblocked materials manually from the list. To do this, select thematerial and choose Edit -> Check Material. If the material isstill blocked by a posting, the program issues the message that it wasnot able to block the material. In this case, you should repeat themanual check a few minutes later.
For split-valuated materials, the system displays the total valuatedstock and the total stock value in the Total Valuation Typesline. Below this, all stock values are listed over which the total stockis distributed. For each stock value table MBEW
, you can display the stock in the corresponding valuation type.
For valuated sales order stock EBEW andproject stock QBEW , you can display the relevantstock in detail.
The system notifies you during the check if a material does not have acost estimate number. Without a cost estimate number, a complete stockanalysis is not possible for a material. In this case, you should allowthe system to assign a cost estimate number automatically to enable adocument analysis for stock data containing errors. Alternatively, ifyou cancel the check, you can subsequently assign the missing costestimate numbers from the list of stock data with errors using Edit-> Assign Costing No..
From the Environment menu, for each material you can do thefollowing:

• Display a material master record


• Display the stock overview


• Display material documents for a material


• Display accounting documents for a material


• Display material ledger documents for a material


• Call a report for balance display for a material

What to do if the report finds inconsistencies
If the report finds stock data with errors, check each material todetermine whether the error is long-term by choosing Edit -> CheckMaterial.
If the error is long-term, in the detail view for each material you canfind out which errors the report found. Examples of possible errormessages:
011 Cost estimate number missing
045 Incorrect price
060 Negative stock balances not allowed
063 Material ledger record does not exist for the current period
066 Material ledger currency record does not exist for current period
500 Actual quantity not equal to total of stocks
501 Actual quantity not equal to total of valuation types
In the event of incorrect stock data, contact the SAP hotline as soon aspossible and specify the error number.