Skip to Content
Author's profile photo Shabeer Ahamed Shah Anwar Hussain

BOBJ reports on top of ABAP functions in SAP S/4 Hana

We had a requirement to build BOBJ reports on top of ABAP function modules ( Remote enabled)
Let us see how this can be achieved and what are all challenges you might face…

For our example, I have used below remote enabled Function module (BAPI_FLIGHT_GETLIST)

When you execute you get below screens… To check result click on highlighted item…

You get below results…let’s try to display this result from BOBJ webi report…

 

Step 1: Create Relational Connection to S/4 Hana System

Create a new relational connection with SAP JCo connector with required connection details and test the connection. Export the connection to BO repository.

 

Step 2: Create Data Foundation Layer

Create a new data foundation layer using the short cut of relational connection created in Step 1.
Under ABAP functions select BAPI_FLIGHT_GETLIST.-EXPORT_CH_FLIGHT_LIST.

All ABAP function modules will appear as Tables in data foundation layer.

If you right click on this selected ABAP function you can see defined Input Columns or see table values

In our case we have only optional input columns – so no need to pass any values.

The report will fetch all records as below– if required we can create prompts in report query panel

In some case we need to deal with mandatory input columns – we have to pass either static values or if we want these values to be dynamic, then create universe parameters and map this to input columns as below

Complete these steps and save the data foundation layer.

 

Step 3: Create Business Layer

Create Business layer by selection Data foundation layer created in Step 2. Hide objects which are not required for reporting. In our case only highlighted items are enabled for reporting. Export this business layer to repository. Now this will be visible as Universe for BOBJ reporting.

 

Step 4: Create BOBJ webi report

Create Webi report in BI launch Pad or Rich Client with Universe as source. Select the universe created in step 3 and add desired result objects and execute the report

 

Issue we faced in Step 4

We were able to create and run report only in Webi Rich Client – But in BI launch Pad we were not able to create new report or refresh report created and published from rich client.

If you get above JCo connector issue contact SAP or give a try with below notes.

We connected with SAP our resolution steps are updated in SAP note –2625613

 

Now the reports are working fine both in BI Launchpad and Rich Client

Hope this helps…

 

SAP Environment Details Used

SAP BO 4.2 SP4
SAP S/4 HANA 1610
HANA 2.0 SP2

Assigned Tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo suresh Ganesan
      suresh Ganesan

      Nice Blog Shabeer. Please continue to post the interesting Blogs with S/4 HANA.

      Author's profile photo Shabeer Ahamed Shah Anwar Hussain
      Shabeer Ahamed Shah Anwar Hussain
      Blog Post Author

       

      Thanks Suresh 🙂

      Author's profile photo Lakshminarasimhan N
      Lakshminarasimhan N

      Sabeer Nice one...thanks for sharing. Steps are

      very similar to what we do on non hana ECC systems, when business wants real time data from ECC

       

      Author's profile photo Manikandan Elumalai
      Manikandan Elumalai

      Nice blog Shabeer. Great to see you here ?