Vendor list with their mail address

[Former Member]

HI experts,

I need a report which gives list of vendors in our plant .

in that it should give Vendor Name,Vendor Number and Email address.

I tried with MKVZ and LFA1..but not able to find.....

Please guide me in this.

Thanks

MK

[Former Member · Accepted solution]

hi MK

U need to create query by clubing table LFA1 and ADR6 to get all details required by u

As vendor email is stored in ADR6 table

Vishal...

[Former Member · Accepted solution]

hi

Also if u do not want to create Query

Extract both tables in excel

with reference to address number ( which is common in both tables ) put simple

v look up formula so that u will get email address in LFA1 excel sheet

( <b>Note that address number is common link betn two tables</b> )

some usefull info i found on <b>SDN</b> about creating query

check if usefull

User T-code: SQVI

Enter your "query name" and press"create"

Enter title

In Data source " select Table join"

select basis mode and press continue.

Press Insert table and give the tabes one by one.

Drag the parameter and drop in another table to establish link and link all the tables.

Press check to check whether your link is correct, then press back

You will be able to see the tables and fields on left hand side.

Select the appropriate parameters for selection fields and list fields

Selection fields- For selection of data, the initial screen of report.

List fields are nothing but output.

Execute the report.

You will find the initial screen of report.

Give your parameters for output and execute again.

You will receive the desired output.

You can down load the output in spread sheet/ in the format desired.

At last save your query before coming out of transaction

Vishal..

[Former Member · Accepted solution]

Dear Vishal,

Really I Appreciate for your detailed reply....

I did as per your suggestion and my problem is solved....

Thanks alot......

Regards

MK

[Former Member]

dear friend,

use the following T-code for the required report.

S_ALR_87012087 - Address List

hope solved your problem

Njoy

Ashish

**reward if useful