How to Create a Currency Rate Table in SAP Analytics Cloud

In SAP Analytics Cloud, the rate table contains the currency conversion factor to convert an amount from denominations of one currency to denominations in another currency.


In this post, let’s look at the steps to create a rate table in SAP Analytics Cloud.


Navigate to the Modeler, as shown in the figure below, and go into the Currency Conversions tab (1). On the Currency Conversions tab, click on + to create the currency conversion table (2). On the popup that opens, enter the Name and Description of the new rate table (3). Click the Create button.


Create Currency Conversion Table


It’s also possible to upload the rate table from an SAP Business Planning and Consolidation rate model in a hybrid scenario by choosing From an SAP BPC Import in the Currency Conversions tab.


Once the rate table is created, populate the following fields shown in this figure.


Manage Currency Conversion Rate

  • Source Currency/Target Currency: These fields define the source and the target currencies for which the conversion rate is being input.
  • Valid From: Defines the date from which the conversion rate mentioned is valid. It’s interesting to note here that there is no field that defines the date until which the rate is valid. This means that if only one rate is mentioned for a combination of source and target currencies, category, and rate type, that will be deemed valid for all future years.
  • Category: This field gives you the ability to define version-specific exchange rates. If no category is mentioned, the rates are deemed valid for every category.
  • Rate Version: This field gives you the flexibility to define different rate versions of exchange rates and view figures in these different rate versions. It’s particularly useful in scenarios where you need to take exchange rate fluctuations into consideration when developing plans. There can be multiple rate versions defined for the same category of data.
  • Rate Type: This field allows you to define whether the exchange rate is an average for the month or whether it’s the month-end rate.

Editor’s note: This post has been adapted from a section of the SAP Analytics Cloud: Financial Planning and Analysis by Satwik Das, Marius Berner, Suvir Shahani, and Ankit Harish.


SAP Analytics Cloud: Financial Planning and Analysis
SAP Analytics Cloud: Financial Planning and Analysis

FP&A is now in the cloud! In this comprehensive guide, begin by provisioning your data for financial planning and analysis in SAP Analytics Cloud. Then follow step-by-step instructions to set up the planning process and use SAP Analytics Cloud’s automated planning logic to calculate key metrics. Learn how to perform simulations to model what-if scenarios, streamline your planning workflow, and share results with stakeholders. With details on implementation best practices, this is your all-in-one resource!

Learn More

SAP PRESS is the world's leading SAP publisher, with books on ABAP, SAP S/4HANA, SAP CX, intelligent technologies, SAP Business Technology Platform, and more!