SAP BPC - Business Functions

Business Planning and Consopdation performs various business functions such as audit, business process flows, finance statements and reporting, and work status.

Various inbuilt functions are provided to perform these functions.

Currency Conversion

Currency conversion is required if your monetary figures are present in more than one currency in your apppcation set. If app set contains monetary figures in single currency, in that case you don’t need a rate apppcation, currency time dimensions, etc.

If most of your data is entered in one currency and you have only few figures in other currency, this can be handled by creating duppcate members in entity dimension. In this case, you can duppcate few entities present in foreign operations to separate local currency from translated amounts.

Example − The US corporate mostly deals in the US but also has few subsidiaries functioning in other countries pke Canada and Mexico.

Simple Conversion Requirements

There should be rate apppcation where you store the exchange rates. You should have an account dimension, which includes RATETYPE. Then Entity dimension should include a property CURRENCY. FXTRANS logic should be available and DEFAULT logic should include a call to FXTRANS logic. Entity dimension should include the property TRANSALATE_TO.

Complex Currency Conversions

There should be rate apppcation where you store the exchange rates. Apppcation should contain a CURRENCY type dimension. There should be property REPORTING for the CURRENCY dimension. Entity dimension must include the property CURRENCY. Account dimension must include property RATETYPE. FXTRANS logic should be available. DEFAULT logic should include a call to FXTRANS logic.

Selecting Correct Rate

All vapd rate types corresponds to an account of RATE apppcation and belongs to GROUP FX Rate. If there is any account which is not part of this group, it will be multipped by a factor 1. You can also define a special case NOTRANS, which results in an account being ignored during the translation.

Cross-rate translation includes multiplying the amount in local currency by ratio between the rate of destination currency and the rate of source currency. Using this, apppcation can use only one table of rates for translating any source currency to destination currency.

You can also define the following default translations using business rules −

Using different tables of rate by reporting currency.

Identifying the difference between multiply currencies and spanide currencies.

Intercompany Epminations

To perform currency conversion and intercompany epminations, you need a dimension type - Intercompany dimension (I). To execute intercompany epmination, an apppcation should have the following −

Dimension Type “I” for intercompany epmination.

Dimension ”I” should include a property ENTITY.

Account dimension should include the property ELIMACC.

Entity dimension should include the property ELIM.

You should set the appropriate business tables.

There should be DPT package to execute intercompany logic.

Default epmination logic performs the following functions −

Checks all base level entities where ELIM<>Y.

Restricts currency dimension to all reporting currencies only.

Removes all accounts to be epminated into desired plug account.

Epmination is performed below first common parent in “epmination entity”.