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

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

Overview

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.

Discover

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 @Analytics.dataextraction.delta

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’

Documentation

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.

Conclusion

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

      8 Comments
      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

      Thanks!

      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,

      Johannes

      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).

      Bye

      Frank

      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).

       

      Regards

      Ram

       

      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.

       

      Regards

      Hari

      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,

      Ranjitha