Real-Time Consolidation Dimensions

[hanlok22]

Hello,

We have a requirement to add fields to our consolidation model which are not included in the standard foundation view. Some of these fields are standard in ACDOCA and others are z-fields in ACDOCA that are specific to our company.

I can see in HANA studio it is pretty straight forward to add fields from ACDOCA in the Foundation view, and there is an SAP note on how to add fields into ACDOCC. However without the delivered /ERP/ info objects its unclear to me how to set up the dimensions in the virtual provider. Also how would the write back need to be modified? Is there anything else that needs to be considered??

Many thanks,

Kevin

[lucas_costa3 · Accepted solution]

There are many variables at stake here.

First thing, is that if you have custom fields and if the customisation was done properly, the new fields in ACDOCA should also be replicated to ACDOCC, as these two tables share most of the custom append blocks such as new CO-PA new fields or COBL (custom fields).

Considering that the new field exists in both tables, as you rightly said, you need to update the foundation view. The second step is to re-generate the HANA objects for your model via RTCMD. This will add the new field(s) to the other views such as 05, 06...09...

With the field in view 09, you can then start with BW. If the corresponding info object doesn't exist, you'll need to create one and if the field has master data there are additional steps to create a virtual info object - Create HANA view (you can find the MD table in the domain of the custom field in ACDOCA), create info object, assign hana view to IO, activate. But if you're field doesn't have master data, you simply need to assign the field to your RTC virtual provider, the field(s), which is now in view 09, can be then selected for the field mapping (HANA --> BW).

Lastly, in BPC, you also need to map a dimension type to the newly added field(s), generally "user-defined".

You don't need to worry about the write-back as the mapping between BW and HANA/ABAP dic is dynamic and the write-back class will take care of everything.

[msumith · Accepted solution]

We also have a requirement that the Document Number (BLART) needs to be added to our model for reporting purpose. This is present in both ACDOCC and ACDOCA tables respectively, now how to get this to the virtual provider as they are not present in the foundation views to add it to virtual provider. Need some help on this requirement.