Skip to Content
avatar image
Former Member

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?



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 31, 2014 at 05:26 AM

    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.




    Add comment
    10|10000 characters needed characters exceeded