Starting 4.0 SAP introduced new Jco connecters to connect BW datamodels directly, this is more like connection to RDBMS but the data foundation is pre authored. However, through the standard BW Jco connection, IDT can connect to Cubes, DSo’s , Infoobjects, Multi providers , Infosets and Infoobjects.
In reality, there may be a requirement where we will need to extract data from the tables directly. the bookish way would be create a self system datasource and create a datamodel. This post explains how to access function modules easily by leveraging ERP connectors.
How to Access BW Function Modules in BOBJ
Part 1 – Creating Connection
Create ERP connection to BW box
Give a name to connection
Select SAP ERP drivers from the list ( NOT SAP NETWEAVER BW)
Enter the parameters ( SSO supported) . Click Finish
Creating a Data foundation layer
Create the connection shortcut to local project
Create a Data foundation layer ( Both Multi/single source supported)
Give the name and click Next
Select the Foundation type
Select the connection click finish
Step 6) In the data foundation panel under connection , all the Info sets and function modules are now accessible ( Function Module should be RFC enabled)
Create a Business Layer over the Data foundation and consume it in all supported reporting tools