Skip to Content
0
Jul 27, 2018 at 11:08 AM

RTC: Currency Translation in S4 HANA layer posts duplicate entries when run in Opening period

227 Views

Hi Team,

We are using S4HANA 1610 FPS00 for Real Time Consolidation.

We are doing the following:

1. Loading some data using the Flexible Upload Program for fiscal period 2017012, FINAL Category and then we perform Currency Translation in S4 HANA layer via transaction code RTCCT. After this, we perform Data Submission Request on the same period. We see the correct data in Composite Provider.

2. Next we perform Balance Carry forward. We go to the BPC Web Admin and then run the Balance Carry forward task from the Consolidation monitor for period 2018001 and FINAL Category. We see the balance sheet accounts data in composite provider and it is coming perfectly fine.

3. Next we run the Currency Translation on the Fiscal Period 2018001 and for FINAL Category. I see the data in the Composite Provider. While the Currency Translation logic runs fine, the output results are duplicated. System is posting duplicate entries for LC and Group Currency Data for the 2018001 period.

Is there a bug with system behavior and we need to apply some SAP note??

What we have observed is the following:

1. Upload via Flexible Upload Program makes an entry with BTTYPE as RTCFU. But we cannot see the data in Composite Provider. This behavior is okay.

Account Period BTTYPE Currency Amount

A1 2017DEC RTCFU LC 100

A2 2017DEC RTCFU LC -100

2. We run the Currency Translation and Data Submit Request, and 4 extra records are generated in ACDOCC with BTTYPE as RTCCT. In Composite Provider we see 4 records now corresponding to entries below in table ACDOCC. Group Currency Values is same as Local Currency.This behavior is okay.

Account Period BTTYPE Currency Amount

A1 2017DEC RTCCT LC 100

A1 2017DEC RTCCT AED 100

A2 2017DEC RTCCT LC -100

A2 2017DEC RTCCT AED -100

3. We run the Balance Carry forward for Fiscal Period 2018JAN and system posts 4 extra records in ACDOCC table with BTTYPE as RTCBP. We see the same 4 records in Composite Provider for fiscal period 2018JAN. This behavior is okay.

Account Period BTTYPE Currency Amount

A1 2018JAN RTCBP LC 100

A1 2018JAN RTCBP AED 100

A2 2018JAN RTCBP LC -100

A2 2018JAN RTCBP AED -100

4. We run the Currency Translation for the fiscal period 2018001 and FINAL Category and then we do Data Submission. System generates 4 extra records in ACDOCC tables as below.

Account Period BTTYPE Currency Amount

A1 2018JAN RTCCT LC 100

A1 2018JAN RTCCT AED 100

A2 2018JAN RTCCT LC -100

A2 2018JAN RTCCT AED -100

When we go to see the data in Composite Provider, I see duplicate entries for LC and AED for each of the accounts for period 2018JAN. This behavior is not okay as system should show only one value and not duplicates.

Please suggest what we need to do here.

Regards,
SHUBHAM