SAP Knowledge Base Article - Public

2659496 - Incorrect Data in Preview of Custom CDS View or Custom Analytical Query


When previewing the data of a custom CDS view, or custom analytical query, the data may not appear to be correct



Reproducing the Issue

  1. Create a new custom CDS view using the Custom CDS Views app, based on a standard data source 
  2. Select the fields that you want for the view, changing at least one of the key fields to be a field from an associated data source
  3. Optionally, create a custom analytical query using the Custom Analytical Queries app
  4. Now when previewing the data for the CDS view or the query, there may be incorrect data for some rows


This can happen if you change the key fields to be a field from an associated data source


  1. Change the key fields of the CDS view to use the default defined key fields
  2. Check to see if the preview is now showing the correct data
  3. If this resolves the issue then always ensure that any changes to the key fields of a CDS view are done with caution, especially when adding associated data source fields as key fields


Associated key field preview view browser , KBA , BC-SRV-APS-GKE , Generic CDS Key User Editor , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem


SAP S/4HANA Cloud 1805