Skip to Content

BI 4.2 IDT multi-source connection SAP ECC: Multiple Function Module (ABAP Programs)

Mar 05 at 05:38 PM


avatar image

Hello Experts,

I have been developing several function modules/abap programs as datasources for various reports pertinent to our BI reporting solution. We are primarily using SAP ECC as the data source. I have set up the relational connections to the ECC system, and applied all proper technical parameters as per guidance from the SAP community and technical resources.

The solution has actually been working great, HOWEVER, I have encountered an issue with the inability to join two different function modules in the data foundation in the IDT. Is it possible to publish a universe and properly query the data with this set up? Is this a limitation? Currently, it will give me the equivalent of 'the spinning wheel of death'.

Based on potentially outdated material online, it is recommended to conduct all joins on ECC-side (which we are doing for a number of reports already). The problem is I would like to avoid doubling the work effort. We already have FM's dedicated to several functional areas (i.e. SD, MM, FI, etc.). For example, if we simply need a sales price to complement our financial table read.

Any feedback would be appreciated as federating has gone great up until now.

I can provide further details on request. Thank you in advance.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Mar 05 at 06:30 PM

Hi Jake - I think your application will be faster if all the "joins" are back in ECC. Maybe you could join all the data using a SAP ECC infoset? This is what we do.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Tammy.. I will revisit this with my team.

Mar 05 at 06:39 PM

If developers/users are know when/how to take objects from classes then you can keep stand alone FM in the data foundation.

If required to get data from multiple classes then you can use merge dimension function at webi level.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Amit, thanks for the perspective. This sounds rather straightforward for webi but concerns me when implementing with Lumira and Crystal. While my current requirement is basic, this sounds like it could get complex down the road and have negative implications on performance...? Either way, it sounds like a custom (complex) solution is required.