Kontakt

Ansicht
Dokumentation

RM07KO01_ALV - Stock Consistency Check

RM07KO01_ALV - Stock Consistency Check

CL_GUI_FRONTEND_SERVICES - Frontend Services   Vendor Master (General Section)  
This documentation is copyright by SAP AG.
SAP E-Book

Description

With the Stock Consistency Check report (RM07KO01_ALV), you can check the consistency of your stock data at company code level, valuation level, or material level. Possible errors in your stocks can thus 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 the following:
  • If the quantity of the total valuated stock matches the sum of the individual 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 no negative stocks are permitted in Customizing

  • If there is a value when the corresponding material has zero stocks

  • The quantity of the total valuated stock matches the sum of the individual lower-level segments of this stock

  • Per material, the total valuated stock of the sum of all valuation types corresponds 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 the material (table CKMI1)
  • If the material ledger is active, the tables in inventory management match the tables in the material ledger note:

Note:
We recommend that you start this report regularly, for example once per month after period close, or during year-end closing tasks. To do so, choose Periodic Processing -> Consistency Check..

Using the No Unrealistic Prices checkbox, you can deactivate error message 045, "Unrealistic Total Value". Since this error message can appear as a result of rounding differences, you can deactivate it in order to ensure a better overview in the output list. For more information on error message 045, and a correction possibility, see SAP note 1026379.

Requirements

Output

If the report finds stock data with errors, it outputs a list with the following 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
  • Comments on the material and incorrect tables

If you select a material, you can go to the detail screen by choosing Edit -> Choose.

For a material that is blocked at the time of the consistency check, the system informs you that it was not checked. You can subsequently check blocked materials manually from the list. To do this, select the material and choose Edit -> Check Material. If the material is still blocked by a posting, the program issues the message that it was not able to block the material. In this case, you should repeat the manual check a few minutes later.

For split-valuated materials, the system displays the total valuated stock and the total stock value in the Total Valuation Types line. Below this, all stock values are listed over which the total stock is distributed. For each stock value table MBEW <Material number>, you can display the stock in the corresponding valuation type.

For valuated sales order stock EBEW <sales order number> and project stock QBEW <project number>, you can display the relevant stock in detail.

The system notifies you during the check if a material does not have a cost estimate number. Without a cost estimate number, a complete stock analysis is not possible for a material. In this case, you should allow the system to assign a cost estimate number automatically to enable a document analysis for stock data containing errors. Alternatively, if you cancel the check, you can subsequently assign the missing cost estimate numbers from the list of stock data with errors using Edit -> Assign Costing No..

From the Environment menu, for each material you can do the following:

  • Display 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

What to do if the report finds inconsistencies

If the report finds stock data with errors, check each material to determine whether the error is long-term by choosing Edit -> Check Material.

If the error is long-term, in the detail view for each material you can find out which errors the report found. Examples of possible error messages:
011 Cost estimate number missing
045 Unrealistic total value
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

For information on the reason for error message 045, and a correction possibility, see SAP note 1026379.

In the event of incorrect stock data, contact the SAP hotline as soon as possible and specify the error number.

Example






BAL_S_LOG - Application Log: Log header data   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Length: 8021 Date: 20240531 Time: 144157     sap01-206 ( 115 ms )