Skip to Content
Former Member
Dec 31, 2014 at 02:38 AM

Beginners Question


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?