Converting Currency

1. Create the attributes used for the currency conversion using the Attributes app. Use the values in the following table.

   Name	Name	Type	Length
   I##CURRID	Currency From##	NVARCHAR	20
   I##CURRDESCR	Currency Description##	NVARCHAR	40
   I##CURRTOID	Currency To##	NVARCHAR	20
   I##CURRTODESCR	Currency To Description##	NVARCHAR	40
   I##EXCHGRATE	Exchange Rate##	DECIMAL	18, 6

   1. Open the SAP Fiori launchpad and proceed to the Model Configuration group.

   2. Choose Attributes tile.

   3. To create the attributes, choose New → New Attribute and fill the fields with the information provided in the table.

   4. To add the attribute, choose Save and New. Repeat for all the attributes.

   5. Choose Save.

2. In the app Master Data Types, create the simple master data type I##CURRENCY using the following details.

   Field	Value
   Name	Currency From
   Description	Currency From
   Master Data Type	Simple
   ATTRIBUTES:
   I##CURRID	Selected (Key)
   I##CURRDESCR	Selected

   1. In the Model Configuration group, choose Master Data Types.

   2. Choose New, then Simple.

   3. In the ID field, enter I##CURRENCY.

   4. Enter Currency From as the Name and Description.

   5. Choose Add, select the checkboxes for the attributes I##CURRDESCR and I##CURRID, and select I##CURRID as the key/root.

   6. Choose Save.

3. Create the reference master data type I##CURRENCYTO using the following data:

   Field	Value	Reference Attribute
   Name	Currency To
   Description	Currency To
   Master Data Type	Reference
   Reference Master Data Type	I##CURRENCY
   ATTRIBUTES:
   I##CURRTOID	Key	I##CURRID
   I##CURRTODESCR		I##CURRDESCR

   1. In the Model Configuration group, choose Master Data Types.

   2. Choose New, then Reference.

   3. In the ID field, enter I##CURRENCYTO.

   4. Enter Currency To as the Name and Description.

   5. In the Reference Master Data Type field, assign I##CURRENCY.

   6. Choose Add, select the checkboxes for the attributes I##CURRTODESCR and I##CURRTOID.

      Note

      When I##CURRID is assigned as a reference of I##CURRTOID, the KEY (root) is automatically checked.

   7. Assign I##CURRID as the reference attribute for I##CURRTOID, and assign I##CURDESCR as the reference attribute for I##CURRTODESCR.

   8. Choose Save.

4. Create the master data type I##EXCHANGERATE as a compound master data type of I##CURRENCY and I##CURRENCYTO using the following details:

   Field	Value	Simple Master Data Types
   Name	Exchange Rate
   Description	Exchange Rate
   Master Data Type	Compound
   Add Simple Master Data Types:		I##CURRENCY
   		I##CURRENCYTO
   ATTRIBUTES:
   I##CURRID	Key
   I##CURRTOID	Key
   I##EXCHGRATE

   1. In the Model Configuration group, choose Master Data Types.

   2. Choose New, then Compound.

   3. In the ID field, enter I##EXCHANGERATE.

   4. Enter Exchange Rate as the Name and Description.

   5. In the Component Master Data Types, choose Add, and choose I##CURRENCY, and I##CURRENCYTO from the list.

   6. Choose Select.

      The root attributes from the simple master data types are automatically added and selected as keys; I##CURRID and I##CURRTOID.

   7. In Assigned Attribute table, choose Add and choose I##EXCHGRATE from the dropdown list. Choose Select.

   8. Choose Save.

1. Open the T## planning area and assign the simple master data types I##CURRENCY and I##CURRENCYTO to the planning area.

   1. In the Model Configuration group, choose Planning Area Model Configuration tile.

   2. Select your T## Planning area in the left column.

   3. Go to Attributes tab.

   4. Select Add on the toolbar.

   5. Select I##CURRENCY and I##CURRENCYTO from the list to assign them to your planning area.

   6. Choose Add. Stay in your T## Planning Area configuration screen.

In this course, instructions mostly call for creating planning levels from scratch (we also have a very small model, so there aren’t many planning levels). On real engagements, most planning levels are created from other planning levels by copy, which is more time efficient.

1. Create the PERCURRCURRTO planning level, which will be the base planning level for the exchange rate. Use the following details:

   Field	Value	Root	Conversion Source	Conversion Target
   ID	PERCURRCURRTO
   Description	Period / Currency / Currency To
   Time Attributes
   √	PERIODID (add via Change Assignment)
   √	Monthly	√
   √	Quarterly
   √	Year
   Attributes
   I##CURRENCY
   √	I##CURRDESCR
   √	I##CURRID	√	√
   I##CURRENCYTO
   √	I##CURRTODESCR
   √	I##CURRTOID	√		√

   1. On the T## screen, choose the Planning Levels tab.

   2. Choose New, select lowest time profile level 1-Monthly and choose OK.

   3. Enter the ID and description.

   4. Select the master data types indicated in the table.

   5. Select the Conversion Source and Conversion Target indicators as in the table.

   6. Choose Save. Remain on that screen.

2. Create the PERPRODCUSTCURR planning level, which will be the base planning level for the Target Rev key figure. Use the following details.

   Field	Value	Root
   ID	PERPRODCUSTCURR
   Description	Period / Product / Customer / Currency
   Time Attributes
   √	PERIODID (add via Change Assignment)
   √	Monthly	√
   √	Quarterly
   √	Year
   Attributes
   I##CURRENCY
   √	I##CURRDESCR
   √	I##CURRID	√
   I##CUSTOMER
   √	CUSTDESCR
   √	CUSTID	√
   √	CUSTREGION
   I##PRODUCT
   √	PRDID	√
   √	PRDFAMILY
   √	PRDDESCR
   √	ABCCODE

   1. On the top left hyperlink to your planning area and from main Planning Levels tab, select New.

   2. Choose New, select lowest time profile level 1-Monthly and choose OK.

   3. Enter the ID and Description, and validate Time Attributes displayed.

   4. Select Add and add Master Data Types shown in the table.

   5. Choose Save. Remain on that screen.

3. Create the PERPRODCUSTCURRCURRTO planning level, which will be the base planning level for the Target Rev key figure. Use the following details.

   Field	Value	Root
   ID	PERPRODCUSTCURRCURRTO
   Description	Period / Product / Customer / Currency / Currency To
   Time Attributes
   √	PERIODID (add via Change Assignment)
   √	Monthly	√
   √	Quarterly
   √	Year
   Attributes
   I##CURRENCY
   √	I##CURRDESCR
   √	I##CURRID	√
   I##CURRENCYTO
   √	I##CURRTOID	√
   √	I##CURRTODESCR
   I##CUSTOMER
   √	CUSTDESCR
   √	CUSTID	√
   √	CUSTREGION
   I##PRODUCT
   √	PRDID	√
   √	PRDFAMILY
   √	PRDDESCR
   √	ABCCODE

   1. On the top left hyperlink to your planning area and from main Planning Levels tab, select New.

   2. Choose New, select lowest time profile level 1-Monthly and choose OK.

   3. Enter the ID and Description, and validate Time Attributes displayed.

   4. Select the Master Data Types as shown in the table.

   5. Choose Save.

1. Set I##EXCHGRATE as Attribute as key Figure and assign the PERCURRCURRTO planning level. Use the following details.

   Master Data Type	Attribute	Key Figure/Period	From/To Period
   I##EXCHANGERATE
   	I##EXCHGRATE	✓
   		From	-6
   		To	12

   1. In the Planning Areas Model Configuration tab select your planning area, T##, in the left column.

   2. Go to Attributes as Key Figure tab and choose New.

   3. Search in the Attributes field and select I##EXCHGRATE.

   4. Assign the PERCURRCURRTO planning level.

   5. Assign the From period and To period as provided in the table.

   6. Choose Save.

2. Make the following settings for the I##EXCHNGRATE key figure.

   Field	Value
   Stored	√
   Edit Allowed	Editable in the Current or Future
   Aggregation Mode	Avg
   Disaggregation Mode	Copy Value

   1. Transition to Key Figures tab.

   2. In the left column, select your I##EXCHGRATE key figure.

   3. Choose Edit.

   4. Enter the settings from the table.

   5. Choose Save.

3. Check that the calculation of the Request level is the Avg of the PERCURRCURRTO level and the input is stored.

   I##EXCHGRATE@REQUEST = AVG("I##EXCHGRATE@PERCURRCURRTO")

   Key Figure	Select as Input	Stored
   I##EXCHGRATE	√	√

   1. Check the request level calculation that was created automatically. It should appear as shown in the step.

   2. Choose Edit to work with that calculation.

   3. Choose Inputs and ensure that I##EXCHGRATE is selected as an input and selected as Stored.

   4. Choose OK.

   5. Choose Validate.

   6. Choose Save.

4. Create a new key figure called TARGETREVENUE using the following data.

   Field	Value
   Key Figure ID	TARGETREVENUE
   Name	Target Revenue
   Base Planning Level	PERPRODCUSTCURR
   Stored	√
   Edit Allowed	Editable in the Current or Future
   Aggregation Mode	Sum
   Disaggregation Mode	Equal distribution
   Proportionality	Same Key Figure - Stored Values
   Convert Using	I##EXCHGRATE

   1. Choose the Key Figures tab within your planning area T##.

   2. Choose New.

   3. Enter the Key Figure ID and choose OK.

   4. Enter the remaining data from the table and ensure that the Convert Using value is assigned.

   5. Choose Save. Remain in that screen.

5. Add the calculation so the Target Revenue is calculated by the stored value times the exchange rate.

   TARGETREVENUE@PERPRODCUSTCURRCURRTO =

   "TARGETREVENUE@PERPRODCUSTCURR" * "I##EXCHGRATE@PERCURRCURRTO"

   Key Figure	Select as Input	Stored
   I##EXCHGRATE	√	√
   TARGETREVENUE	√	√

   1. On the Target Revenue Key Figure screen choose Edit on top right.

   2. Choose Add Calculation Definition.

   3. Enter the calculation shown in the step.

   4. Choose Inputs and ensure that I##EXCHGRATE and TARGETREVENUE are selected as input and selected as Stored.

   5. Choose Validate.

   6. Choose Save.

6. Change the Request level calculation for TARGETREVENUE so that it is the sum of the PERPRODCUSTCURRCURRTO level.

   TARGETREVENUE@REQUEST = SUM("TARGETREVENUE@PERPRODCUSTCURRCURRTO")

   Key Figure	Select as Input	Stored
   TARGETREVENUE@PERPRODCUSTCURRCURRTO	√

   1. To change the calculation, in the Request level calculation box, choose Edit on the toolbar.

   2. Change the planning level for TARGETREVENUE in the calculation box.

   3. Choose Inputs and ensure that TARGETREVENUE is selected as an input and is presented as Calculated.

   4. Choose Validate.

   5. Choose Save.

1. Activate your T## planning area and select the Full Scope with Dependencies.

   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.

1. Load data into your new I##CURRENCY and the Exchange Rate master data types using the information in the following table:

   Field	Value
   Data Type	Master Data
   Data Name	Currency From (I##CURRENCY)
   File Selection	7_Currency##.csv
   Separator	,
   Operation Type	Insert/Update
   Job Name	I##CURRENCY

   1. Locate the data files provided by your instructor in My Documents in the WTS.

   2. On the SAP Fiori Homepage of the Web UI, choose the Data Integration Jobs tile.

   3. At the bottom left of the screen, choose + (Add) and enter the data provided in the table.

   4. Choose Save and ensure that the data is successfully loaded.

   5. Repeat the above steps to load data into the Exchange Rate master data type (use file 7_Exchange##.csv).

2. Load data into your Target Revenue key figure using the information from the following table:

   Field	Value
   Data Type	Key Figures
   T## Planning Area	T##
   Version	Baseline ()
   File Selection	7_Target Revenue##.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. On the SAP Fiori home page of the Web UI, choose the Data Integration tile.

   3. At the bottom left bottom of the screen, choose + (Add) and enter the data provided in the table.

   4. Choose Save and ensure that the data is successfully loaded.

1. Test your solution by creating a Workspace using the information from the table. After you view the data, choose Settings and change the currency to view the data in another currency.

   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
   Currency To Description	Selected

   Use the following values for Key Figures:

   Field	Value
   Target Revenue, Exchange Rate##	Selected
   I##CURRTOID	USD

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

   8. Return to the Planner Workspaces app and choose Planning View.

   9. Select the copied content.

   10. Complete the dialog box with the information provided in the table.

   11. To display the planning view, choose Apply.

2. Test the from/to period setting for the exchange rate attribute as a key figure. Expand the workspace to include the last year, and check that the exchange rate is not included past the setting.

   1. Edit the workspace to cover the last year plus next year.

   2. Check that the exchange rate is not included beyond the last 6 months.

   3. Select another currency in I##CURRTOID field and observe the effects.

   4. On the top right, choose Workspace → Save.