Question Re: Source CDS metadata incorrect with Replication Flow in Technology Q&A

Source CDS metadata incorrect with Replication Flow

MattRogers — Tue, 25 Apr 2023 11:33:33 GMT

I am trying to replicate a CDS object call I_BPCONTACT. It supports Data Extraction and Deltas

@EndUserText.label: 'Business Partner Contact'

//@Analytics.dataCategory: #DIMENSION //or #CUBE or #FACT
@Analytics: {
dataCategory: #DIMENSION,
dataExtraction: {
enabled: true,
delta.changeDataCapture: {
automatic: true
}
}
}

I can see that the metadata of the view has two fields of type DATS (ValidityEndDate/StartDate)

When I create the Replication flow - the ValidityEndDate/StartDate fields are brought across as strings - in fact all fields are brought across as strings

I can't change the source field data type within the Replication Flow and I can't map it into a Date field on the Target table as it complains the fields are incompatible.

When I try and run the Replication flow it errors saying that it cannot convert the values of the ValidityEndDate/StartDate columns

The data looks fine in the CDS from SE11 and I have tested the replication process using program RODPS_REPL_TEST from transaction SE38 successfully.

It looks to me that the metadata of the I_BPCONTACT CDS is not being transferred/read correctly leading to the date fields being identified as Strings but I'm not sure what I can then do about it?

Any suggestions gratefully received.

Re: Source CDS metadata incorrect with Replication Flow

Jonathan_Haun — Fri, 03 May 2024 20:23:56 GMT

I am having the exact same issue. The meta data support from CDS views in general is frustrating. When you replicate remote tables, it ignores the "@EndUserText: {label: " unless you first cast the column to break the base table metadata label. For Replication flows, it completely ignores the "@EndUserText:" {label: and sets the business and technical name to the same values. I'll try to get SAP's attention on this one... See if we can get an update.

Re: Source CDS metadata incorrect with Replication Flow

fabiosist — Tue, 25 Jun 2024 10:24:16 GMT

Hello,

Did you solve this issue? We are facing same issue.

Thanks

Re: Source CDS metadata incorrect with Replication Flow

MKreitlein — Tue, 25 Jun 2024 11:38:15 GMT

Hello all,

it sounds that the source S4 system is missing some important notes.

Please use program: CNV_NOTE_ANALYZER_DI and check which notes might be missing.

When you implemented all of them, from top to bottom, the usually this error should disappear.

I saw this latest end of February, if I remember right ... I try to keep the S4 up-to-date in regards to this program.

BR, Martin