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.



0 Kudos

Hi Nitesh, We are implementing GR in our company and we have similar requirement. I just would like to know if you are able to find a solution this. If so, it would be great help if you share me the details. (Our S4 is ver 2021FPS2)

Thanks & Regards!


Accepted Solutions (0)

Answers (1)

Answers (1)

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