Entering content frameFunction documentationImplementing Average Retail in Planning Locate the document in its SAP Library structure

You must make the following settings in your system before you can use the average retail key figure:

Actual data for calculating Average Retail can be updated in a maximum of two database currencies. This is particularly useful if you have two planning scenarios within your company for which you require two database currencies.

Example

Your company may, for example, use two scenarios when planning: one scenario for the US market, one scenario for the European market. The first scenario uses US$ as database currency, and the second uses €, the Euro. In this case, select both database currencies for the planning scenarios as the database currency for updating your planning data. You can use both database currencies when entering data for planning.

If you only require one database currency, one of the database currencies used for updating must be the same as the database currency for the planning scenario.

If you choose to use RIS, make the following settings in Customizing for Merchandise and Assortment Planning under Average Retail Parameters.

If this is the case, the average retail price that has already been calculated is stored in a database table. When you enter planning, the stored average retail price is uploaded, taking the selected data into consideration. Performance is improved when this method is used instead of RIS.

Note

Note that the standard system does not contain a method for calculating and storing average retail prices.

Implementing average retail in manual planning:

In addition to the settings detailed above, the following information should be taken into consideration at implementation during manual planning:

Average retail is integrated using the additional key figure in the planning layout. In your planning layout, enter the following:

Quantity = value / average retail

Value = quantity * average retail

Implementing average retail in automatic planning:

When implementing average retail if you use RIS, it may be useful to use automatic planning.

In addition to implementing average retail in manual planning that enables you to be able to see the results of the calculation, you can also calculate the average retail key figure using automatic planning. This is particularly useful if you are handling large volumes of data as you can run automatic planning in the background.

The following scenario is possible:

  1. You want to run value-based planning as manual planning. The planning data is saved in the info structure assigned to the planning step.
  2. Automatic planning is run overnight in the background. Average retail is then calculated based on the planning data from the info structure for the planning step, and the actual data from info structure S216. Average retail is then used to convert the planning values into quantities. They new data is then saved in the info structure for the planning step.
  3. When the background job is completed, open a planning layout for the planning step. The planning data from the quantity-based planning data can be displayed so that you can continue running your planning.

The following info structures are delivered as standard and provide the actual data for calculating average retail:

In addition to the settings detailed above, the following information should be taken into consideration at implementation during automatic planning:

  1. Select planning activity SAP Copy Management (detailed view for automatic planning).
  2. Create a copy method in Customizing for SAP Copy Management. You can use this method to convert quantities into values and vice versa. Call function module WIS_PLAN_ZUSKZ_AVERAGE_RETAIL to define average retail within the copy method (compare this to copy method R041 and R042 for Best Practice Scenario 1_SAP).

 

 

Leaving content frame