Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Not what you were looking for? View more on this topic or Ask a question