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?