SAP Knowledge Base Article - Public

3148426 - SAP released CDS views not elegible as data source in "Custom CDS Views" app

Symptom

When trying to add a data source to a CDS view in "Custom CDS Views" application, the required data source doesn't appear. 

Environment

  • S/4HANA
  • S/4HANA Cloud
  • SAP Hybris Marketing Cloud

Reproducing the Issue

  1. Go to "Custom CDS Views" app 
  2. Open a CDS View and click on "Edit" button
  3. Click on "Add" > "Associated Data Source" or "Primary Data Source"
  4. Search for the data source

Cause

Search results are filtered by "Recommended Data Source". 

The data sources are automatically filtered by suitability so that initially only those data sources that are considered suitable for view building are displayed. These data sources include all custom CDS views, as well as those SAP CDS views that are explicitly recommended to be used when defining new CDS entities, i.e. modeling data sources (for primary data sources) or modeling association targets (for associated data sources).

Resolution

To view other data sources, click on Show Filters and set the filter for Recommended Data Source to "No". If you are not sure which data source to pick, use the View Browser app in order to find a data source that is suitable for your needs. Select a data source and continue. Every custom CDS view needs to have exactly one primary data source. Other data sources can be added as associated data sources later. Note that all key fields from the primary data source are automatically added to the element selection on the Elements screen.

See Also

SAP Help Portal - Supported Capabilities

SAP Help Portal - Creating CDS Views 

Keywords

custom cds views, primary data source, associated data source, recommended data source, show filters, cds view not appearing , KBA , BC-SRV-APS-GKE , Generic CDS Key User Editor , Problem

Product

SAP S/4HANA Cloud all versions