List of customers

[Former Member]

Hi Gurus,

What is the T.Code for the List of Customers.

Is there any T.Code for this.as there is a code for list of Vendors MKAZ.

Thanks in advance

Regards

VASU

[Former Member · Accepted solution]

All the Customers created are stored in the Table KNA1 - Customer Master table General Data. Check this table.

All the T.Codes are stored in Table TSTC

you can explore the table TSTC in T.Code SE16 or SE11 and find the details of the T.Codes.

regards.

[Former Member]

VASU

T-Code VCUST is ultimate for Customer list. Because you have all option like Filter, sort, local fir and change layout etc.

Regards,

Srikanthraj

[Former Member]

For all practical purpose the list generated by F4 is used.

Any transaction (like VA01/2/3 or XD02/03) which requires the customer code to be entered in the "Sold-to Party" field provides F4 help. ie If you keep your cursor in the field and press F4 and delele the figure in the "Max no of Hits" field, it will give you the customer list. You can download it to excel.

[Former Member]

Hi ,

GO TO T CODE : SE16 ENTER the kna1, the enter the execute

you can find number of customers

[former_member183879]

Check whether the tcode S_ALR_87009957 can solve ur purpose.

S_ALR_87012179 also shoudl help you

[Former Member]

Hi Vasu,

Please Check the tcode VCUST -- List of customers with in the sales area

Reward points pls.

Regards,

Govind.

[Former Member]

Dear Friend,

Go to SE16 and

Check the tables for the Customer master data:

KNA1 General Data

KNB1 Customer Master – Co. Code Data (payment method, reconciliation acct)

KNB4 Customer Payment History

KNB5 Customer Master – Dunning info

KNBK Customer Master Bank Data

KNKA Customer Master Credit Mgmt.

KNKK Customer Master Credit Control Area Data (credit limits)

KNVV Sales Area Data (terms, order probability)

KNVI Customer Master Tax Indicator

KNVP Partner Function key

KNVD Output type

KNVS Customer Master Ship Data

KLPA Customer/Vendor Link

regards,

Amlan Sarkar

[Former Member]

Hi

Use transaction SE16 to access tables KNA1 or KNVV to get the list of customers.

Regards

Srikkanth

[Former Member]

S_ALR_87012179

OV50, VC/1 and S_ALR_87009957 are also useful

[Former Member]

Dear VASU,

Use transaction code VC/1. For this you need to activate SIS.

Regards,

Srikanthraj