Creating Historical Data

Historical data is generally updated in the material master record when stock is withdrawn from the warehouse. However, it is also possible to enter historical data manually, which then forms the basis of the initial forecast.

There are two types of historical data (consumption values) in the material master record: total consumption and unplanned consumption values.

Total consumption is the total of planned and unplanned consumption. For materials planned according to the consumption-based planning procedure, it is always the total consumption that is updated.

Unplanned consumption is only updated for materials that are planned according to MRP,

When withdrawing a material that is planned according to the MRP procedure on the basis of a reservation, only the planned consumption is updated. This value is not recorded in the material master record but, instead, it must be calculated by the user by subtracting unplanned consumption from total consumption.

This is how you enter consumption values manually:

  1. In the Forecasting or Material Requirements Planning screen that you have already filled in, specify whether the consumption values are managed in days, weeks, or months by filling in the Period indicator field.
  2. In the Forecasting screen, check the proposed values in the area Number of periods required, and change or add to them as necessary.
  3. Select Details ® Consumption.
  4. The consumption values entry screen appears.

  5. Enter your consumption values, starting from the current period and working backwards.
  6. You can enter as many values as you want, both for total consumption and for unplanned consumption. Switch between the total consumption and unplanned consumption entry screens with Edit ® Unplanned consumption or Total consumption.

    If you want to enter more values than there is room for on the first screen, press F23 to obtain further empty lines.

  7. Store the data in the system with Material ® Save.