Technology Blog Posts by Members
cancel
Showing results for 
Search instead for 
Did you mean: 
Harshhith
Explorer
1,198

Generating OData of standard API :

First we have to login to SAP business accelerator hub account and go to SAP S/4 HANA Cloud Public edition.

Harshhith_0-1722237982193.png

Choose a standard API as shown below

Harshhith_1-1722237982212.png

 

In this case I have choose the product master standard API.

Harshhith_2-1722237981910.png

Select the overview tab, under that we can see Communication Scenario ID.

Harshhith_3-1722237982201.png

 

Harshhith_4-1722237982116.png

Copy communication scenario from standard API. Now Move to the

 S/4Hana cloud system -> Communication Arrangements

Harshhith_5-1722237982119.png

 

Select the Option New, and add a Scenario ID which we have copied from the Standard API

Harshhith_6-1722237982109.png

 

 

Harshhith_7-1722237982095.png

 

Harshhith_8-1722237982215.png

 

Harshhith_9-1722237982124.png

 

Create new communication system:

Search for Communication System in S/4 HANA cloudhere we need to create user and password for all OData services

Harshhith_10-1722237982112.png

 

Click on New, 

Harshhith_11-1722237982115.png

 

System will ask for new communication system id and system name. we can give the ID & Name of our choice. And Click on create. 

Harshhith_12-1722237982213.png

 

Give the Host name as shown below,  

Harshhith_13-1722237982211.png

 

In User for Inbound Communication, click on Add and Create New Inbound Communication User. Click on “New User” 

Harshhith_14-1722237982219.png

 

Give the username and description and select on proposed password to get the password which will give by system itself. (Copy the user name and password and paste somewhere so that, Once the user and password has created we can use the same for all the OData service Consumption.) 

Click on create 

Harshhith_15-1722237982126.png

 

Click on Save  

Harshhith_16-1722237982176.png

 

Then add your custom communication system in this communication arrangement

Harshhith_17-1722237982179.png

 

Then you get required ODATA URL

Harshhith_18-1722237982269.png

 

Now will connect S/4HANA Cloud to Power BI or any other reporting tools through OData Feed. Example:Open Power BI->get Data->OData feed.

Harshhith_19-1722237982174.png

 

In the OData feed enter the OData URL generated in S/4HANA Cloud. And give user name and password that we have generated in S4hana cloud “Communication System” to get the OData url.

Then Click on connect.

Harshhith_20-1722237981919.png

 

Select the checkbox to data preview and click on Transform data or Load.

Harshhith_21-1722237982189.png