cancel
Showing results for 
Search instead for 
Did you mean: 

Mapping Between Business Partners and Customers in CRM and ERP

Former Member
0 Kudos

Hi,

I wanted to know how are the business Partners and Customers replicated from ERP to CRM systems and Vice Versa. I would also want to know how can i check this mapping in the tables.

eg: Get a customer or BP from the ERP system, how do i find it in CRM system.

Regards,

Rishav

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Guids from the BDOC store help us to find data in the CRM tables.

Former Member
0 Kudos

Hi Rishav,

Here is the simplest way to do the mapping.

1.Pick the customer number from ERP(from table KNA1).

2. Feed the customer number in this function Module "crm_bsp_erp_map_customer_to_bp" and execute it.

3. It will give you the Business partner number on CRM ( from table BUT000)

Hope this resolves your issue.

Cheers,

Arumugam

Former Member
0 Kudos

Where is this function module available?

I dont find it in the ERP system!

Former Member
0 Kudos

Hi,

This Function module is available on CRM system.

Chk in txn SE37

Thanks,

Aaru

Former Member
0 Kudos

Ya i checked it there. I guess its not available in all the Releases.

Former Member
0 Kudos

Hi,

Go to transaction SE37.

Give this Function Module name CRM_BSP_ERP_MAP_CUSTOMER_TO_BP and execute it with R3 customer number. It will give you the CRM BP number as output.

This FM is available on CRM system.

Let me know if it works.

Cheers,

Aaru

Former Member
0 Kudos

Hi Everyone,

The problem is solved. Actually the GUIDS in both the CRM tables for customers and BPs would be same. From the BDOC store we can get the GUID and search it in the BUT000 and CRMM_BUT_CUSTNO table and get the answer.

Regards,

Rishav

robert_kunstelj
Active Contributor
0 Kudos

A mapping structure exists between business partners in SAP CRM and ERP customers (in both directions). In the ERP system you can see this mapping using transaction PIDE.

There you have 2 options...

CRM->R/3: Assign BP Classification to Account Grp.

R/3->CRM: Assign Account Grp. to BP Classification

You should create your own account group for the data transfer from SAP CRM to SAP R/3 / ECC.

Former Member
0 Kudos

Hi Rishav,

Here is how it works.

The table for customers in ERP is KNA1 and the field for customer number is KUNNR.

In CRM the table CRMM_BUT_CUSTNO contains the mapping between customer number in ERP and the BP GUID

in CRM. The table BUT000 in CRM contains the mapping between BP GUID in CRM and the BP Number

Apart from that the table CRMV_BUPA_CUSTNO contains the mapping between Business Partner Number and Customer.

Hope this clarifiies your doubt.

Best Regards,

Shourav.