customer master data creation

[Former Member]

Hello Folks,

I need some confirmations please :

1 . customer master data (cmd) is created at account group and company code level.

So, if a customer is a customer of 3 company codes of a company , 3 customer master records needs to be created where the number range of the customer code being the same and the company code is different and the account group remains the same?

2. A customer can buy from any sales area combination in company code, but only 1 customer master record is created ? If so, 1 customer code is for any Sales areas for a customer?

So, Sales area is data fields in a customer master record and only account group and company code and the customer code are key fields in the definition of customer master record?

Please confirm for me. Thanks.

regards

Ravi

[former_member1190345 · Accepted solution]

Hi Ravi,

_Extension of the CMR_

a. If the Customer is buying from under 1 Company Code and multiple Sales Areas then you need to extend the CMR for all sales area.

b. However when the sales areas change the Customer No., General data and the Company code data does not change

While Extending the CMR by changing the Sales Area:

a. In XD01 or VD01 enter the Account Group of the customer which is to be extended

b. Enter the customer no.

c. Enter the New sales area

d. The system will take you directly to the sales area data

e. The Company Code data and the General data cannot be chosen.

While extending the CMR for different company codes:

a. In XD01 or VD01 enter the Account Group of the customer, which is to be extended

b. Enter the customer no.

c. Enter the New Company code

d. The system will take you directly to the Company Code Data

e. The Sales Area Data and the General data cannot be chosen.

While extending the CMR for different company codes and sales Areas:

a. In XD01 or VD01 enter the Account Group of the customer, which is to be extended

b. Enter the customer no.

d. Enter the New Company code

e. Enter the New Sales Area

f. The system will take you to the Company Code Data

g. Then you can go to the Sales area data.

h. The General data cannot be chosen.

Tables Used for CMR:

Table Name Used For

KNA1 General Data

KNVV Sales Area Data

KNB1 Company Code Data

Q. Why are there 3 Data Groups or 3 different Tables for one customer?

Ans. Since the Customer is expected to buy in more than one sales area and also in some cases in more than one Company code different data sets need to be maintained but however some data remain same, so to avoid data redundancy you maintain 3 different tables.

Hope this helps,

J Nagesh

[Former Member]

 1 . customer master data (cmd) is created at account group and company code level.
So, if a customer is a customer of 3 company codes of a company , 3 customer master records 
needs to be created where the number range of the customer code being the same and 
the company code is different and the account group remains the same? 

No, you need not have to create 3 customers for 3 company codes. You just need to create one and extend the same customer for all three company codes. It will be of same account group.

 2. A customer can buy from any sales area combination in company code, but only 
1 customer master record is created ? If so, 1 customer code is for any Sales areas for a 
customer? 

Yes, thats correct. But the customer has to be extended to all the sales areas in which you want him to buy.

Hope this helps...

Regards,

Mukund S

Edited by: MukundHS on Feb 24, 2011 10:23 AM