Consuming BW function modules in IDT

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

Step 1- Function module

 

Give a name to connection

Step 2- Function module

 

Select SAP ERP drivers from the list ( NOT SAP NETWEAVER BW)

Step 3- Function module

 

Enter the parameters ( SSO supported) . Click Finish

Step 4- Function module

 

Creating a Data foundation layer

Create the connection shortcut to local project

Create a Data foundation layer ( Both Multi/single source supported)

P2 Step 2- Function module

 

Give the name and click Next

Select the Foundation type

P2 Step 4- Function module

 

Select the connection click finish

P2 Step 5- Function module

 

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)

P2 Step 6- Function module

 

Create a Business Layer over the Data foundation and consume it in all supported reporting tools

-Karthik Addula

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s