In some cases we need to add function module in universe and need to join with tables to get certain results in webi report. Basically function modules will be available in ECC system. We can add those Function modules in data foundation layer in IDT.
Create a project and add a relational connection and while selecting the drivers, we need to select proper data provider and driver to get function modules.
Select any of the highlighted driver to get function modules.
- SAP ERP 6
- SAP R/3
Then enter the credentials information, this information should be match that what you are using in SAP GUI.
In the third 2nd page, you can filter only particular function modules from ECC. It will be possible by giving the name on the first tab of the below screen.
Once you added the connection successfully then publish the connection to repository for secured connection. Then create a “Data foundation layer” using that secure connection.
As you can see, we can able to get add ABAP functions in IDT & universe. Select the function which you want add and do the rest of the pieces as per your requirement.
This is how we can add the function module in universe. If you want join tables with functions then add one more connection and join the tables with functions . Finally get the universe for report.