Automate the Loading of Currency Exchange Rates to BPC, SAP NetWeaver Version
- by Ashish Narway, Senior Consultant, Planning and Consolidation and Business Intelligence
- June 27, 2012
Through written instruction and a collection of video demos, learn how to automate the extraction of foreign currency exchange rates from SAP ERP Central Component to SAP Business Planning and Consolidation, version for SAP NetWeaver.
The rate application is an integral part of the SAP BusinessObjects Planning and Consolidation application set. It stores the currency conversion rates used for translation to reporting or group currency. The actual and planned data in local currency is translated to reporting or group currency using conversion rates. Rate application is defined as a reference application for a planning or consolidation application.
Most of the time, foreign currency exchange (FX) rates are maintained in SAP ERP Central Component (SAP ECC). Usually the same rates are used in SAP Business Planning and Consolidation (BPC) for planning and consolidation applications.
In certain scenarios, some FX rates are maintained only in BPC.
The BPC administrator has to extract the FX rates on a periodic basis from SAP ECC to the rate application. This is usually a manual process with some degree of automation based on a custom solution. These solutions require you to log on to an external system (i.e., SAP ECC or SAP NetWeaver BW) to trigger the extraction. They involve additional activities to transform and move the data to a state in which you can load it to the BPC rate application. (See the sidebar “Three Custom Solutions and their Drawbacks” for a description of them.)
The BPC version of SAP Netweaver as of now does not have a feature or an automated tool that can help load exchange rates from SAP ECC system or SAP Netweaver BW. In this article, I use the SAP Netweaver BW system as a source to extract the exchange rates. The exchange rates in SAP NetWeaver BW are replicated from SAP ECC on a daily basis using a job-based ABAP program, RSIMPCURR. This keeps the data in SAP Netweaver BW synchronized with SAP ECC.
Instead you can use a custom method I devised that allows you to automate the extraction of FX rates from SAP ECC in real time. You can trigger, automate, and monitor the extraction within the BPC Administrator console, thus relieving the BPC administration from a manual process and reducing the chances of manual errors.
Would you like to see this full item?