Skip to Content
0
Former Member
Oct 06, 2011 at 05:26 PM

Building Query : Link between CRMD_PARTNER & BUT000

420 Views

Hello Expert,

While I'm elaborating a Query, I'm trying to retrieve information from BUT000 table by entering on CRMD_PARTNER table.

The issue is on the table joining . The key should be CRMD_PARNTER-PARTNER_NO vs BUT000-PARTNER_GUID.

As i already read on internet the problem is about the filed type:

- CRMD_PARTNER-PARTNER_NO is of type CRMT_PARTNER_NO that is defined as CHAR 32.

- BUT000-PARTNER_GUID is of type BU_PARTNER_GUID which is defined as RAW 16

Someone could explain me how i can manage this issue on a query?

Thank you in advance,

Regards,

Andrea