Exposing master data as ODATA service from S/4 HANA on-premise

The ABAP CDS views are present already in the S/4HANA on-premise waiting to be used up. The question is how to expose these CDS views from S/4HANA and consume as APIs in SAP BTP.

CDS Views for Sales

In this blog post I will try to explain the steps to identify and expose the ABAP CDS views from SAP S/4HANA on-premise, which can be later consumed as APIs in SAP Integration Suite.

Tcode: SDDLAR

In t-code SDDLAR (CDS Analysis and Repair Tools) in backend S/4HANA on-premise system, you can find other ABAP CDS views consuming the current view based on name.

CDS Analysis and Repair Tools

Select the entity you want to expose.

Display Entities

Preview the Entity Data.

Entity data preview

Display Data Structure

Structure I_Customer_VH

Check the DDL source with the name.

DDL sources with name

Tcode: SEGW

SEGW is the transaction to build a service in SAP.

SAP Gateway Service Builder

CDS Entity – I_SalesOrganization

CDS Entity

Finish CDS-Entity exposure

CDS-Entity exposure

Create Transport Request for CDS Entity.

Transport Request

Model Provider Class and Data Provider Class are created.

MPC and DPC

Successful Service registration in SAP Gateway.

Service Registration

ODATA Service created successfully.

Service created

Activate the ODATA service in Service Catalog.

Activate and Maintain Service

Keep this handy

/sap/opu/odata/sap/KM_I_SALES_ORGANIZATION_SRV

Defined ServiceName

Test service in browser

Execute as XML

Execute as JSON

Now we can use this ServiceName by deploying the SAP Cloud Connector in S/4HANA on-premise and mapping this ServiceName as a source of service in the Cloud Connector.

SAP Cloud Connector

Later we can consume this ServiceName as API in SAP BTP through the SAP Integration Suite.

SAP Integration Suite

Conclusion: There are pre-defined ABAP CDS views in S4/HANA on-premise which can be exposed as ODATA services to the outside world through SAP Cloud Connector, and can be consumed as APIs in SAP BTP for master data.

Part 2

A Simple illustration for SAP Data & Analytics | SAP Blogs

Please read through my other blog posts on master data.

Mapping different domains in SAP Master Data Governance to SAP S/4HANA processes | SAP Blogs

Understanding SAP MDG in a Traditional way | SAP Blogs

Using SAP BTP for Master Data Governance with Fiori Tiles | SAP Blogs

Simple steps to start RISE with SAP S/4HANA Cloud | SAP Blogs

Demystifying One Domain Model w.r.t Master Data Objects | SAP Blogs

Data Journey from SAP MDM to SAP MDG | SAP Blogs

A Simple illustration for SAP Data & Analytics | SAP Blogs

Data Visualization simplified for SAP Data Consultant

Understanding basics of SAP Master Data Integration and Orchestration

Best Regards,