Skip to Content
Former Member
Dec 15, 2015 at 05:07 PM

ABAP CDS View: join tables on columns of different type



I am developing ABAP CDS Views to create views that run natively on HANA. These views are a join of different SRM tables.

As an example:

I want to join CRMD_PARTNER and BUT000 on the columns CRMD_PARTNER.PARTNER_NO = BUT000.PARTNER_GUID.

The problem is that one is of format RAW(16) while the other is of the format CHAR(32).

Writing the SQL code gives the correct result, building the ABAP CDS view however does not activate due to different types.