Determining Lowest Value: Range of Coverage 

  1. Call up the transaction as follows:
  2. Menu Path

    Logistics ® Materials Management ® Valuation ® Balance Sheet Valuation ® Determination of Lowest Value ® Range of Coverage

    Transaction Code

    MRN1

  3. Enter the following data:
  4. Field

    Data

    Company code

    1000

    Material number (from)

    500-120

    Material number (to)

    500-220

    Valuation area

    1100

  5. In the Det. of range of coverage area, choose Material stocks.
  6. In the dialog box, enter the following data:
  7. Field

    Data

    Lower limit

    01.01. of the previous year

    Upper limit

    Today’s date

  8. Choose .
  9. Choose Material consumption.
  10. In the dialog box, you can see that the material consumption is taken straight from the consumption statistics.

  11. Choose .
  12. In the Update material master area, select Database update and choose Change material price.
  13. In the Automatic Price Change dialog box, select Direct Update and choose .
  14. Choose Update phys.inv.prices. In the dialog box, select Tax price 1 and Commercial price 1. Choose .
  15. Choose List format.
  16. In the dialog box, select the Output Details and Normal List fields. Choose .
  17. Choose .
  18. The system displays a list of the materials with the percentage deductions, as well as the determined lowest prices. Compare the new prices with the prices you noted previously.

  19. Choose until the overview tree appears.