Vendor Master details with email address

[Former Member]

Dear sir,

How to get the list with all the vendor with address, contact nos. and email ids.

pls let me know the T code for the same.

devesh

[kunal_ingale]

hi

you have to take it from query or TABLE

check following

Edited by: Kunal Ingale on Jul 6, 2010 8:42 AM

[Former Member]

HI,

go to table :SE16

Etnter : LFA1

enter the vendor no / leave blank for the list

you can get the vendor no,vendor name, telephone no., & email.

convert to excel file

pherasath

[Former Member]

Hi,

Using T-code MKVZ - List of Vendors : Purchasing, give input data purchasing organization, Account Group and execute the report display all vendor details which is already stored in data base and report top line click Change Layout button(blue color) it will open new window right side required data field selected and click <--- mark selected field come to left side and then press tick mark. now the report shown vendor related all data's are displayed.

Hope, it is useful for you.

Regards,

K.Rajendran

[Former Member]

Hi,

From the table LFA1 with the vendor number as LIFNR get the ADRNR number and then fetch the address details from ADRC with input of ADRNR

thanks

santosh

[Former Member]

Hi,

There is no standard report in SAP. You can acheive this by using LFA1 & ADR6 tables in query .

Thanks & Regards,

Renuga.A

[Former Member]

Hi,

Create a new report with the help of Abaper by using the following tables and fields.

LFA1->LIFNR,ADRNR

ADR6->ADDRNUMBER,SMTP_ADDR,SMTP_SRCH

Tcode MKVZ also used for but email address will be difficlut.

Regards,

MBKM

[Former Member]

the answer to your question is MKVZ -T.Code

[BijayKumarBarik]

Hi,

Need to create a Query (SQVI/SQ01) with tables LFA1 & ADR6.

Regards,

Biju K