Vendor Master report with address, telephone number & email ID

[Former Member]

Dear All,

Kindly provide to me T Code for Vendor master report along with vendor address,Telephone number & email ID.

Krajesh

[Former Member · Accepted solution]

Hi,

go to table :SE 16

Etnter : LFA1

enter the vendor no

you can get the vendor no,vendor name and telephone no.

convert to excel file

Regards

Ganesh

[Former Member]

This message was moderated.

[Former Member]

Hi Rajesh .... in case customer require specific information, you can also try using sap queries (trust me it is not as difficult as it sounds but the results are just great ;-):

Table SZA1_D0100 have the following fields

SMTP_ADDR (E-mail Address) ; TEL_NUMBER ; MOB_NUMBER ; FAX_NUMBER

For address check table ADDR1_DATA

Common join should be Vendor among these 2 tables

Hope this helps !!!

Edited by: m_n_novice on Aug 7, 2009 11:08 AM

[murugan_mgl]

HI,

MKVZ

[Former Member]

Dear All,

I know about MKVZ report, in this report below fields are missing.

1. Telephone Number.

2. Fax Number.

3. email address.

Is there any other report on that?

Rajesh

[Former Member]

check this S_ALR_87012077 - Vendor information system

[Former Member]

Dear Friend,

Use MKVZ transaction

it will give the vendor list along with all the details

Regards

Pramod