Building Query : Link between CRMD_PARTNER & BUT000

[Former Member]

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

[Former Member]

hello,

we also encountered the same problem. we managed this by using InfoSets.

regards.

[Former Member]

Hi Kezia,

Could you explain better how do this?

Of course i'm using an infoset to create a query... and in this i can not link these two table using the above keyfield...

Thank for the reply,

Regards,

Andrea

[Former Member]

we managed this by doing ABAP in infoset to link the two tables.

regards.

[Former Member]

Yes I immagine, but... could you help me in this?

[Former Member]

please refer to this [link|http://help.sap.com/saphelp_nw70/Helpdata/en/d2/cb45b2455611d189710000e8322d00/content.htm]

regards.

[former_member317957]

Hi Kezia,

Thanks for the information. Could you please share source code of the program?

Thanks!