Skip to Content
Product Information
Author's profile photo Ranjitha Balaraman

Discover CDS View Based Extractors from SAP S/4HANA Cloud


Data extraction and replication makes it possible to transfer data from an SAP source system, such as SAP S/4HANA Cloud, to the target system SAP BW/4HANA. This includes the metadata description of the source data that is to be transferred to SAP BW/4HANA, as well as delta extraction mechanisms.

CDS View based extractors are available from SAP S/4HANA Cloud 1905 CE.


Starting from SAP S/4HANA 2020 you can use the CDS view ‘I_DataExtractionEnabledView’ to identify CDS views available for data extraction. You can call it in SAP S/4HANA in tr. SE16 and table name ‘IXTRCTNENBLDVW’. You can use the filter ‘DeltaChgDataCaptureIsSupported’ to find the delta enabled views.

CDS View based extractors (CDSV extractors) are released CDS Views that are enabled for data extraction (full) by the annotation @Analytics.dataextraction.enabled: true.

CDSV extractors that support delta extraction contain the annotation

CDSV extractors could be found using the View Browser app in a SAP S/4HANA Cloud system or SAP S/4HANA Cloud Trial system.

The steps to find the list of CDSV extractors are mentioned below:

  • In the SAP S/4HANA Cloud system, choose the App Finder and search for the View Browser app.
  • Open View Browser app from the search results.

  • Change the Standard variant to Released Views variant.

  • Enter the search text @Analytics.dataextraction.enabled:true in the Search box and press Enter.
  • Choose Document Export button to download the list of CDSV extractors.

Note: Datasource names are not part of the document export list as of now and might be included in the future.

Data Source

Data source name for a given CDSV extractor could be found with the below mentioned steps.

  • Select a CDS View from the resulting list in the View Browser app.
  • Open Annotation tab and find the value of the annotation abapcatalog.sqlviewname. This value is the Data source name.

CDS View corresponding to a given Data source could be found with the below mentioned steps.

  • For a given data source name like IYEARMONTH, find the corresponding CDS View by searching View Browser with the search text @abapcatalog.sqlviewname:’IYEARMONTH’


The details of the CDS View i.e. fields, annotations, business object, references etc., could be found in the View Browser app. The business documentation of the CDS Views could be found here.


CDS View based Extractors are now available and can be discovered via View Browser app. CDS View based extractors are not a 100% match with the classical BW extractors due to the change in the data model in SAP S/4HANA. Hence, alternative CDS View based extractors cannot be listed for each classical extractor. The alternate extractors could be derived by closely checking the details of the CDS View based Extractors in the View Browser app and via the business documentation.

Further Reading

Extracting CDS Views to SAP BW/4HANA

How to use ABAP CDS for Data Provisioning in BW

Analytics Annotations

Assigned Tags

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

      Thanks alot for this Ranjitha!

      One question, when you mention 'SAP S/4HANA Cloud 1905 CE' - what does the CE stand for?

      Author's profile photo Ranjitha Balaraman
      Ranjitha Balaraman
      Blog Post Author


      CE is the short form for "Cloud Edition"

      Author's profile photo Johannes Bacher
      Johannes Bacher

      Hello Ranjitha,

      we need to extract data from S/4HANA Cloud to an external data warehouse (non-SAP product).

      Would you recommend to use these CDS-based extractors? Can they be consumed (like APIs) from external systems? Do they provide a comprehensive dataset or would I need to extend it?

      Or would you rather recommend to build custom CDS and expose them as APIs? (this is my current assumption, but now I read about extractors and I am not sure.

      Thank you for your help,


      Author's profile photo Frank Riesner
      Frank Riesner

      Hi Johannes,

      extraction enabled CDS views leverage the NetWeaver ODP (Operational Data Provisioning) framework. BW is a typical consumer of this, but not the only one. To stage towards other targets you have the choices of SAP DataServices, SAP HANA SDI (ABAP Adapter) or OData which are all able to consume the ODP interface and forward the data to any target (incl 3rd party).



      Author's profile photo Ram Krishnan
      Ram Krishnan

      Hello Ranjitha,

      Thank you for the blog. Could you please let me know, whether

      can we use CDS view extraction in SAP cloud platform ( HANA cloud inside SCP) . Instead of BW as target, can we use the SAP Cloud platform as target ( HANA Cloud inside SCP).





      Author's profile photo Ranjitha Balaraman
      Ranjitha Balaraman
      Blog Post Author

      Hi Ram Krishnan It is not possible now but is in the roadmap.

      Author's profile photo Hari Prasad Gupta
      Hari Prasad Gupta

      Hello Ranjitha,


      Do we have standard CDS based extractor available for S4HANA 1809 on premises. How and where we can find them.




      Author's profile photo Ranjitha Balaraman
      Ranjitha Balaraman
      Blog Post Author

      Hi Hari,

      Starting from SAP S/4HANA 2020 you can use the CDS view I_DataExtractionEnabledView to identify CDS views available for data extraction.

      With SAP S/4HANA 1809 OP, you could use View Browser application and the steps mentioned in the blog to see the list of CDS Views which are extraction enabled.

      Kind Regards,


      Author's profile photo abdulhameed elnajjar
      abdulhameed elnajjar

      Hi Ranjitha,

      Thanks for sharing this blog.

      I have seen the below comment by Frank Riesner on another blog and I thought it might be helpful if you added it to this blog.

      "I think there is another option to find extraction enabled CDS Views now in SAP S/4HANA starting with version Cloud version 2008 / on premise version 2020:
      We provide a CDS View I_DataExtractionEnabledView, which provides a list of them. You can call it in SAP S/4HANA in tr. SE16 and table name = IXTRCTNENBLDVW we well."



      Author's profile photo Frank Riesner
      Frank Riesner

      Hi Abdulhameed,
      I have just published an updated blog post which might be an interesting source to deep dive into this topic:

      Regards - Frank

      Author's profile photo Torsten Wirth
      Torsten Wirth


      In the DBW462 Training (Delta BW7.5 to BW/4) it is mentioned that data sources like 2LIS_17*, 2LIS_11*, 2LIS_12*, 2LIS_13*, 0FI_GL_* are not existing in S/4 Cloud. But for me in this description it is not absolutely clear if absolutely no classic Datasources exist anymore in S/4 Cloud or only some are not existing. If all are not existing anymore the text is very confusing because some datasources are mentioned as examples.

      In Note 2500202 - S4TWL - BW-Extraktoren in SAP S/4HANA only the extractors for S/4 on premise are mentioned. I did not find something similar for S/4 Cloud

      Based on the fact that all content in BW is based on the classic extractors that would mean the whole BW has to be rebuilt and I don't see much content for that in BW/4 at the moment and even the content in DWC is very limited based on the documentation.