SAP Knowledge Base Article - Public

3467525 - S/4 Cloud: Definition of view is too complex for automatic CDC

Symptom

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

In DataSphere tenant, replication of a CDC fails with error: 

Error occurred during execution of API activity
Error while processing subscription of CDS view
CDS view xxx is inconsistent
Definition of view is too complex for automatic CDC

p.s: This CDC fulfills the following conditions:

  1. It comes from a S/4 Cloud system.
  2. Just seeing from the name of the CDC, it's a standard CDC delivered by SAP.
  3. It's using automatic CDC which's has annotation 'delta.changeDataCapture.automatic' (but not delta.changeDataCapture:mapping).

Environment

  • DataSphere as the subscriber (target system)
  • S/4 Cloud as the provider (source system)

Reproducing the Issue

  • Login to DataSphere tenant -> Go to Replication Flow -> Run
  • The most straightforward way to reproduce this issue is:
    /nSE80 -> CDC name -> Syntax check -> Definition of view is too complex for automatic CDC
  • Meanwhile, checking in S/4 Cloud system:
    /nSA38 -> RODPS_REPL_TEST / Last Delta for CDC -> Execute -> Source xxx does not support deltas.

Cause

Just like the message shown in the DataSphere tenant, the definition of the CDC is indeed too complex. Usually this CDC works fine in SAP internal system and SE80 check has no 'too complex' warning returns. However if checking the definition of CDC using SE11 / SDDLAR / SE80, no customization can be seen.

However, there's a custom CDS View (using the data extraction scenario) appended to this standard CDC via 'Custom CDS Views' app. Then delta extraction is generally not available/supported.

See the online help:

https://help.sap.com/docs/SAP_S4HANA_CLOUD/0f69f8fb28ac4bf48d2b57b9637e81fa/2f8f8f549ab4472b97b7f90a0ee28291.html?version=2402.502

Resolution

As the above online document mentioned:

  • Only full-load extraction is supported for the custom CDS views created using the Data Extraction scenario. Delta extraction isn't supported.

Keywords

KBA , BW-WHM-DBA-ODA , Operational Data Provider for ABAP CDS, HANA & BW , DS-MD-AM , Analytic Model , How To

Product

SAP Datasphere all versions ; SAP S/4HANA Cloud all versions

Attachments

Pasted image.jpg
Pasted image.jpg
Pasted image.jpg