Can not use replication flows to replicate CDS Views from S4HANA OP to Datasphere

[sophie2024]

Hi all,
I want to replicate CDS Views from S/4HANA On Premise to Datapshere using Replication Flows but I get this error while trying to import the CDS Views "Getting dataset definition failed for <the path to cds view>"

I have checked the relevant SAP Notes but could not figure out what the problem is.
In the CDS Views, there is also these annotations specified

@Analytics:{

dataCategory: #DIMENSION,

dataExtraction: {

enabled: true,

delta.changeDataCapture: {

automatic : true

}}}

Appreciate help from everyone in the community. Thank you!

@tobias_koebler @DanielKraemer @VinayBhatt 
I have seen the articles from you guys, maybe you can help here...? Many thanks!

[MKreitlein]

Hello @sophie2024 

unfortunately you don't write if you have checked and implemented all the notes in SE38 program: CNV_NOTE_ANALYZER_DI  (see: https://me.sap.com/notes/3016862)

This is really vital... since there have been so many notes for Replication Flows during the year 2023, until Jun. 2024. The bad thing is, SAP does not really communicate this pro-actively 😪 There should be regular messages in Datasphere, just like when there are new functions...

I try to keep my affected S4 system always up-to-date and luckily found no issues during the last months.

BR, Martin

[Martin_Kuma]

Check ABAP: RODPS_REPL_TEST. Will provide you more clues. Your CDS view may be too complex for the automated CDC to use the primary key. Try own delta 

Annotation: 

delta.byElement : {
name: '[FIELD]',

[TuncayKaraca]

Hi @sophie2024,

There might be something going on in the S/4HANA systems, maybe some SAP Notes need to be applied, etc. You can check the S/4HANA backend and see if there are any clues for the error you are getting. Second, have you tried the same CDS view with a data flow?

Thanks,
Tuncay

[bheemeshRao]

Hi Sophie, could you please provide the CDS view you are trying ? (seems like a standard CDS view).