Vendor list with complete address with contact nos.

[Former Member]

dear

i want to export the vendor list with complete address and contact nos.

i use <b>mkvz</b> for list of all the vendors but i do not get the address and contact no.

pls send the t-code or any setting parameters for the same

regds

devesh

[Former Member]

LFA1 & ADRC

Combination of these tables will help you

There is no standard report u r looking for

Create querry or customised report

[Former Member]

Dear

i can see the field name of telehone, mobile no. address in MKVZ but it doesn't bring the same.

regds

devesh

[Former Member]

It must have to show.

Check vendor master for wether u maintained that fields or not.

[Former Member]

Dear

i have checked it is maintained for all the vendors

regds

devesh

[Former Member]

hi

Try ADRC table in SE16 but u need a address number to get data which is available in LFA1 table as ADRNR field

now u will be able to fing street address with respect to vendor

If required u can club these reports to develop query take help from abaper

Vishal...