Help Needed: Converting String to Date in SAP Datasphere

[Priyanka_27]

I am currently working on loading data from a CDS view in SAP S/4HANA to SAP Datasphere. CDS view includes a field RequestedDeliveryDate which is causing a data type mismatch error because it is being interpreted as a string instead of a date.

Thank you for your assistance

Best regards,

Priyanka

[ravikiran_sap]

HI Priyanka are you loading this CDS to a local table in DSP ?

[Mandar_Damle · Accepted solution]

Hello Priyanka,

As per SAP, this behavior is correct. We did the below workaround on the CDS side.

Use function DATS_TO_DATN for Date and TIMS_TO_TIMN for Time.

FYI -

3278347 - SAP Datasphere - ABAP Integration - Sending DATS and TIMS in native format - SAP for Me

3412699 - SAP Datasphere - ABAP Integration - Data Type missmatch when deploying a Replication Flow ...

Thanks!

Regards,

Mandar

[Priyanka_27 · Accepted solution]

Thank you sir

[pk88 · Accepted solution]

After adding DATS_TO_DATN we are facing issue from DataSphere. errorgetCSNDefinition: invalid remote object name: No enum constant com.sap.hana.dp.abapadapter.ABAPAdapter.ABAPDATATYPES.DATN: line 0 col 0 (at pos 0), Code: 476, SQL State: HY000 What will be the reason