Beginners Question

[Former Member]

I am new to Hana and have been asked to build a view for Webi Reporting. Two of the tables I have to join are BUT000 and CRMD_Partner.

The join fields are Partner_GUID on BUT000. and Partner_No on CRMD_Partner. All this should be straightforward but Partner_GUID is a VARBINARY (length of 16) and Partner_No is NVARCHAR (length of 32).

As these are standard SAP tables and join fields there should be a standard way to join them. I built an attribute view and it fails to validate giving a message that the join fields are not the same type.

I built a graphic calculation view and this failed to return any data, probably implying the join was not working correctly.

Can someone please advise how to achieve the join?

Thanks

Cliff

[amol_samte]

Hi Cliff,

Take projection for BUT000 and create calculated column for PARTNER_GUID with NVARCHAR 32 and write in expression editor PARTNER_GUID, so new calculated column would be same type of Partner_No for table CRMD_Partner .

Then create join.

-

Regards,

Amol