Wolfgang Dittmar

SAP Hana + OData + Power BI 

 SAP data can be accessed via PBI connector "OData feed"
Available services can be found with transaction code  n/iwfnd/maint_service
Copy a service in column "External Service Name" and connect to the data with PBI OData feed:  http://DEFAULT_HOST/sap/opu/odata/sap/'service name'

For a first check how many rows are in the table go for:
http:// "your SAP Port" /sap/opu/odata/sap/FAC_GLV_GL_ACCOUNT_LINE_ITEMS_SRV/I_OperationalAcctgDocItem/$count

Some services require mandatory inputs. Modify the URL accordingly. Example: 'service name'/C_StkKPITimeSeriesComprnQry(P_StartDateOfPreviousPeriod= 'NNN')


Example for connecting to a CDS View and retrieving 382 data columns

Download PBI file

 

Example 1 to connect:
OData service: SD_BILLINGDOC_PROCFLOW_SRV
Goto Power BI Get Data.
Determine the first part of the URL with SAP port number when you open any html Fiori app


Available tables will show.
In the image the most right column is a custom m-code column showing the current row count of each table. Click in a cell of the Data column to see a preview of the content. Carfefully, a click on "Table" adds another query step.
C_ tables indicate transaction data, I_ tables interface data aka master data and header data.



 

Example 2 to connect:
Procurement report for material related purchasing
OData feed sends two filter to the database: document type and material number:

View "I_OperationalAcctgDocItem" is lacking text informations eg for supplier name, material description…
Example to get the master data for suppliers:
https:// "your SAP Port" /sap/opu/odata/sap/C_SUPPLIER_FS_SRV/C_SupplierFs

 

 

 

 

Advanced cost center reporting with CDS View C_CostCenterCommitment
Direct connection via OData is available


C_CostCenterCommitment