how to determine which company code a customer is assigned

[Former Member]

hi

anybody knows how a customer is connected to a company code

i know its connected to several company codes but i want to know the original company code

[Former Member]

Hi there,

In XD03, when you give the customer num, then there is an option called Customer sales area. Click that. It will show you what are all the sales areas assigned to the customer.

In XD01, you create customer with respect to company code. In VD01, you dont include thecompany code data.

Regards,

Sivanand

[Former Member]

ok, will do that

and wll come back if im not getting it right

actually im doing a functional spec, which is a report whereby I have to retrieve all the customers for a company code

In that list of customers for that company, I should retrieve as well the original company of that customer,

Thats why I was asking as how to find the original company

[Lakshmipathi]

Dear Anjali

Once we go into customer master, from top menu bar, you can select "Extras -- Administrative Data" by which, you will know on what dates, General Data, Company Code and Sales area data are created and by whom.

So if a particular customer is extended to multiple Company Codes, with the above date option, we can come to a conclusion which is the first one created.

thanks

G. Lakshmipathi

[former_member184555]

Hi

Anjali's question sounds valid. As per my understanding we cannot Create a customer many times. The customer will be created only once (say Customer 1000) and the same existing customer will be extended to other company codes and for other sales areas based on the requirement. The company code and the sales area details in which the customer was initially created should be traceable.

But I donot understand the reason for looking for these details.It will give more clarity on the requirement if the reason behind this requirement is also posted by Anjali.

Thanks,

Ravi

[Former Member]

There is nothing like a customer connected to original company code. When a customer is created in multiple company codes all are "original" for that matter.

When a customer is created for a company code the database table KNB1 will be updated with that record. When you extend the customer to another company code the same table will be updated with another record. Go to SE16, enter the customer number and view the records. Sort by created on and you will know when the first record was created in KNB1 table and when the subsequent records are created in KNB1 table.

Regards,

GSL.

[Former Member]

Hi,

You are making a slight confusion out here... the query in subject is different than the details...

Anyways.. assuming your subject as query -- you can go to XD03 > put cust. number > put sales area > then press F4 in company code field > you will get a pop-up > put the customer number > then you will be able to see the single/multiple company codes assigned to this customer.

Hrishi