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

Do the following to customize the additional key figures for your planning step:

• Define average retail as an additional key figure for your planning step by selecting one of the possible average retail key figures.
• Define the time interval to be used as the basis for the calculation.
• Select Calculate average or No total, average (copy last) for non-time-based aggregation. For time-based aggregation, select Average or First period entry (detailed information screen for additional key figures).

Do the following to run Customizing for Merchandise and Assortment Planning, under Average Retail Parameter:

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. 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.

Implementing average retail in manual planning:

In addition to the general settings, the following information is important for implementing average retail in manual planning:

Average retail is used as a key figure in the planning layout. Define the following for the layout:

• Use the following key figure formula to convert values into quantities for each quantity key figure:

• Use the following key figure formula to convert values into quantities for each value key figure:

Implementing average retail in manual planning:

You can also use automatic planning to calculate average retail. 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 as a 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:

• S216 for storing data in a weekly periodicity
• S217 for storing data in a monthly periodicity
• S218 for storing data for particular posting periods

In addition to the general settings, the following information is important when implementing average retail in 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).