Working with ODP Context - SAP Extractors


After completing this lesson, you will be able to:

  • Extract data from S/4HANA using ODP and the classic SAP extractors

Extract data from SAP S/4HANA using ODP

SAP Extractors as ODP Providers (ODP_SAP)

SAP BW/4HANA can extract data from an SAP application such as SAP Business Suite system or SAP S/4HANA using ODP.

The objects that represent the interface between the SAP source system and the ODP Framework are the DataSources (SAP extractors) delivered by SAP, or generated by customers. Communication is performed using an RFC connection, or in case of SAP HANA Cloud, based on a HTTP-connection.

Data provisioning using ODP, based on SAP Extractors, is an alternative to previous usage of DataSources from SAP source systems. Previous usage consisted of using the standards SAP Service API and qRFC outbound delta queue (transaction RSA7). This classical Delta Queue is replaced in the SAP NetWeaver ODP framework by the ODP delta queues (tr. ODQMON).

The new approach offers advantages, such as:

  • Simplified communication between SAP source and SAP BW and configuration of data transfer. In this way communication using synchronous RFC, ALE/IDocs is skipped and the data transfer is no longer controlled using the qRFC outbound queue.

  • The data transfer process (DTP) in particular can retrieve data directly from ODQ. This replaces InfoPackages and loading using the PSA, as delta-enabled DTPs can directly retrieve data from ODQ and load it into SAP BW/4HANA InfoObjects or DataStore Objects (advanced).

  • Delta data of the application can be retained for a definable time period in the (operational) delta queue. It can then be requested for an according time period again by DTP.

Prerequisites for SAP DataSources to Be Used in the ODP Context

To use an SAP system as ODP Provider the following prerequisites have to be met:

  • Release level of source system as indicated in this table:

  • SAP Business Suite or SAP S/4HANA (on Premise) DataSources need to be released in order to be able to use them in ODP context in SAP BW/4HANA. The released objects are listed in table ROOSATTR (DataSource Attributes) with an existing flag in the EXPOSED_EXTERNAL field.

    • Report BS_ANLY_DS_RELEASE_ODP for SAP delivered DataSources

    • Report BS_ANLY_DS_RELEASE_ODP for SAP generated DataSources

    • Report RODPS_OS_EXPOSE for customer developed DataSources


You can check SAP note 2232584 and 2481315 for more info about extracting from SAP Systems to SAP BW or SAP BW/4HANA using ODP.

Launch the next demo to explore a data flow using an SAP_ODP DataSource:

Explore a Data Flow using a SAP_ODP DataSource

Log in to track your progress & complete quizzes