Relation ship between Partner and sales group

[Former Member]

Hi,

Pls Explain me how can i get the relationship between business Partners and Sales office, sales group in CRM.

We need to restrict search result of business partners with respect to sales group , sales office.

***********************************

Purpose:

We need this to enhance search functionality. Currently in PCUI it can search for Business partner with several restrictions like address...etc...

we need to add sales group, sales office also as a restriction.

*************************************

Thanks in advance.

Sarathy

[Former Member · Accepted solution]

Hi

In the table CRMM_BUT_LNK0141 youll have a mapping between the PARTNER_GUID and SET_GUID.

Get the SET_GUID corresponding to the PARTNER_GUID and

in the table CRMM_BUT_SET0140 you can get the Sales Office,Sales Group etc by giving the SET_GUID.

Ranjit

[Former Member · Accepted solution]

Thanks a lot. Its working