Skip to Content

Real Time Consolidation:System doesnot pick records from ACDOCA table during Currency Translation

Hi Team,

We are implementing Real Time Consolidation where currency Translation is done inside RTC using the transaction code RTCCT. Below is the issue:

For Model XCON, there is no record in ACDOCC table. In ACDOCA table, we have records against entity 1234 for period 201707. We ran Currency Translation using the RTCCT but system did not pick records from ACDOCA table. Also while Data Submit request using RTCDSRB, no records were fetched. Our concern is that records from ACDOCA table should have been fetched. Note that, when records are present in ACDOCC table, the Currency Conversion via RTCCT picks records only from ACDOCC.

Can it be related to SAP note 2490401 which talks of leading 0s in case of entity?

What are we missing here.

Regards,
SHUBHAM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 14 at 12:00 AM

    Hello,

    Is the note relevant for your version? If yes, then I would say implementing it can only be beneficial. However, if you are looking for more validation if leading zeros are causing the problem then you may see some clues in BPC web client. I worked on an issue with BPC journal entry, through BPC web client, when some dimension members appeared in member selection lists without leading zeros but in other places they could be seen with leading zeros and the data was not being posted. Applying the recommendations and making sure the ALPHA routine was enabled fixed the problem.

    Best Regards,

    Leila Lappin

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Lucas,

      I agree with you about the leading zeros should be removed at least as far as BPC is concerned. However, I read that ALPHA conversion routine is supposed to take care of any mismatched format, especially regarding the leading zeros. I assume this will apply to all values persisted at the data base level.

      Regards,

      Leila

  • Feb 16 at 01:29 AM

    This note 2490401 is about the leading zeros in the presentation layer. If you have saved the mapping correctly it will work fine. e.g.: ENTITY = 1001 and RCOMP = 001001..

    I had a problem in the past where I uploaded the mapping from a flat file, and S/4 characteristic - RCOMP - was missing the leading zeros, and no data was being selected because internally there is a join using the this field.

    Add comment
    10|10000 characters needed characters exceeded