SAP BPC Business Functions - SAP BPC

What is SAP BPC Business Functions?

Business planning and Consolidation performs various business features including audit, business technique flows, finance statements and reporting, and work status.
Various built in functions are provided to carry out these functions.

Currency Conversion

Currency conversion is needed if your monetary figures are present in more than one currency to your application set. If app set contains monetary figures in single currency, if so you don’t want a rate application, currency time dimensions, etc.
If maximum of your information is entered in a single currency and you have only few figures in other currency, this will be handled by developing replica individuals in entity dimension. In this case, you may replica few entities present in foreign operations to split local currency from translated amounts.

Example − the us company generally deals inside the US but additionally has few subsidiaries functioning in different countries like Canada and Mexico.

Simple Conversion Requirements

There need to be rate application where you save the alternate rates. You must have an account size, which includes RATETYPE. Then Entity size should include a property currency. FXTRANS logic must be available and DEFAULT logic have to include a name to FXTRANS logic. Entity dimension should include the property TRANSALATE_TO.

Complex Currency Conversions

There need to be rate application wherein you save the alternate rates. application must include a currency kind dimension. There need to be assets REPORTING for the currency dimension. Entity dimension need to consist of the assets currency. Account size have to consist of assets RATETYPE. FXTRANS logic should be to be had. DEFAULT logic need to include a name to FXTRANS logic.

Selecting Correct Rate

All valid rate types corresponds to an account of rate application and belongs to organization FX rate. If there may be any account which isn't part of this organization, it will be increased by means of a issue 1. you can also outline a unique case NOTRANS, which results in an account being ignored during the translation.

Cross-rate translation consists of multiplying the amount in local currency through ratio between the rate of destination currency and the rate of source currency. the use of this, utility can use best one table of rates for translating any supply currency to destination currency.

You can also define the following default translations the use of business rules −

• Using special tables of rate by reporting currency.
• Identifying the difference between multiply currencies and divide currencies.

Intercompany Eliminations

To perform currency conversion and intercompany eliminations, you want a dimension type - Intercompany size (I). To execute intercompany removal, an utility need to have the following −

• Dimension type “I” for intercompany removal.
• Dimension”I” need to consist of a property ENTITY.
• Account size should consist of the property ELIMACC.
• Entity size should consist of the assets ELIM.
• You need to set the appropriate business tables.
• There must be DPT package to execute intercompany logic.

Default elimination 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 eliminated into desired plug account.
• Elimination is performed below first common parent in “elimination entity”.