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.