Converting Price

Key Figure Name	Price
Key Figure ID	PRICE
Base Planning Level	PERPRODCUSTCURR
Convert Using	EXCHANGERATEBYUOM

Business Example

In your role as a project manager, you configure price conversion in SAP Integrated Business Planning for Supply Chain to calculate average and weighted forecast price.

This exercise explains the use of exchange rate and UOM conversion factor to calculate average and weighted forecast price. Two input key figures, Sales Forecast Qty and Forecast Price are used to calculate sales forecast revenue. Weighted forecast price is calculated with the help of sales forecast revenue and quantity. Finally, weighted forecast quantity and average forecast prices are compared.

When the values include ##, replace the characters with the number that your instructor has assigned to you.

Task 1: Create Configuration Objects

Steps

To configure Price Conversion in our T## planning area, we need the following master data types. Because we have already created these master data types in previous exercises, no additional master data types are necessary.

Master Data Type Name	Attributes	Master Data Type Simple, Compound, or Reference
I##PRODUCT	PRDID	Simple
	PRDFAMILY
	I##UOMID
	I##UOMDESC
I##CUSTOMER	CUSTID	Simple
	CUSTREGION
I##UOMTO	I##UOMTOID	Simple
	I##UOMDESC
I##CURRENCY	I##CURRID	Simple
	I##CURRDESC
I##CURRENCYTO	I##CURRTOID	Reference
	I##CURRTODESC
I##UOMCONVERSION	PRDID	Compound
	I##UOMTOID	I##PRODUCT+I##UOMTO
	I##UOMCONVFACTOR

Ensure that the following planning levels are all created. Otherwise, create them.

Planning level	Key
PERCURRCURRTO	PERIODID I##CURRID I##CURRTOID
PRODUOMTO	PRDID I##UOMTOID
PERPRODCUST	PERIODID PRDID CUSTID
PERPRODCUSTCURR	PERIODID PRDID CUSTID I##CURRID
PERPRODCUSTCURRCURRTO	PERIODID PRDID CUSTID I##CURRID I##CURRTOID
PERPRODCUSTCURRCURRTOUOMTO	PERIODID PRDID CUSTID I##CURRID I##CURRTOID I##UOMTOID

In the Planning Area Model Configuration app, ensure that your I## Planning area is selected at the left.
Choose Planning Levels on the toolbar.
In the Planning Levels tab, scroll thru the list of the levels and confirm that all are created.

The only planning level we have not created yet is the PERPRODCUSTCURRCURRTOUOMTO. Create this planning level using the following data.

Field	Value	Root
ID	`PERPRODCUSTCURRCURRTOUOMTO`
Description	`Period / Product / Customer / Currency / Currency To /UOM To`
Master Data Type
√	PERIODID (add via `Change Assignment)`
√	`Monthly`	√
√	`Quarterly`
√	`Year`
I##PRODUCT
√	`PRDID`	√
√	`PRDDESCR`
√	`PRDFAMILY`
√	`I##UOMID`
√	`I##UOMDESCR`
√	`ABCCODE`
I##CUSTOMER
√	`CUSTID`	√
√	`CUSTDESCR`
√	`CUSTREGION`
I##CURRENCY
√	`I##CURRTODESCR`
√	`I##CURRID`	√
I##CURRENCYTO
√	`I##CURRTODESCR`
√	`I##CURRTOID`	√
I##UOMTO
√	`UOMTOID`	√
√	`UOMTODESCR`

In the Planning Levels tab, choose New.
Select Lowest Time Profile Level, enter the ID and description, and start adding Attributes.
Select the master data types indicated in the table and choose keys.
Choose Save.

You need the following key figures for price conversion and we have already created the first 3 in previous exercises:

I##EXCHNGRATE
I##UOMCONVFACTOR
TARGETQTY
FORECASTPRICE
TARGETREVENUE
FORECASTPRICEWTD

Create a new key figure called FORECASTPRICE with the following data.

Field	Value
Key Figure ID	`FORECASTPRICE`
Base Planning Level	`PERPRODCUSTCURR`
Name	`Forecast Price`
Description	`Calculated as average at request level`
Stored	`√`
Edit Allowed	`Editable in the Current or Future`
Aggregation Mode	`Avg`
Disaggregation Mode	`Copy Value`

In the Planning Areas Model Configuration app and select your planning area, T##, at the left.
Go to Key Figures tab.
Choose New.
And choose Key Figure in the dropdown.
Enter the Key Figure ID, Name, Description and Base Planning Level in the General Section.
Enter the remaining data from the table and ensure that the Convert Using value is assigned to I##EXCHGRATE.
Choose Save.

Add the following calculation to the FORECASTPRICE key figure:
FORECASTPRICE@PERPRODCUSTCURRCURRTO = "FORECASTPRICE@PERPRODCUSTCURR" * "I##EXCHGRATE@PERCURRCURRTO"
Key Figure Select as Input Stored
FORECASTPRICE@PERPRODCUSTCURR √ √
I##EXCHGRATE@PERCURRCURRTO √ √
1. In the Forecast Price Key Figure screen, choose Edit.
2. Click to Add a Calculation Definition.
3. Enter the calculation shown in the step.
4. Select Inputs and validate that Input Key Figures are selected as Stored.
5. Validate the calculation.
6. Choose Save.
Add the following calculation to the FORECASTPRICE key figure:
FORECASTPRICE@PERPRODCUSTCURRCURRTOUOMTO = "FORECASTPRICE@PERPRODCUSTCURRCURRTO" / "I##UOMCONVFACTOR@PRODUOMTO"
Key Figure Select as Input Stored
FORECASTPRICE@PERPRODCUSTCURRCURRTO √
I##UOMCONVFACTOR@PRODUOMTO √ √
1. In the Forecast Price Key Figure screen, choose Edit.
2. Click to Add a Calculation Definition.
3. Enter the calculation shown in the step.
4. Select Inputs and validate that UOM Conversion Input Key Figure is selected as Stored.
5. Validate the calculation.
6. Choose Save.
Change the Request level calculation for FORECASTPRICE so that it is the average of the PERPRODCUSTCURRCURRTOUOMTO level.
FORECASTPRICE@REQUEST = AVG("FORECASTPRICE@PERPRODCUSTCURRCURRTOUOMTO")
Key Figure Select as Input Stored
FORECASTPRICE@PERPRODCUSTCURRCURRTOUOMTO √
1. In the Forecast Price Key Figure screen, choose Edit.
2. Click Edit in the Request level calculation space.
3. Change the calculation to the one shown in the step.
4. Select Inputs and validate that Input Key Figures is selected as Calculated.
5. Validate the calculation.
6. Choose Save.
Change the TARGETREVENUE key figure so that it is no longer stored, but calculated, and add the following calculation:
TARGETREVENUE@PERPRODCUSTCURR = "TARGETQTY@PERPRODCUST" * "FORECASTPRICE@PERPRODCUSTCURR"
Key Figure Select as Input Stored
TARGETQTY@PERPRODCUST √ √
FORECASTPRICE@PERPRODCUSTCURR √ √
1. In the Model Configuration group select Planning Areas Model Configuration app, and select your planning area, T##, at the left.
2. Go to Key Figures tab.
3. Click on the Target Revenue Key Figure.
4. Select Edit.
5. In the General area, deselect the Stored checkbox and select the Calculated checkbox. Accept the warning.
6. Scroll down and select Add Calculation Definition.
7. Enter the calculation shown in the step.
8. Select Inputs, ensure that both key figures are selected as an input and Stored.
9. Choose Validate.
10. Change the input of the calculation for TARGETREVENUE@PERPRODCUSTCURRCURRTO that we created in one of the previous exercises from stored to calculated.
11. TARGETREVENUE@PERPRODCUSTCURR is now calculated. Choose Edit next to that calculation and change the Inputs.
12. Choose Save.
Create a new key figure called FORECASTPRICEWTD using the following data:
Field Value
Key Figure ID FORECASTPRICEWTD
Base Planning Level PERPRODCUSTCURRCURRTOUOMTO
Name Forecast Price (Weighted)
Description Forecast Price (Weighted)
Calculated √
Edit Allowed Not Editable
1. In the Model Configuration group select Planning Areas Model Configuration app, and select your planning area, T##, at the left.
2. Go to Key Figures tab.
3. Choose New.
4. And choose Key Figure in the dropdown.
5. Enter the Key Figure ID, Name, Description and Base Planning Level in the General Section.
6. Enter the remaining data from the table.
7. Choose Save, if warning appears, choose Save Anyway.
Change the Request level calculation for FORECASTPRICEWTD so that it is the average of TARGETREVENUE divided by TARGETQTY:
FORECASTPRICEWTD@REQUEST = IF(ISNULL("TARGETQTY@REQUEST") OR "TARGETQTY@REQUEST" = 0, 0, "TARGETREVENUE@REQUEST" / "TARGETQTY@REQUEST" )
Key Figure Select as Input Stored
TARGETQTY@REQUEST √
TARGETREVENUE@REQUEST √
1. Remaining in the FORECASTPRICEWTD Key Figure screen, select Edit.
2. In the Request level calculation space, choose Edit.
3. Change calculations for FORECASTPRICEWTD on the right side of the calculation.
4. Choose Inputs and ensure that both key figures are selected as an input and that none is selected as Stored.
5. Choose Validate.
6. Choose Save.

Key Figure	Select as Input	Stored
FORECASTPRICE@PERPRODCUSTCURR	√	√
I##EXCHGRATE@PERCURRCURRTO	√	√

Key Figure	Select as Input	Stored
FORECASTPRICE@PERPRODCUSTCURRCURRTO	√
I##UOMCONVFACTOR@PRODUOMTO	√	√

Key Figure	Select as Input	Stored
FORECASTPRICE@PERPRODCUSTCURRCURRTOUOMTO	√

Key Figure	Select as Input	Stored
TARGETQTY@PERPRODCUST	√	√
FORECASTPRICE@PERPRODCUSTCURR	√	√

Field	Value
Key Figure ID	`FORECASTPRICEWTD`
Base Planning Level	`PERPRODCUSTCURRCURRTOUOMTO`
Name	`Forecast Price (Weighted)`
Description	`Forecast Price (Weighted)`
Calculated	`√`
Edit Allowed	`Not Editable`

Key Figure	Select as Input	Stored
TARGETQTY@REQUEST	√
TARGETREVENUE@REQUEST	√

Task 2: Activate the Planning Area

Steps

Activate your T## planning area.
1. If you have the key figure screen open, transition to the main menu of the planning area, by choosing the hyperlink at the top left and then Choose Activate → Full Scope with Dependencies.
2. Refer to the activation logs to ensure that your planning area is activated.
3. You may need to modify previously created planning levels by adding attributes to Product, in order to achieve union of attributes.

Task 3: Load Data into the New Forecast Price Key Figure

Steps

Load data into your new Forecast Price Key Figure using the information in the following table:
Field Value
Data Type Key Figures
Planning Area T## Training Planning Area (T##)
Version Baseline ()
File selection 9_Forecast Price##.csv
Separator ,
Operation Type Insert/Update
Job Name Key Figures
1. Locate the data files provided by your instructor in My Documents in the WTS.
2. Open the Forecast file in Notepad and ensure that the attributes (column headers) are matching the attributes that you created for your T## Planning area.
3. On the SAP Fiori home page of the Web UI, choose the Data Integration tile.
4. At the bottom left of the screen, choose + (Add) and enter the data from the table.
5. Choose Save and ensure that the data is successfully loaded.
Test your solution by creating a Workspace using the information from the table below:
Use the following values for Time:
Field Value
Time Period Monthly
From Current Month
To Current Month +12
Rolling Yes
Use the following values for Attributes:
Field Value
Product ID Selected
Customer ID Selected
Use the following values for Key Figures:
Field Value
Target Qty Selected
Target Revenue Selected
Forecast Price Selected
Forecast Price (Weighted) Selected
I##CURRTOID USD
I##UOMTOID EA
1. Choose Planner Workspaces app in the General Planner group.
2. Open the workspace 300_##.
3. On the top right, choose Workspace → Design.
4. Choose Settings on the top right of your existing planning view.
5. Under the More dialog (three dots), choose Manage Workspace Content.
6. Select your component and choose Copy.
7. Name your new planning view as Price Conversion.
8. Return to the Planner Workspaces app and choose Planning View.
9. Select the copied content.
10. Complete the settings with the information provided in the tables.
11. To display the planning view, choose Apply.
12. Choose Customize Components on the top right to change the I##CURRTOID or I##UOMTOID, and choose Apply to view the data.
13. When you will observe the effects of change to the another unit of measure or currency, choose Workspace → Save on the top right.

Converting Price

Price Conversion

Two Methods of Configuring Price Conversion in SAP Integrated Business Planning for Supply Chain

Aggregations that are Possible for These Methods

Price Key Figure

Demonstration: How to Configure Price Conversion

Configure Price Conversion

Business Example

Task 1: Create Configuration Objects

Steps

Task 2: Activate the Planning Area

Steps

Task 3: Load Data into the New Forecast Price Key Figure

Steps

Field	Value
Data Type	`Key Figures`
Planning Area	`T## Training Planning Area (T##)`
Version	`Baseline ()`
File selection	`9_Forecast Price##.csv`
Separator	`,`
Operation Type	`Insert/Update`
Job Name	`Key Figures`

Field	Value
Time Period	`Monthly`
From	`Current Month`
To	`Current Month +12`
Rolling	`Yes`

Field	Value
Target Qty	Selected
Target Revenue	Selected
Forecast Price	Selected
Forecast Price (Weighted)	Selected
I##CURRTOID	`USD`
I##UOMTOID	`EA`