RTC:Currency Translation for P&L Accounts in S4 HANA layer shows incorrect result

[Former Member]

Hi,

I am implementing Real Time Consolidation on S4 HANA on premise 1610 Release stack 02(05/2017) FP.

We are performing Currency Translation in S4 HANA layer using the transaction code:RTCCT.

We have defined 2 Exchange rate types in transaction code RTCER:

1002: Average Rate

1001: Month end Closing Rate

We are trying to translate Profit Loss Accounts by the Average rate with no Currency Translation difference. When we try to translate the Profit Loss Accounts, system performs the translation by Average rate (1002) as Target Amount and at the same time system performs translation by Closing Rate(1001) as Reference Amount. In the Composite provider when I see the Currency Translated results, I see the Reference value overall.

When the user sees the report, he will see the Currency Translated data by Month end closing rate rather than the Average rate which is actually wrong.

I am attaching the rule for PL accounts.

Revenue Accounts Configuration for Currency Translation:

Expense Accounts Configuration for Currency Translation:

Composite Provider Data showing the LC and Group Currency Value values:

Now LC value is -300.

1002 rate in the system is 1.024, 1001 rate is 1.023.

Currency Translation by Average rate is: -300*1.024 = -307.2

Currency Translation by Closing rate is: -300*1.023 = -306.9

Difference between them is 0.3.

My point is user wants to see the Currency Translated result by Average rate. but the composite provider total value is nothing but result by Month end rate.

Do I need to make any changes to my Currency Translation rule?

Since this is Profit Loss, so I hope there is no Currency Translation difference also.

Kindly suggest.

Regards,
SHUBHAM

[damovand]

Hello,

Since you are executing this directly in S/4HANA I recommend posting the question in S/4HANA SAP answers as well. Here is the link for it.

https://www.sap.com/community/tag.html?id=67837800100800006927

Best Regards,

Leila Lappin