SAP Knowledge Base Article - Public

3472575 - The CDS view cannot be found when using Data Flow via S/4 HANA Connection in Datasphere

Symptom

When creating a new Data Flow in Datasphere, upon opening the Source tab and expanding the S/4 HANA Connection, the CDS view is not displayed in the list.
The same issue exists when using an ABAP connection or when using Replication Flow.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP Datasphere

Reproducing the Issue

  1. Create a new Data Flow in Data Builder.
  2. Open Source tab.  
  3. Expand the S/4 HANA Connection.
  4. Some CDS Views are displayed, but the expected one cannot be found.

Cause

  • The release status of the CDS View is not correct.
  • The CDS View needs to be manually loaded into Datasphere.

Resolution

  1. The CDS view must be enabled for data extraction from SAP S/4HANA, CDS View I_DataExtractionEnabledView lists all of them.
    1. Run transaction code SE11.
    2. Select "View" radio button.
    3. Input the SQL name of CDS View I_DataExtractionEnabledView - "IXTRCTNENBLDVW".
    4. Click Display button. Click Contents button.Execute and check the result.

  2. If the CDS view cannot be found in I_DataExtractionEnabledView, check whether it has annotation @Analytics.dataextraction.enabled, and whether it is C1-released.


  3. If the CDS view can be found in I_DataExtractionEnabledView but it is still not displayed in Data Flow, it needs to be manually loaded into Datasphere,  because Data Flow will only show the first 100 entries.
    1. To browse all available objects, click "Import from Connection" to open the Import Objects from Connection dialog.
    2. Expand "CDS_EXTRACTION", 150 objects will be displayed.
    3. Input CDS view's name and search.
      Note: Only first
      1000 entries can be displayed in the search result.
    4. Select the expected CDS views and click the Next button. Then click "Add Selection" to finish the import. 

See Also

Keywords

search CDS view, Data Flow's limitation, Replication Flow's limitation, cannot find CDS views, import CDS views , KBA , DS-DI-DF , Data Flows , CA-DI-IS-ABA , ABAP Integration , DS-DI-RF , Replication Flows , Problem

Product

SAP Datasphere all versions

Attachments

Pasted image.png