DataType mismatch in CDS Views

[rajanikanth111]

Hi Experts,

We have a requirement to fetch only the interactions, permissions, subscriptions coming from Forms.

To achieve this we would like to join I_MKT_ContentPageFormResult and I_Mkt_Interaction .
Apart from the contactUUID, the other linking factor which differentiates the interactions which belong to a specific form can be identified by Interaction Source Object ID which will contain the ContentPage Form UUID.
since I_MKT_ContentPageFormResult-ContentPageFormUUID(RAW16) and I_Mkt_Interaction- InteractionSourceObjectID(TEXT50) are of different datatypes, the system is not allowing us to either use them in Join condition or in Filter or compare them in any way in the calculated fields.
Could you pls let us know how else we can find the exclusive interactions coming from a specific Form.

Regards,
Amshu

[former_member226]

Hi,

Yes, that's true if the data type between 2 fields doesn't match then you can not join them for the obvious reason of inconsistent data model. And SAP donot allow you to change the properties in filter or condition.

However, you can try to use "Add Custom View" app and export the table. Then model a join view/data source in SAP WebIDE for HANA Development. There you will see an option for casting the datatype from String to UUID(raw). Once done then import again against "Unassigned" type. I hope this works but dint tried myself.

BR