Skip to Content
Technical Articles
Author's profile photo Mayank Jaiswal

BW Extractors, CDS Views Extraction into Native HANA via SDI – Part II

Hi All,

In this blog we are going to cover 2nd Scenario Data Extraction from CDS views to Native HANA system via SDI

In the first blog we had covered – Data Extraction from BW Extractors to Native HANA system

Requirement – To Extract CDS Views Data from S/4HANA to Native HANA system.

Pre-requisite & ABAP Adapter settings – Already discussed in Part I of the blog.

Detail Steps

  • Create CDS view as shown below – It should have all the annotations needed for Extraction, Delta Fetch and annotation to detect deleted records.


CDS view – with required annotations

  • Check CDS view under Remote Source – You will find it with SQL View Name, in this case ZCDSSOHDRITM$F (Note Dollar($) F stands for Data Category as Fact)


CDS view under remote source

  • Create Flow Graph as shown below –


Final Flow Graph

  • Flow Graph Source n Target – As discussed in Part I of the blog Source of the flow graph is Virtual Table created on top of CDS view and Target is Column Table.
  • Settings of Data Source in Flow Graph – 


Source – Virtual Table settings

Source – Delta Settings

  • Target Table setting in Flow Graph – Upsert mode


Writer Settings in Flow Graph – Upsert Mode

  • Execute the Flow Graph – Once the Job is executed successfully observe the Subscriptions in ODQMON. I ran the job with delta setting but there are 2 extraction requests –  one with init without data transfer and other with full load.




  • Check the number of records in source n target – It’s 1782
  • Delta test with an example – Transaction VA02
    • Sales Order Number – 1716
    • Item 10, Material –  8900103
    • Quantity – 25


SO – 1716

  • Check the same in Native HANA table


SO Value in HANA Table


  • Change the Sales Order – New Item 20 is added with Order Qty 45


SO Updated with Item 20

  • Execute the Flow Graph and check the entries in HANA Table


New Item in HANA Table

  • Change the Order Qty of item 20 to 110


Updated Order Qty of item 20

  • Check the Delta Entry in ODQMON – 2 records since Order & Item forms are the key in CDS view

Delta entry in ODQMON

  • Check the updated value in HANA Table


Updated order value

  • Delete the Sales Order Item 20 for the order 1716
  • Execute the Flow Graph and check the Delta Queue entry – Item 20 comes is transferred with Order Qty 0.


Deleted Order Item – comes with 0 value

  • Check the Order again in HANA Table


HANA table – Item 20 is updated with 0


Conclusion – Extraction From CDS views in Native HANA works fine, except that table entries may grow with deleted records. These records can be identified easily and filtered out in the modeling views.

Mayank Jaiswal & Hemant Patidar


Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Abdul Hakim Sulaiman Batcha
      Abdul Hakim Sulaiman Batcha


      For data extraction from S/4 HANA using ABAP CDS to Native HANA system after installing the DP agent and creation of remote system etc, is there any specific configuration needed on S/4 side like ODP configuration? Please clarify.