Skip to Content

Although the RTC implementation documentation implies the use of the standard key figure /ERP/RTC_AMO, this InfoObject in fact is not part of the RTC BI Content, as stated in SAP Note 2460119 Missing Key Figure /ERP/RTC_AMO and Characteristic /ERP/RTCMODEL in System of Real-Time Consolidation 

Bear in mind that this post was created based on the 1610 FSP01 release.

The reason for RTC to have this special key figure is because normal amount key figures will have a compounding unit characteristic such as 0CURRENCY. When mapping the currency characteristic to BPC, this dimension requires additional properties to be used in the consolidation process and those standard unit characteristics do not allow that, without mentioning problems with the compounding characteristic in the backend.

At the same time, if we create a key figure type number – decimal (17,3) or floating point (16,16), it is not possible to choose neither the length nor the decimal places. BPC expects a DEC(28,2) – even though the CONSL_SL field in the ACDOCC table is DEC(23,2).

This blog will list the steps to create and customise the key figure to be used in the BW and BPC modelling side of Real-time Consolidation.

1- Create a Key Figure type DEC

In transaction code RSD1 enter the KF, display and double-click on the Data Element, the domain assigned by the system is RSKYFNUM – type DEC (17,3).

 

2 – Enhancing the key figure

Although the amount key figure is not delivered, the DDIC domain with the exact requirements is: RTC_AMOUNT – Domain of RTC Amount.

Before proceeding, confirm (via SE11) you have this domain in your system. If not, create a custom one as below:

Then go to SE16 and enter table RSDKYF. In the selections screen, input your newly created key figure in KYFNM.

In change mode, update the field DOMANM of both version A and M to RTC_AMOUNT.

After saving go to the key figure again and re-activate and it’s done! Simple as that.

You can now assign your key figure and /ERP/RTCCURR to your BW and BPC, RTC modelling.

 

Reference: Customizing the Domain for Key Figures

 

 

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply