SAP Knowledge Base Article - Public

3757601 - custom cds view cannot be published: error "no assoc. found for key field validityenddate; either add assoc. or remove data cat #dimension"

Symptom

  • Publishing a custom CDS view fails.
  • Error message: "No assoc. found for key field VALIDITYENDDATE; either add assoc. or remove data cat #DIMENSION".

Environment

  • Product: SAP S/4HANA Cloud Public Edition
  • Generic CDS Key User Editor

Reproducing the Issue

  1. Open the Custom CDS Views app.
  2. Open the relevant custom CDS view.
  3. Start Publish; the process fails with the stated error message.

Cause

  • No association found for key field VALIDITYENDDATE while the view uses data category DIMENSION, as indicated by the publish error.

Resolution

  1. Open the Custom CDS Views app and select the affected custom CDS view.
  2. Go to Element Properties.
  3. Locate elements ValidityStartDate and ValidityEndDate.
  4. Enable Semantic Value for both ValidityStartDate and ValidityEndDate.
  5. Save the changes.
  6. Publish the custom CDS view again and confirm the publish succeeds.

See Also

Keywords

custom cds views, publish error, publishing failed, validityenddate, validitystartdate, data category dimension, no assoc found, association missing, semantic value, element properties, analytical scenario, key field, cds view publish, cds modeling, dimension , KBA , BC-SRV-APS-GKE , Generic CDS Key User Editor , Problem

Product

SAP S/4HANA Cloud Public Edition all versions