CONFIGURATION OF CURRENCY CONVERSION IN SAP IBP
Configuration of currency conversion in SAP IBP
Configuration of currency conversion in SAP IBP
SAP IBP can convert currency on the fly, for example, when a user of Microsoft excel add-in or analytics selects target currency at runtime for a key figure, such as sales forecast revenue. The prerequisite for currency conversion are that exchange rates exists in the system and that a currency conversion calculation has been defined for the key figure involved.
How Currency conversion works in the system
Currency is configured in the system by adding currency and exchange rate attributes. The idea is to create a reference table containing the original currency (Currency ID) and the converted currency (Currency To ID), with the corresponding exchange rates included.
Procedure for currency conversion
1.Create attributes
2.Create simple master data type for currency
Add attributes T91CURRID and T91CURRIDDESC and mark T91CURRID as key.
3.Create reference master data type for “Currency to”
Add attributes T91CURRTOID and T91CURRTOIDDESC and mark T91CURRTOID as key.
Give the respective reference attributes.
4.Create compound master datatype for “Exchange”
Add attributes T91CURRID, T91CURRTOID and T91EXCHANGERATE.
5.Add master data types to the respective planning area
6.Create planning level “T91MTHCURRCURRTO”.
Create planning level and assign the master data types T91CURR and T91CURRTO
7.Create planning level T91MTHPRODCUSTCURR
8.Create planning level T91MTHPRODCUSTCURRCURRTO
9.Define “attribute as key figure” for attribute T91EXCHANGERATE.
10.Create key figure T91BUDGETREV
a) Add base planning level as T91MTHPRODCUSTCURR.
b) Add “Convert using” as T91EXCHANGERATE/
c) Add the required calculation given above.
11.Load currency master data in SAP IBP excel add-in.
12.Load Exchange master data in SAP IBP excel add-in.
13.View the currency conversion in SAP IBP Excel add-in.
Author
Omkar Kalbhor
SAP IBP Consultant, Baranwal Consultancy and Services (BCS), Pune, Maharashtra, India