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?

Thanks

Cliff

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.

    -

    Regards,

    Amol

    Add comment
    10|10000 characters needed characters exceeded