Skip to Content
Technical Articles
Author's profile photo Frank Riesner

SAP BW/4HANA 2021 SP04: Renovating ODP Extraction in HANA Runtime

Hello BW enthusiasts!

In one of my earlier blogs, I put a spotlight on BW Transformations in HANA Runtime from ODP sources. The trigger came from lessons learned during an in-place conversion to SAP BW/4HANA were my team ran into situations causing some headaches. The reason was, that there is no HANA Runtime for transformations on ODP sources in SAP BW 7.x – a gap which is closed in SAP BW/4HANA again based on the assistance of the so-called Data Transfer Intermediate Storage (DTIS).

However, the data is transferred to DTIS from ODP DataSources in serial mode only – which might lead in inferior total processing time compared to the classic ABAP Runtime which runs in parallel by default. As a result, some customers had to change back to ABAP Runtime or used PSA-like staging ADSOs to provision the data first into SAP BW/4HANA, before being able to put HANA logic on it.

The good news of today is, that this restriction has been removed:
One of the exciting new features of SAP BW/4HANA 2021 SP04 (released today / December 5, 2022) is the enhancement of the data extraction to DTIS: Now you can fill the DTIS in parallel from ODP DataSources. DTIS is now ready to receive large amounts of data in short time and DTPs can now make use of transformations in SAP HANA Runtime, and additional features like grouped extraction or error handling to update the incorrect records in the error stack. You can thus load the data into further data targets in a parallel and memory-efficient way, without the need for an ADSO as an intermediate layer, for example.


  • The process is not controlled by a process chain in streaming mode.
  • The ODP source system relies on an RFC connection.
  • The DTP´s execution is done in parallel background processing (i.e. no simulation).

The parallel filling of DTIS can be switched off via maintaining customizing view RSBKADMIN (tr. SM30). For example, the following entries prevent parallel filling of DTIS by a dedicated DTP:
– RSBKADMIN-VALUE = DTP technical name

You can also switch the feature off for all DTPs based on:

Note1: In scenarios where the extraction from the source system into the ODP Queue (i.e. the prior processing step) is the performance limiting factor, the parallelization of filling DTIS from the ODP Queue will hardly improve the overall performance! Performance benefits can only be expected in date processing from the ODP Queue into the SAP BW/4HANA InfoProviders based on the SAP HANA Runtime for transformations.

Note2: The parallel extraction from ODP to DTIS requires sufficient dialog processes in the source system (where the ODP Queue is managed in).

The purpose of this blog post is to follow-up on my earlier blog from November 2021 providing the crucial update, that former restrictions have been removed with the latest SAP BW/4HANA Feature Pack (SP04). For more details refer to following sources:
– SAP note 3232927: ODP Data Sources – Parallelize filling of DTIS via Prefetch
– SAP note 3237249: ODP Data Sources – Parallelize filling of DTIS via Prefetch; PREREQUISITE
– SAP BW/4HANA SP04 Release Information


By the way, this new SP of SAP BW/4HANA 2021 (release note 3220868) provides additional exciting enhancements, for example:

See more details see following official feature introductions published in the SAP BW/4HANA Community:
Presentation (PDF)
Webinar (24 min video)

Thanks to Karola, Horatiu and Claudia for your valuable input. 

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Roland Kramer
      Roland Kramer

      Hello Frank Riesner

      God to know this and there are other "renovated functions" available with SAP BW/4 2021 SP04.
      Best Regards Roland
      Author's profile photo Stefan Siemes
      Stefan Siemes

      Dear Frank Riesner

      thank you very much for this detailed blog.

      Maybe it's time to update the official BW/4 documentation with this crucial information:

      Transformation anlegen | SAP Help Portal

      We've got a lot of "ABAP old hands", who always find some arguments to stir up against HANA technology 😉

      Best regard,


      Author's profile photo Frank Riesner
      Frank Riesner
      Blog Post Author

      Thanks Stefan - valid comment.

      I will trigger an update of that Note:"With an ODP source system, we recommend using ABAP runtime, since the extraction is done by ABAP anyway. A transformation in SAP HANA would cause unnecessary effort, since the data must first be persisted."

      This is what you meant, right?
      Regards Frank

      Author's profile photo Frank Riesner
      Frank Riesner
      Blog Post Author

      The help documentation will be adjusted for the upcoming releases.
      KR Frank

      Author's profile photo Stefan Siemes
      Stefan Siemes