SAP Business Planning and Consolidation, version for SAP NetWeaver, SAP S/4HANA, SAP S/4HANA Finance

How to create the RTC Amount Key Figure

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

SAP Business Planning and Consolidation, version for SAP NetWeaver, SAP S/4HANA, SAP S/4HANA Finance

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).

SAP Business Planning and Consolidation, version for SAP NetWeaver, SAP S/4HANA, SAP S/4HANA Finance

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:

SAP Business Planning and Consolidation, version for SAP NetWeaver, SAP S/4HANA, SAP S/4HANA Finance

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.

SAP Business Planning and Consolidation, version for SAP NetWeaver, SAP S/4HANA, SAP S/4HANA Finance

SAP Business Planning and Consolidation, version for SAP NetWeaver, SAP S/4HANA, SAP S/4HANA Finance

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.

Leave a Reply

Your email address will not be published. Required fields are marked *