Vendor account number ,Name and Email

[Former Member]

Hi

I am looking for solution where i can download Vendor account number,name

and email address,is there any standard table in SAP to download this data,i tried

Abap query with LFA1 and ADR6 tables but it is not working ,can any help on this

Thanks

Lily

[Former Member]

Hi,

Table LFA1 and ADR6 are right but in query, these tables will not be linled by system authomatically.

You have to link these table manually by using field ADRNR in table LFA1 and field ADDRNUMBER in table ADR6.

I hope it will resolve the issue.

Regards,

Vinod

[Former Member]

I resolved this issue on my own,thanks for your replies

[rwarri1]

Hello,

LFA1 and ADR6 are the correct tables for email address. How are you downloading the data and why does it not work ?

Cheers !