Download Query Report using O-Data in S/4HC

All people know that S/4HANA or the ‘lite’ version S/4 HANA Cloud (I short as S/4HC) is something hype todays in SAP world.

To adapt with cloud technology SAP also try to bring their product into cloud or actually web based application.

As the application ecosystem is changed, the behaviour in the program will also follow.

Before cloud, when using ECC, is very convenient to extract data directly from table. We get used to with SE16 or SE16N, build query using SQVI or if you lucky enough can build your own report using ABAP.

As a functional, using SE16/SE16N or SQVI is quite reliable to extract huge amount of data straightly from the table.

Stop talking about ECC Monica!

Please explain how it can be done in S/4HC?

Hmm…to be frank, no SE16N functionality persist.

Well, but you can still extract the data eventually, only the method is different.

In this post, I am using O-Data with help from the API.

Without further a do..let’s figure it out how to do!

The ingredient you need are only Excel and access to S/4HC API.

I went to experience this new tool was because my involvement in the data migration for the current S/4HC implementation in my company.

And I noted down these step by step for my reference in the future, in case I get lost.

As I mentioned earlier, to download the data you need:

  • Access in S/4HC system
  • Microsoft Excel (I don’t know another spreadsheet program, you could try, but only Excel that installed in my office’s laptop
  • SAP API Business Hub URL: you may access follow this link https://api.sap.com/

In this example, I use object Customer master data which in S/4HC concept it’s become Business Partner.

Step 1. Log in to S/4HC and get the Communication Scenario OData Service URL

Search the app “Communication Arrangement”.

Once the app is displayed, located the correct Scenario ID, in my case I choose Business Partner, therefore it is SAP_COM_0008. Another way, in the API Business Hub portal, you also can find the Scenario ID under tab Details.

After Communication Arrangement app is opened. Click on the Scenario ID SAP_COM_0008. If you could not find any record, please check with your PI or technical guy for them to setup.

As we use OData to download, locate on the OData section and copy the URL provided. This URL later will be used to call from the Excel.

Step 2. Configure your Excel

Now, let’s start for the Excel.

Open new Excel, go to menu bar Data –> Get Data –> From OData Feed.

Key in the URL that you obtained from Step 1.

Enter the necessary Credentials.

If you miss above step, because of your hand too fast clicking :P. Click Get Data –> Data Source Setting to re-enter the Credentials.

Step 3. Build your OData query

Once the connection is established, you will see the segments of the API for Business Partner are displayed.

Depend how you plan to work, you can choose which segment to be loaded first. Because in this example I choose Customer Master, so I choose segment A_BusinessPartner as the base segment.

After you clicked Load, the data will be loaded in the Excel.

Just now is only the basic concept to extract the data from one segment only.

But is not only limited to that, you can also do ‘massaging’ in your query so that only relevant information is displayed to be refreshed daily. You can do join, filter, sorting, and save your query to be reused.

Step 4. Join with another segment

First, if you need to edit created query, go to Data –> Queries & Connections.

Click on the segment you want to edit, right click on your mouse and click Edit.

To join with another segment, scroll your mouse to the right until you find the segments that you need to join with the existing query.

For example, I join with segment to_BusinessPartnerAddress, choose that segment and continue by click OK.

Once it’s done, click Close & Load to check the result after the records are joined with Address data.

If you need to join with another segment, repeat the steps above for another segment.

Step 5. Re-arrange the Order of Column and Filter.

Next, the information are displayed but the column ordered are still scattered around.

To tidy up the data, without programming skill you also still can do it in this query.

Likewise to join the query, enter edit mode first to update your query.

Then, you just need to drag and drop the column to the position you want.

Once the order is as what you want, Close & Load your query.

Filter the query.

To filter, just click the small down arrow on the Column you want to filter.

Choose the data you want to display, Close & Load your query.

One thought on “Download Query Report using O-Data in S/4HC

Leave a Reply to Albert Cancel 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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s