Table to find one to one mapping of Partner ID and Sales Organisation in CRM

[Former Member]

Hello Experts,

We are looking for a table which can give us unique record for Partner ID and user's sales organisation, Basically 1:1 relationship table for Partner and Sales org.

We have already identified table CRMM_BUT_LNK0011 but it has lot of entries and Partner ID and Sales Org is getting repeated for Division and Dist channel, So returning almost 6 millions of records. if we eliminate these duplicate records then it's coming to 300 thousand of records which is quite less.

This is required in order to improve the performance as with current table it takes lot of time.

Your help would be appreciated, Thanks.

Regards,

Abhishek Wajge

[spencer_liang]

CRMM_BUT_LNK0011 is the table. There is no 1:1 table because BP : Sales area is n:n, rather than 1:1.

If you select record from CRMM_BUT_LNK0011 with specified bp guid and sales area, how could you find 6 million records?

If you go to se11, you will find that the primary key for this table is [client, bp guid, sales org, dist chan, div, valid to]. If you know about DB and primary key, you may find out why there are 6 million entries.

In addition, see note 2142491 - Low performance in Accounts search due to Huge Sales Area data.

but it has nothing to do with your question.

[Former Member]

Hi,

We are filtering the records based on Sales area and that is why it's giving 6 millions records.

Table CRMM_BUT_LNK0011 returns 16 records for each BP GUID and sales area, and that's expected because dist chan, div, valid to are also key's.

What i am looking at is a table which has only BP GUID and Sales area as key.

But it seems there is no table in CRM which has BP GUID and Sales area as key, So i have modified a query now to handle the performance.

Thanks for your comment, Appreciate it.

Regards,

Abhishek