Skip to Content

Loading of data in Historical rates in SAP BPC NW 10:

In Consolidation, for some accounts like Investments, Equity etc. it may be required to load the data at historical rates

It is possible to maintain (HIST) historical rates in Exchange Rate tables in BPC NW 10 and system to convert the LC into GC at historical rates. However, if there are large of number of accounts with different historical rate for different accounts, this option becomes not only cumbersome but also error prone.

In order to overcome this, SAP has suggested the following option as detailed below:

1.Calculate the historical value of each equity account and the corresponding cumulated conversion reserve; calculate also the conversion difference on investments by entity (owner) and Interco (held company);

  1. 2. Import or input the equity accounts opening flow F00 as equal to the closing position F99 in LC; The net variation flow F15 will therefore equal 0, and will not change the converted closing value by adding up to the converted opening value which is carried over to F99 as part of the conversion process.
  2. 3. Import the converted amounts calculated at step 1 into the application on the appropriate dimension members:

• Accounts: BS-215 Equity Accounts, BS113 & BS114- Investment in Subsidiary and BS219 -CTA (accounts in our example)

(CTA is the difference between the Opening rate and the Historical rate)

• Time period: preparatory time period for opening data

• Flow: F00

• ConsoScope: S_NONE

• Currency: Consolidation currency against which the converted value is calculated

• Audit IDs: INPUT

4. Run the corresponding consolidation. The respective opening rate (previous closing rate, i.e. first consolidation time period-2) and average rate should equal the closing rate so that no additional currency conversion difference is calculated by the conversion engine.

The automatic adjustment rules will post the NCI on conversion reserves and the CTA on investments from the imported data.

5. Populate the converted opening data of the first required consolidation by triggering the CopyOpening Data Management Package with the consolidation currency defined as parameter.

This is the preferred option because it allows you to book the historical equity value and conversion reserves in accordance with the set of Audit IDs used for the currency translation adjustments in subsequent consolidation of the following periods. (SAP BPC IFRS Kit)

This is explained along with the settings in BPC:

Step 1

Maintain the rate type as HIST for those accounts for which historical rates have to be maintained:

Untitled1.png

Step 2

For the opening flow, maintain the formula as AS_IS:

Untitled2.png

Step 3

For the CTA account, maintain the rate type as CTA

Untitled3.png

Step 4:

For the rate type CTA, the formula for the source flow should be maintained as AS_IS:

Untitled4.png

Step 5:

For the Group members, maintain Y for property STORE_GROUP_CURR as shown below:

Untitled5.png

Sample Data:

Untitled6.png

Step 6:

Run currency translation.

Step 7:

Run consolidation Monitor (Translate and Consolidation)

Step 8:

Run Balance Carry forward

Balance is carry forward to the next period  with Historical rate as can be seen from the following screen shot:

Untitled7.png

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

    1. SAP Boss Post author

      You can find the same in the following document:

      BPC NW 10_USG_Operating SP 2

      5.5.4.2. First Consolidation Process page # 55/75

      (0) 

Leave a Reply