SAP S/4HANA  OData

💡 What is SAP OData Service?

OData (Open Data Protocol) is a standard web protocol used in SAP to expose and consume data using RESTful APIs.

So, an SAP OData Service allows you to connect SAP data (tables, CDS views, business objects, etc.) with external systems

or UIs for example, SAP Fiori apps, mobile apps, or 3rd party tools.

 

🧠 Simple Definition

👉 OData Service = A web service that provides SAP data in a standard format (JSON or XML) over HTTP.
You can use GET, POST, PUT, DELETE to read/write data just like any other REST API.

 

🔹 Example

Let’s say you want to show employee data from SAP in a Fiori app.

• The backend SAP system stores data in a database table or CDS view.

• You expose that data as an OData Service.

• The Fiori app calls the OData endpoint (like a URL) to display employee info on screen.

🔹 OData Operations (CRUD-Q)

Operation.        HTTP Method.                        Example

Create.                   POST.                   Create a new employee

Read.                       GET                    Read employee list/details

Update.              PUT / PATCH            Modify existing record

Delete                   DELETE                 Remove employee record

Query                 GET + Filter.             $filter,  $select, $expand, $orderby

​

🔹 Versions

Version.                         Used                                                                                  Format

OData V2               SAP Gateway / S/4HANA On-Premise                                    XML / JSON

OData V4.     SAP BTP / RAP (ABAP RESTful Application Programming).       JSON only, modern                                                                 

​

Where It’s Used in SAP

🔒 Security

• Uses SAP Authentication (SAML / OAuth / Basic)

• Supports CSRF tokens for write operations

• Authorizations controlled by OData roles and services

 

✅ Benefits

Benefit                                              Description

🌐 Standard Protocol          REST + HTTP, easy to i ntegrate

⚡ Real-time                       Instant data access from SAP

🔄 Two-way                         Read + Write capabilities

🔌 Integrable                      Connects easily with SAP and external systems

💻 UI Ready                        Fiori and mobile apps use it directly

​

SAP Fiori Apps - Fiori UI apps use OData services to get data from backend

Integration via SAP CPI.  - CPI can consume OData APIs from S/4HANA or SuccessFactors

ABAP RAP Framework  - Uses OData V4 service  automatically for UI and API

Third-party consumption  - External apps (mobile, web, BI tools) use OData endpoints to  ead/write SAP data

 

Course Content:

1. Introduction

2. OData Service by Map to Data Source method (Stub - GetEntitySet & GetEntity) 

3. OData Service - ABAP Workbench method (Stub - GetEntitySet) 

4. OData Service - ABAP Workbench method (Stub - GetEntity) 

5. Delete Stub Implementation

6. Add additional properties

7. Create Stub Implementation

8. Update Stub Implementation 

9. $OrderBy - Query Option (based on Single property) 

10. $OrderBy - Query Option (based on multiple properties dynamically) 

11. $Filter - Query Option

12. $top - Query Option

13. Import Entity from DDIC & multiple Key Properties

14. $inlinecount - Query Option

15. Single Function Import

16. Multiple function import (HTTP Method - Get & Post) & multiple Entites

17. Upload and Download the file with content to/from db table using OData service

18. Paging in OData service - $top + $skip

19. Navigation Between Entities (Product & Supplier)

20. $expand - Query Option (get_expanded_entityset & get_expanded_entity method)

21. Deep Insert - Create_Deep_Entity method

22. Create entity by importing from Search Help (Odata Service Using Search Help)

23. Create entity by importing from RFC

24. $batch - Query Option - -multiple read operations in a single batch request

25. $batch - Query Option -multiple CREATE operations in a single batch Play

26. $batch - Query Option -multiple UPDATE operations in a single batch request

27. $batch - Query Option -multiple DELETE operations in a single batch request

28. HTTP METHOD (PUT vs PATCH vs MERGE)

29. Enhancement for standard Odata service.

30. Real time project explanation