cancel
Showing results for 
Search instead for 
Did you mean: 

Extract data out of Group Reporting with _Elim view

0 Kudos

Hello Team,
We have post-eliminated data in Group Reporting for some period say 001.2021 and we are checking the same data in IMCFNDNCUBE table.

However, we see Consolidation Unit for Elimination field missing in the table IMCFNDNCUBE. This field should contain the Consolidation unit involved in elimination and the elimination group. The data in this field is based on the Consolidation Unit Hierarchy in the system.
Later on checking with SAP we got to know that the field 'Consolidation Unit for Elimination' is not part of the table ACDOCU and IMCFNDNCUBE consumes the same. The so-called matrix elimination is only happening and calculated on the fly when the Group Data Analysis apps are executed with the relevant execution parameters.

Now my question is we wish to send Group Reporting data to other interfaces and the need is to have _Elim view data. As per SAP it is not available in IMCFNDNCUBE view(which we are using currently).Is there any other way to extact the data with _ELIM view and send it to other interfaces/systems?


Thanks in advance.

Regards,

Nitesh

Accepted Solutions (0)

Answers (1)

Answers (1)

cfaustm3
Active Participant
0 Kudos

I know I've built them from the I_MatrixConsolidationReportC view, which I think is one level up from what you're referring to, and we would have used that to extract ProfitCenterEliminated.

Depending on what the receiving systems can handle, though, there's also the delivered Group Reporting APIs that those systems could potentially call, or you could put a wrapper around. (We needed to have some transformations & lookups (descriptions, attributes, other de-normalized data) that it was easier to just go directly against the view.)
https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/44ec04bc8de24103b400d261fde99462/60dcfbb352894f83986...

-Chris