Creating OData Service with SAP BW Query for C4C Integration via Cloud Platform Integration (CPI)

[ravikanth_indurthi]

Introduction:

For the requirements such as sending the BW Data (Query) / OData  to any SAP cloud systems or third party systems using the Integration Platform process, I created OData Service using SAP BW Query outbound of BW system and send the data to SAP C4C system using SAP CPI (Cloud Platform Integration) by following steps.

Step 1 Create a BW Report:

Go to the required BW Query in BW Modeling Tools and enable the option By OData from BW Query Settings as shown below:

Refer : Steps to Create an ODATA service for a BW Query | SAP Help Portal

Tip: Sometimes, variables requiring mandatory user input may prevent the OData Service from enabling. Ideally, use optional or no variables and avoid authorization-relevant ones. However, this issue may not be relevant in the latest SP levels.

Step 2 Enable OData Service:

2.1 Go to T-Code in BW system: /n/IWFND/MAINT_SERVICE → Select “Add Service”

Select the Service with Query Name 
For Ex: - Report Name: ZSALES_ODATA_BW_QUERY
Service generated: ZSALES_ODATA_BW_QUERY_SRV

Service is automatically created & Make sure to Enter your package to collect in a transport request.

2.2 Go back one step to the Service Catalog (Activate and Maintenance) screen:
Select the Service ZSALES_ODATA_BW_QUERY_SRV -> Call Browser to check the data.

2.3 Go to SICF t-code to activate the service

2.4 Check the URL and make sure the Query runs fine without any issues:

By default, the service is called with parameter '?$format=xml', the full URI is: /sap/opu/odata/sap/<query name>_SRV/?$format=xml

Here we can see, with parameter 'ZSALES_ODATA_BW_QUERYResults' we can access the data in the query result.

2.5 Below OData Service links can be useful to display Query Information:

Display Metadata:

https://<BI Portal URL>/sap/opu/odata/sap/ZSALES_ODATA_BW_QUERY_SRV/$metadata

Display Format:
https://<BI Portal URL>/sap/opu/odata/sap/ZSALES_ODATA_BW_QUERY_SRV/?$format=xml

Display Query Result:

https://<BI Portal URL>/sap/opu/odata/sap/ZSALES_ODATA_BW_QUERY_SRV/ZSALES_ODATA_BW_QUERYResults

Display Query Result with Filters:
https://<BI Portal URL>/sap/opu/odata/sap/ZSALES_ODATA_BW_QUERY_SRV/ZSALES_ODATA_BW_QUERYResults?$filter= 0CALMONTH eq '04.2025'

Step3 Login to the SAP CPI (Cloud Platform Integration) system:

3.1 Field mapping between the BW Query and C4C in CPI system.

Map the BW Query Result (Fields from left side of below mapping) with the C4C OData API (Cloud Data Source) from C4C system as shown below:

Note: C4C OData API (Cloud Data Source) is created in C4C system and the BW Query fields are mapped in CPI system.

3.2 A daily job can be scheduled to load the data from SAP BW Query OData service to SAP C4C Cloud data source using CPI system. A defined period and time can also be set similar to process chains and update the data regularly.

Please Refer: SAP Cloud for Customer - Integration to Central An... - SAP Community

Also Please refer to below Links for more SAP insights on OData Service Enabling:

Steps to Create an ODATA service for a BW Query - SAP NetWeaver Business Warehouse - Community Wiki

How to do Odata Services from BEx Query | SAP Blogs

Transform SAP BW Queries into OData Service: Part 1 – Generation and Activation | SAP Blogs

ODP-Based Data Extraction via OData - SAP Help Portal