Customer List

[Former Member]

Hello All,

Is there a Tcode that gives a list of customers for a particular plant/company code with Customer #, Customer Name, Address with street, city, postal code, region, country, email and telephone?

Or do I need to create a query in SQ01?

Thanks

Edited by: rolakyng on Feb 8, 2012 3:19 PM

[former_member184701 · Accepted solution]

dear friend,

please try t-code VC/1

but I suggest thta sap query based on KNA1 is better...

good luck!

[Former Member · Accepted solution]

dear friend,
> 
> please try t-code VC/1
> 
> but I suggest thta sap query based on KNA1 is better...
> 
> good luck!

Thanks for the reply but unfortunately I do not have access to VC/1.

[former_member184701 · Accepted solution]

dear,

you would build sap query if you have access to SQ02, SQ01

first, run SQ02 and create a new info-set dioing Direct read of table KNA1

for example, do Include all table fields . generate and save it.

second, run SQ01 and create a new query using your new info-set. adjust the basic list and test it. when fixed -save it.

good luck!

[Former Member]

Dear You can easily do it via SQVI by joining the table KNA1(General Data for Customers) and KNB1(Company Code Data), this is very simple

Run TCODE SQVI

Give Quick View Name: Customer> Click on create

Give Details and in Data Source Select Table Join

Click on Insert table and First Enter KNA1 and then again click on insert table and click on KNB1 and join the table via KUNNR and execute the report

[Former Member]

Dear You can easily do it via SQVI by joining the table KNA1(General Data for Customers) and KNB1(Company Code Data), this is very simple 
> Run TCODE SQVI
> Give Quick View Name: Customer> Click on create
> Give Details and in Data Source  Select Table Join 
> Click on Insert table and First Enter KNA1 and then again click on insert table and click on KNB1 and join the table via KUNNR and execute the report

Thanks a lot Ashish. I cannot find the email field and is it possible to get the country in full text?