Skip to Content

Hello All,

Do you know … What is ODP? Or How does ODP work? Or how you can use it? What are the prerequisites? What impact will it have…

Well… working as Development Manager in the SAP BW/4HANA Data Warehousing Development, I have received many questions on that topic in the last years. Please let me therefore share some important information with all of you:

Operational Data Provisioning provides a technical infrastructure that you can use to support two different application scenarios. The first of these is Operational Analytics for decision making in operative business processes (see Introduction to Operational Data Provisioning for more information).

The other very prominent application scenario is data extraction and replication: Operational Data Provisioning supports extraction and replication scenarios for various target applications and supports delta mechanisms in these scenarios. In case of a delta procedure, the data from a source (the so called ODP Provider) is automatically written to a delta queue (the Operational Delta Queue – ODQ) using an update process or passed to the delta queue using an extractor interface. The target applications (referred to as ODQ ‘subscribers’ or more generally “ODP Consumers”) retrieve the data from the delta queue and continue processing the data.

With SAP BW/4HANA, Operational Data Provisioning (ODP) now becomes the central infrastructure for data extraction and replication from SAP (ABAP) applications to a SAP BW/4HANA Data Warehouse. Already with SAP BW we recommend customers to use ODP for the implementation of new extraction and replication scenarios from SAP (ABAP) applications.

For the many more detailed questions on architecture, scenarios, implementation, prerequisites and availability we have compiled an FAQ document that we want to share with you now. Please find the full document here:

Operational Data Provisioning – FAQ

Feel free to comment on this FAQ list below. We are happy to update the FAQ list, as it is a living document.

To report this post you need to login first.


You must be Logged on to comment or reply to a post.

  1. Abhishek Hazra

    Good info Rudolf, may be you could give some insight about if an existing datasource can be converted to an ODP datasource? We are currently in analysis phase of feasibility study of moving to ODP datasources, & here I am talking with respective to HANA source system.

    Best Regards,

    1. Rudolf Hennecke Post author

      Hi Abhishek,

      There is no need to convert a Service API DataSource (aka “Extractor”). It only needs to be  released for ODP (see SAP Note in FAQ Document). You can then connect that DataSource to any BW using the ODP-SAPI Source System in BW.

      In case you want to convert from a running SAP Source System delta load (including delta queue) to the same delta load based on an ODP-SAPI Source System you can use the most recent version of our BW/4HANA conversion tools.

      Best regards,


  2. Roselie Webjørnsen


    Assuming we have 2 BW systems.  1 BW Classic and the other BW/4 HANA.   And we want to use the same Busines Content extractor for both but 1 is ODP and the standard?  Is this possible?

    Thanks in advance.

    Best Regards,


    1. Rudolf Hennecke Post author

      Hi Rose,

      Yes, it is possible, but it will multiply the data. ODP is a new source system for BW and would add the DataSource in a new context to the system.

      Please also note that there is a few Business Content DataSources (Extractors) that do not support multiple delta initialization for several (target) BW or BW/4HANA system. For more information see SAP Note 1932459 – BW DataSource: Loading of data into multiple BW target systems is not supported.

      Best regards,

  3. Philippe Buchet

    Hello Rudolf,


    I have two small questions for you :

    • If we have enhanced a standard SAP datasource with an append structure and via user exit function module or BAdI, will it still work using ODP ?
    •  How does the Operational Delta Queue handle the case of deleted records for SAP standard datasources and for generic datasources ?

    Thanks in advance

    Kind regards


  4. Bryn Evans


    Hi Rudolf,

    I have not been able to find a document explaining master data delta using ODP. For example 0WBS_ELEMT_ATTR is currently delta enabled however when using ODP it only allows FULL loads. Is there a way to enable delta for master data?





Leave a Reply