SAP BPC Currency translation Rule

[former_member830759]

Hello,

we are using BPC standard 11.1 version & below script (Standard) is Configured in our system.

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %C_CATEGORY_SET%

CURRENCY = %RPTCURRENCY_SET%

TID_RA = %TIME_SET%

RATEENTITY = GLOBAL

......

*ENDRUN_PROGRAM

As per SAP Document it is mentioned that if we define RATEENTITY = GLOBAL in this rule then GLOBAL must be the valid ID in REntity dimension. But we have different exchanges rates for different company codes. So, all our company codes are entered in RENTITY dimension instead of GLOBAL. Still the rule is working fine. Can anyone please explain how come the rule is giving correct result despite the ID - GLOBAL is missing in RENTITY dimension.

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html

Questions on how to draw responses from members? Check out this discussion on how to improve questions. https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-a...

[former_member186338]

Please, show screenshots of rate cube dimensions!

[former_member830759]

Dear sir,

Please find below the screenshot of the rate cube. This data pertains to one company code having GBP as its local currency. Both INR & USD are the group currency.

Regards

Shubham

[former_member186338]

Not cube, but dimensions! Dimensions with members in WEB admin.

[former_member186338]

Instead of GLOBAL you have to use your real RENTITY! Cxxx

In some cases when RATEENTITY is incorrectly assigned it will use the existing, in some cases it will result in errors!

P.S. RATEENTITY member is case sensitive like other BPC members!

[former_member830759]

Hi sir,

Below is the list of entities in RENTITY dimension. we have not defined any entity as GLOBAL. But still the results are coming fine.

what should be the correct approach to handle such scenario.

[former_member186338]

Sorry, but you have removed all info...

[former_member186338]

I see very strange R_ENTITY setup: multiple members having 2 hierarchies. What is the idea behind?

R_ENTITY is used to have different rate tables for the same currency, but what do you want to achieve here?

[former_member830759]

Dear Sir,

Thanks for your response.

The reason for maintaining two hierarchies is to see the reports on different selection. We have multiple company codes using the same currency but exchange rate is different for each company code.

Thanks

Shubham

[former_member186338]

"We have multiple company codes using the same currency but exchange rate is different for each company code"

Different companies within the same country using different exchange rates - looks absolutely strange for me!