SAP S/4HANA Cloud for Finance: Balance Reporting – Part 4: Custom Report Consumption

Welcome to part 4 of this blog series that covers the custom report consumption. To understand the different balance types and standard reports as well as standard API please look into the first two blog of this series.

• Blog 1: Introducing balance types and consumption types covered by this blog series
• Blog 2: SAP S/4HANA Cloud: Standard reports and standard API for balance reporting
• Blog 3: SAP S/4HANA Cloud: Custom report creation for balance reporting
• This Blog: SAP S/4HANA Cloud: Custom Report consumption
• Blog 5: Summary

In this blog we explain the possibilities to consume your custom balance reports in:

• SAP Fiori Launchpad
• Microsoft Excel
• OData Clients (SAP Analytics Cloud, …)

Consumption via SAP Fiori Launchpad

Every custom query can be consumed via a generic Fiori UI. You can define a separate tile for it in the SAP Fiori Launchpad. Here you have two options.

Option 1: Local Tile

For the local tile you call the app ‘Custom Analytical Queries’ and go to the details of your defined query. Here you click on ‘Preview’.

Fig. 1: Preview Custom Analytical Query

You fill the selection parameter and trigger the selection. Now you can save the report as a separate tile via ‘Save as Tile’.

Fig. 2: Save as a Tile

You can provide a title, subtitle and assign it to a group.

Fig. 3: Personalize Tile

The tile is then available in the group ‘My Home’.

Fig. 4: Fiori Launchpad with the New Report

Option 2: Custom Tile

If the tile should be available for other users as well, you can use the app ‘Custom Tile’. First you copy the link from the query preview of the app ‘Custom Analytical Queries’. Then you open the app ‘Custom Tiles’. You maintain a tile title and enter the URL that was copied from the preview. As URL parameter you enter the query name and the system alias.

Fig. 5: ‘Custom Tile’ app

You can already preview the result by clicking on the tile. With ‘Assign Catalogs’ button you can assign it to an existing catalog and publish the tile.

Fig. 6: Assign the report to a business catalog

The tile is then available in the corresponding business catalog.

Fig. 7: Fiori Launchpad with the New Report

Consumption via Microsoft Excel

Every custom query can also be consumed in Microsoft Excel. Therefor you can either use SAP Analysis for Microsoft Office or you can download the result of the generic Fiori app into Microsoft Excel.

Fig. 8: Export to Microsoft Excel

Consumption via OData

Custom CDS views can also be consumed with OData. All you need to do is to check the flag ‘External API’

Fig. 9: Check the flag ‘External API’

You can then activate the OData service with the app ‘Custom Communication Scenarios’ by creating a scenario ID, adding the CDS View and publishing the service.

Fig. 10: Activate the OData Service

You can then use the OData service in SAP Analytics Cloud, other Fiori Apps or consumer.

For more information on SAP S/4HANA Cloud, check out the following links:

• SAP S/4HANA Cloud release info: http://www.sap.com/s4-cloudrelease
• Sven Denecken’s 1902 blog on SAP News here
• Best practices for SAP S/4HANA Cloud here
• SAP S/4HANA Cloud Customer Community: here
• Feature Scope Description here
• What’s New here
• Help Portal Product Page here

Follow us via @SAP and #S4HANA, or myself via @HaukeUlrich and LinkedIn.