RTC - Currency Translation for PRELIM Category

[Former Member]

Hi ,

I have configured currency translation in S4 hana and it works perfectly fine for FINAL category and posts entries for both G_NONE and CG_GROUP as RTCCT and Integration rule both work fine for Final Category (even Data submission works fine)

Issue

The same thing doesn't work for PRELIM category, though currency translation RTCCT generates and posts records in ACDOCC for PRELIM and log shows everything identical to FINAL category but I can't see any translated group currency entry in Composite Provider > subsequently Integration Rule also don't post anything as it refers to Composite provider.

Am I missing something here as the few I see for PRELIM seems to only fetch LC values in composite provider.

FINAL:

>>ACDOCC / Composite Provider :

G_NONE LC > From Flexible Upload

G_NONE Group Currency > From RTCCT and Data Submission

CG_GROUP Group Currency > From Integration Rule

PRELIM :

>>ACDOCC

G_NONE LC > From Flexible Upload

G_NONE Group Currency > From RTCCT

No CG_GROUP values

>>Composite Provider

G_NONE LC > From Flexible Upload

I think it is something to do with Hana Views for PRELIM, not really sure.

Thanks

Rakesh

[lucas_costa3]

It's definitely something in your composite provider. The logs will show data straight from ACDOCC (have you checked the values in there?) whilst the composite provider will use view 09 to show you the translated values.

Which setting have you got in the RTC model setup regarding CT?

[Former Member]

Hi Lucas,

Regarding the translation methods, I can see the posting happening in ACDOCC with G_NONE GROUP currency for PRELIM so methods are working fine even for PRELIM but that entry is not reflecting in composite provider.

When RTCCT is executed it posts entries with BTTYPE = RTCCT.

I was investigating the views:

09 - select statement

FROM "ACDOCC" AS T1 WHERE T1.RCLNT = '200' AND T1.MODEL = 'ATGC01' AND T1.BTTYPE = 'RTBP' AND T1.DELFLG = '' ;

10 - select statement

T1.RCLNT = '200' AND T1.MODEL = 'ATGC01' AND T1.DELFLG = '' AND P.BPC_CATG = 'FINAL'

11- select statement

FROM "ACDOCC" AS T1 WHERE T1.RCLNT = '200' AND T1.MODEL = 'ATGC01' AND T1.BTTYPE = 'RTFU' AND T1.DELFLG = '' AND T1.BPC_CATG = 'PRELIM'

Going by the views , how system will fetch PRELIM category BTTYPE = RTCCT the once generated by S4 RTC translation. Yes if the integration rule runs then it can , but still these views might never fetch BTTYPE=RTCCT GROUP=G_NONE entries, that's my worry and subsequently the Composite Provider will never show RTCCT entries.

[lucas_costa3]

If I remember well, the RTCCT will also post to RTBP. Have you checked ACDOCC records SE16H?

In case RTCT is being used, you will need to open an OSS to fix the view 09.

[Former Member]

Hi Lucas,

The 09 is okay as it is going to pull RTBP which is BPC posted records, but since system will not read RTCT -

that is PRELIM category RTCT - RTC Currency translation records, through the Composite provider as none of the views cover it, so it will not post any RTBP.

09-RTBP

10 - Only Final

11-RTFU - flexible upload

how RTCT will come??

So to fix it I created a hana view as copy of 10 - with selection of category = PRELIM and removed the request check from RTC_PULL_REQ etc. and added BTTYPE=RTCT , it works perfectly fine.

So SAP will have to change their program to generate hana view to additionally have RTCT records for prelim otherwise PRELIM will never work.

I have raised an OSS let's see what's response, because I am worried about future issues with custom hana view, otherwise PRELIM works fine with this additaional view on 'RTCT', will keep you posted.

Thanks for your help

Regards,

Rakesh

[lucas_costa3]

I wasn't talking about the view, I said that the S/4 CT result was written in BTTYPE RTBP as well. As far as I know, RTCT wasn't being used...

Which version/FP are you? Can you post the parameters for CT in t-code RTCDT or the content of table RTC_P100C? what do you have for field BIZ_TTYPE?

[Former Member]

Hi Lucas,

I am working with Rakesh so I can answer.

Currently we are implementing RTC on S4 HANA on premise 1610 Release stack 02(05/2017) FP.

Field for BIZ_TYPE is blank for the concerned model in table in RTC_P100C.

We raised an OSS to SAP and SAP has come with up with following response:

Change in Class CL_RTC_HDB_CALC_BPC_PC_CT is causing the PRELIM Category issue.(in Attachment)

Now we have not made any changes to the class manually. Upon analysis we found following notes to have made changes:

2493811 Fixing Incomplete Data Issue of Consolidation View 06 Automated

2524150 A generic message BL203 (Message incomplete (severity, area, number, or exception missing) on model creation Automated

2473538 AUDIT_TRA Added to Base CDS View for Selection Automated

2554579 Real-Time Consolidation Model Enhancement for Reusing Translated Group Amounts in ACDOCA Automated

2554496 UDO report for SAP Note 2554579 Manual

Now I am thinking whether to reverse the SAP notes.

Also Since the last SAP note(2554496) involves manual Step, I am thinking as to how to reverse class changes.

sap-delivered-class-and-class-from-our-dev-system.png

sap-notes-changing-the-class.png

Regards,
SHUBHAM