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,