2

Source CDS metadata incorrect with Replication Flo... - SAP Community

 4 months ago
source link: https://community.sap.com/t5/technology-q-a/source-cds-metadata-incorrect-with-replication-flow/qaq-p/12681972
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

Source CDS metadata incorrect with Replication Flow

MattRogers

Explorer

on

‎04-25-2023

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)

2159407-image.png

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

2159408-image.png

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

2159410-image.png

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.


About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK