SAP Knowledge Base Article - Public

3467820 - Custom CDS Views are not visible as sources for a Replication Flow in SAP Datasphere

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

Product

SAP Datasphere all versions