Exposing SAP HANA Calculation Views as OData Services via SADL
In this technical demo, you’ll learn how to quickly expose a HANA Calculation View as an OData Service in an ABAP system—without writing a single line of code.
We start with a calculation view designed for financial analysis (calculating average days open and currency conversions for invoices) and walk through the seamless integration process using the SADL (Service Adaptation Description Language) framework.
What you’ll learn:
The Prerequisites: Mapping HANA types to an ABAP Dictionary View.
Project Setup: Creating a new project in the Gateway Service Builder (SEGW).
Data Modeling: Importing the dictionary structure and defining Entity Types and Sets.
SADL Mapping: Using the "Map to Data Source" feature to link your business entity to the Dictionary View.
Activation & Testing: Registering the service in the ICF, generating runtime objects, and verifying the OData output in a browser.
This method is the most efficient way for developers to consume complex HANA logic in SAP Fiori or other web applications with zero manual programming effort.
Key Transactions used:
SEGW (Gateway Service Builder)
SICF (HTTP Service Hierarchy Maintenance)
00:00 Introduction and demo overview
00:32 Creating a dictionary view in ABAP
00:44 Exposing the view as OData via SADL
00:51 Launching Gateway Service Builder (SEGW)
01:02 Creating the project
01:29 Importing the data model
02:26 Configuring the entity set
02:54 Mapping parameters to the SADL data source
03:47 Generating runtime objects
04:05 Registering and activating the service
04:46 Testing the OData service results