RTC: Currency Translation for Equity and Investment Accounts

[former_member540457]

Hi ,

I am implementing Real Time Consolidation on S4 HANA on premise 1610 Release stack 02(05/2017) FP. For Currency Translation, the Translation method as been configured in Transaction code RTCTM. When we are executing Currency Translation using transaction code RTCCT, it throws following error:

Equity Reconciiation check error: - 1000000.00 (FI) and 0.00 (AFD) for 001002 in 003010202

Group Amount not found in equity(AFD) for 001002 in 003010202/900 with AED

SImilar line I get for investment account.

I have done some investigation, and its clear it has do with maintenance of Additional Financial Data in Table: RTC_CT_ADDDATA and RTC_CT_ADDDATAG.

But I am not very sure how they are linked and how should I be maintaining the table.

May You please suggest.

Regards,
SHUBHAM

[ALinetzky]

Hi Shubham

I have some doubt about the Flow dimension in RTC or Embedded Consolidation Models

According classic BPC consolidation models, you have a:

• Opening Flow
• Movements Flows
• Difference Flows
• Currency conversion Flow
• Total Flow
• Closing Flows (equal to Total Flow)

According RTC an Embedded Consolidation Models, the data is periodic. Could you help me how i have to manage the flows?

• 100 (opening)
• 105 (currency conv)
• Others
• 999 (closing)

Here i don't have the difference Flow??

If i summarize the Flow (100+105+999) y Will have the closing Flow?

I need to understand that to configure the conversion rules, and other hands, could you share the rest of the conversions rules?

Regards

Ariel

[former_member540457]

Hi,

You may have a different question for this on forum.

We maintain, transaction types/flows in S4 HANA layer via the transaction code RTCTTP.

Once you maintain here, it will be available for your BPC model.

Regards,
SHUBHAM

[ALinetzky]

Hi Shubham

Thx for your answers, I know that i have different questions, for this forum but they are related because the currency conversion is related with the flows or movements.

To understand, do you have examples to configurate the transaction RTCSEL and RTCCT that you could share?

Thanks a lots

[former_member540457]

Hi Lucas,

Here is the fresh steps that I have followed:

1. Ran Currency Translation via RTCCT for an entity whose Company Code Currency is EGP and got the error.

2. I went to Transaction code RTCAFD and maintained the equity amount.

3. Attached is the Reconciliation snapshot, where reconciliation shows in green colour.

4. Post this I ran the currency translation for the same entity but I am getting the same error.

Some Observations:

Somehow I am trying to maintain Group Currency Amount in RTCAFD for the same entity, but upon saving it is not saved. Only Equity in Local Currency Gets saved.

Regards,
SHUBHAM

[lucas_costa3]

Hi Shubham

kind of answer the question. In your method, you've chosen the currency translation key 3 - which will read the data from the investment/equity table I mentioned previously (t-code RTCAFD). Not sure about the message though as it specifies this GL Account 003010202

Have you got this account in any sort of additional rule?

[former_member540457]

Hi Lucas,

Sharing the RTCTM setup

Regards,
SHUBHAM

[lucas_costa3]

You can maintain investment/equity historical information on t-code RTCAFD (this will feed those tables you put on the question).

Not sure why the error though. You'd need to share your translation method.

Cheers.

Lucas