Symptom
A copy of standard CDS views was done or a custom view was created to enable data extraction to be used in Datasphere
Environment
SAP Datasphere
Reproducing the Issue
Create a CDS view in ABAP system and try to consume it to extract data in Datasphere.
Cause
CDS views are visible to be used in Datasphere enabled only if it met all pre-requisites.
Resolution
Make sure that your CDS views are extraction enabled, also check the KBA 2890171 - SAP Data Intelligence - ABAP Integration, specially item 2, for Datasphere and item 3 for considerations.
Checked if CDS view shows warning message "Definition of view is too complex for automatic CDC". If so, it will not be shown in Datasphere as cannot be used.
The annotation @Analytics.dataExtraction.delta.changeDataCapture.automatic: true works only for CDS views that are fairly simple.
Putting projection view, add annotation @Analytics.dataExtraction.delta.changeDataCapture.automatic: true on standard CDS views is NOT supported.
Complex extensions with reference or associations to other CDS-views, the limit for automatic delta determination is exceeded.
This blog series contains a lot of details about this topic: CDS based data extraction - Part I Overview.
Keywords
cds view, no visible, abap, extraction, Too complex for automatic CDC delta, extension views , KBA , DS-DI-RF , Replication Flows , DS-DI , Data Integration/Data Builder , DS-DI-CON , Connections , Problem