All customer data in one t code

[Former Member]

Hi Friends,

can any one tell me how to get the customer master data, i want to see all my customer data in a single t.code, please tell me its very urgent.

Regards

Karunakaran

[Former Member]

ok

[Former Member]

Hi Karunakaran,

There is no standard report that can show all the details pertaining to the customer , as data is stored through different tranactions in different tables .

There are 2 ways to do this.

One by means of Query and other by means of Abap report development.

KNA1 - Customer Master

KNB1 - Customer / Company Master

KNVV - Customer Sales Data

KNBK - Bank Details Master

KNVH - Customer hierarchy Master

KNVP - Customer partners Master table

KNVS - Shipment data for customer table

KNVK - Contact persons Master table

KNVI - Customer master tax indicator table

we need to acess all these tables to get the whole info.

We have to join all the tables and extract the desired data.

If you need further help on how to do queries or reports pls get back to us.

Happy to help you.

Regards,

Viveks

[Former Member]

You have to go for ABAP development.

But check the following t-code

S_ALR_87012179 - Customer List

S_ALR_87012180 - Address List

S_ALR_87012182 - Display Changes to Customers

S_ALR_87012183 - Display/Confirm Critical Customer Changes

S_ALR_87012195 - Customer Master Data Comparison

[Former Member]

Hi ,

That can be achived by writing an ABAP Querry and by performing a Join function on Tables such as KNA1 ,KNVV etc.

Best Regards,

Subbzz.