uploading data from R/3 to CRM

[Former Member]

Hi Gurus,

We have the following scenario:

Our customer master data is created and maintained in R/3. Now we need to create and maintain in CRM.

1. we need to bring R/3 customer to crm and start maintaining only in crm

2. there should not be any number overlap

eg. 1000 customers in r/3 starting no. 1 to 1000, we need to bring this customer to crm and start maintaining in crm. then from cusotomer no. 1001 onwards need to create from crm.

Can anybody help me on the steps to be followed and the configuration settings to be maintained. How the number ranges have to be maintained and what settings should be done in CRM and R/3 before transfering the data.

Also the steps on how to upload data from R/3 to CRM??

Thanks.

Divya Gupta

[Former Member · Accepted solution]

Hi,

You need to do the following settings...

1. Defining number ranges for CRM as it is in ECC but make it external....

2. Defining CRM business partner groupings.

3. Map CRM classifications to ECC account groups in PIDE transaction(ECC)

-

---

R3 to CRM settings

4. Now upload the customer from R3 to CRM

-

---

go to R3AC1

-

---

In the Load Object field, enter CUSTOMER_MAIN.

-

---

In the Source Site field enter OLTP and in the Destination Site field enter CRM.

-

---

To run the replication, choose Execute (F8).

5. Once the load is complete change the Number ranges in CRM from External to internal.

6. Map ECC account groups to CRM classifications in PIDE transaction(ECC)

-

---

R3 to CRM settings

regards,

Sameer Ahamad

[Former Member]

Hi Divya,

Create 2 different number ranges and groupings and assignement in CRM system

For Ex:

Create a number range(External) with 1 to 1000 and create a grouping ABC and do the assignment(R/3 customers)

Create a number range(Internal) with 1000 to 100000 and create grouping XYZ and do the assignment (New customers)

we need to bring R/3 customer to crm and start maintaining only in crm

Do the following settings in R/3 system to bring the customer data from R3 to CRM

T Code: PIDE

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

Select the Account group which is created in R/3 for customers and set classification as B and select the grouping as ABC(Defined).

and start initial download in CRM system with T.Code R3as

Load Object = CUSTOMER_MAIN

Source Site (Sender) = R/3

Destination Site (Receiver) = CRM

and Execute.

It will bring the customer data from R3 to CRM.

While creating new customers in CRM system select the grouping as XYZ to avoid overlaping.

Regards

Narayana