Downloading Vendor Email ID in SRM

[Former Member]

Hi,

Need to download Vendors Email ID for all vendors in SRM,w/o help of Query and ABAP.

I am aware of table BUT000 and ADR6..and ADR6 stores all vendor Email's but i am not able to find a linking table between

BUT000 and ADR6.

The Address field in BUT000 and address field in ADR6 are different.

Have searched lot of tables like ADR10,11 ADRC...and so on but no luck.

Regards

Ratha

[Former Member · Accepted solution]

Hi Ratha,

Please go to Table - BUT020 and provide the vendor number, you will get the address number,

Then pass this address number to Table - ADR6, you should be able to receive the vendor email address.

Thanks,

-Devi Swain

[Former Member · Accepted solution]

Hi Devi Swain,

Thanks.Your reply solved my problem.

Regards

Ratha