Skip to Content

RTC: Currency Translation for Equity and Investment Accounts

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Mar 25 at 08:30 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 02 at 09:02 AM

    Hi Lucas,

    Sharing the RTCTM setup

    Regards,
    SHUBHAM

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 03 at 08:31 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • May 07 at 03:50 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 15 at 03:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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