Business Intelligence

How to Create an Operational Data Provisioning (ODP) Source System for SAP S/4HANA and SAP ERP

If you need to extract data from SAP S/4HANA or SAP ERP, then you need to create an ODP_SAP-based source system. To do so, follow these steps.

  1. Make sure that you have RFC destinations created for the sender and receiver. Now open the SAP BW modeling tools and select the SAP BW modeling perspective, then log onto the SAP BW/4HANA system. From the context menu of [ODP_SAP] under the Data Sources folder, select New > Source System… as shown below. 

Creating ODP_SAP Source System

  1. You’ll see the screen shown in the next figure. Provide the ODP source system Name and its Description, then select Next. 

Name and Description

  1. Set the Connection Type to ODP, as shown here.

Connection Type

  1. Next, you’ll choose the type of system and RFC, as shown in this figure.

RFC Selection for Source System

  1. After you click Next, you’ll see the details on the Confirmation Page, as shown in this figure.

Confirmation Page

  1. Click Finish. The ODP_SAP source system will be created, as shown below. 

ODO_SAP Source System for S4S System


As you can see above, S4SCLNT100 is the source system name of type ODP_SAP. You can also see multiple options in the Specific Properties section. Let’s start with Logical Destination in which the value in the Object column is S4SCLNT100. This field is used to connect to the remote SAP S/4HANA system or SAP ERP system. You’ll see the RFC destination of the source system in this object as a value.


Next, we have Dialog Destination in which the value in the Object column is S4SCLNT100_ DIALOG. This is used to connect to a remote system with a dialog user, and it’s optional. The Callback Destination has the value CB4CLNT100 in the Object column. It’s used to connect from the remote system to SAP BW/4HANA system. The Status column has green checkmarks for all destinations, which means that they’re all working fine and there is no issue with this ODP connectivity. You can see that ODP Context is maintained as [SAPI] DataSources/Extractors, which means it pulls data from the SAPI extractors. There is a Remote Tree checkbox here. The upload tree menu in the source system maintenance toolbar is associated with the status of the remote tree in the source system.


For example, the ODP SAP upload tree functionality brings up the hierarchy defined in the source system application component, as shown in the next figure. This means you can specify some sources that can deliver a hierarchical grouping of source objects (trees) whether the grouping should be copied to the DataSource tree for the specific source system. If you do not copy the tree from the source or the source cannot deliver a hierarchical grouping, the generic application component hierarchy defined for the nonreplicated source systems is used as the grouping for the source tree. But if the Remote Tree checkbox is selected, you can update the hierarchical grouping from the source by pressing Upload Tree (an icon) in the editor toolbar, as shown here.


Remote Tree in ODP_SAP


In terms of ODP Context, as shown below, it’s set to [SAPI]. Other options are available, and you can select them based on the ODP source system that you create. In our scenario, it’s [SAPI] DataSources/Extractor because we’re connecting to an SAP system with ODP_SAP.


ODP Context


If you want to check if the ODP connection is fine, you can do that from Transaction RSA1. Right-click the source system (S4SCLNT100) and choose Check, as shown in this figure.


Check Source System Status


You’ll then see the result of the consistency check. It will show a status message, as shown in the final figure. This will ensure that your ODP SAP connectivity is working fine.


Consistency Check Status


Editor’s note: This post has been adapted from a section of the book Operational Data Provisioning with SAP BW/4HANA by Renjith Kumar Palaniswamy.


Operational Data Provisioning with SAP BW/4HANA
Operational Data Provisioning with SAP BW/4HANA

Operational data provisioning (ODP) is the new standard for data staging and extraction in SAP BW/4HANA—are you ready for it? Use ODP to extract information from SAP S/4HANA and connect to other key data sources, including SAP HANA calculation views, CDS views, open ODS views, and SAP BW. Use SAP Landscape Transformation Replication Server to replicate data, and review the prerequisites for SAP BW/4HANA remote conversion projects. With detailed instructions throughout, this hands-on guide has all the information you need to master ODP!

Learn More

SAP PRESS is the world's leading SAP publisher, with books on ABAP, SAP S/4HANA, SAP CX, intelligent technologies, SAP Business Technology Platform, and more!