How to add custom fields(different currency values from ACDOCA) to RTC model?

[chandradeloitte]

We are on RTC:

We have an issue where we need to perform consolidation on three different currencies Group Currency, M-3, and M-12. We are not performing currency translation in BPC but is done in S/4 Accounting side.

M-3 and M-12 are:

M-3 -> Currency Translated based on the exchange rate of previous quarter.(Field name in ACDOCA is CSL)

M-12-> Currency translated based on the exchange rate of previous year.(Field name in ACDOCA is BSL)

Below are the fields from ACDOCA table which are required but is not available in ACDOCC table.

BSL -> Amount in freely defined currency 3. (M-12)

CSL-> Amount in freely defined currency 4. (M-3)

RBCUR-> Freely Defined Currency 3.

RCCUR-> Freely Defined Currency 4.

Can anyone suggest how we can get all these currency value in our consolidation model. We can edit our foundation view but these fields are not part of ACDOCC table and therefore on editing other generated views we are getting an error.

[gcybill]

In Functional approach, you need to follow the ultimate rule of thumb to set up parallel consolidation.

https://help.sap.com/viewer/b9277744b8d84c74a15f185faa990e56/1809.000/en-US/1f80b457b0236d10e1000000...

Quoting from the help page:

"In the other direction, a BPC Category has a 1:1 relationship with a consolidation version, which is a combination of three version-related fields. You define this mapping relationship when setting up the RTC model. For more information, see Model Setup."

No matter whether the currency translation is not activated in RTC or BPC layer, the standard shall be followed, which is to set up 3 Category.

HANA view shall be aligned to accommodate a single key figure (one-amount field) approach with 3 Category.

[lucas_costa3]

Don't think this is possible.

In RTC you need to assign an amount field with Local currency - only one.

I've listed the options in this blog post .