Enterprise Resource Planning Blogs by SAP
Get insights and updates about cloud ERP and RISE with SAP, SAP S/4HANA and SAP S/4HANA Cloud, and more enterprise management capabilities with SAP blog posts.
cancel
Showing results for 
Search instead for 
Did you mean: 
ranjithabalaram
Advisor
Advisor

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


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 @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
12 Comments