Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 20, 2017 at 01:59 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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