cancel
Showing results for 
Search instead for 
Did you mean: 

Rate update for Real Time Consolidation on S/4 HANA 1610

abhishek_rajan3
Contributor

Dear all, We are configuring the Real Time Consolidation on S/4 HANA 1610 release. As per the configuration guides, in BW we have created a Virtual Provider, Composite Provider, Aggregation level and two Real time cubes, one for Exchange Rate and one for Ownership. My question is what are the subsequent steps to get data for Rate and Ownership. Like the Rate should get updated from TCURR, but how do we update the data to the Rate real time cube? Should we follow the same manual update process as followed earlier versions? Please help as none of the guides have details on connecting the rate and ownership cubes. Regards, Abhishek.

Accepted Solutions (1)

Accepted Solutions (1)

lucas_costa3
Active Contributor

If you go to IMG -> Financial Accounting (New) -> Real-Time Consolidation -> Currency Translation Definition

You'll have an idea around the settings you need to perform.

In a nutshell:

1- Define Exchange Rate indicator

In here you assign an exchange rate type from S/4 to a Rate indicator in RTC - e.g.: Assign M rate to a M indicator. Then RTC will select the appropriate rate

2- Define Selections

Definition of selections to be applied when translating e.g.: Create a selection for BS accounts and another for P&L accounts.

3- Define Currency Translation methods

Definition of the CT. In here you can add multiple entries - such as one entry for BS, another for PL, another for historical...

The key here is to define what requirements you have around the translation, for instance, in example above we're using different exchange rates for different accounts.. etc.

A few things to bear in mind:

1- Once you define a RTC model as S/4 CT, you cannot change that back.

2- S/4 CT is triggered via T-code RTCCT in S/4 (BPC CT is triggered in the consolidation monitor)

3- At the moment incremental translation is not supported - which means that if you want to re-translate, you're required to run the whole combination entity/category/period again.

4- There can only exist one CT Method per RTC model.

Also check the following link for more info:

https://uacp.hana.ondemand.com/http.svc/rc/PRODUCTION/e0f3ad5789cfca02e10000000a4450e5/1610%20000/en...

Cheers,

Lucas

Former Member
0 Kudos

Hi Lucas,

Hope you are well. I have a few question regarding currency translations. We have opted to perform CT in BPC.

1. Do I need to do the above configuration if I am doing CT in BPC?

2. Is there a best practice preferred way of doing CT? HANA or BPC

Your feedback will be appreciated

Regards,

Jurgen

Answers (2)

Answers (2)

lucas_costa3
Active Contributor

Hi, for ownership data is saved through the Ownership Manager.

For rates you could build just as any other BW process to get data in that cube.

If you're using TCURR what aren't you leveraging the S/4 Currency Translation?

abhishek_rajan3
Contributor
0 Kudos

Hello Lucas,

Thanks a lot for the response!

For the currency translation in S/4, how do we utilize the TCURR data?

Regards,

Abhishek.

lucas_costa3
Active Contributor
0 Kudos

It's all standard - The S/4 CT requires a SAP exchange rate type - which are stored in TCURR.