Table for Vendor Master Email ID

[Former Member]

Hello,

Can you please tell me the table where Vendor Email ID is stored and also how to connect it from LFA1-ADRNR in ECC 6.0?

Thanks,

Venu

[Former Member · Accepted solution]

adr6-addrnumber

use select statement like this.

select addrnumber into addr from adr6 as a inner join lfa1 as b on a_{addrnumber = b}adrnr.

[Former Member]

LFA1-LIFNR, ADRNR

ADRC- ADDRNUMBER

ADR6- ADDRNUMBER, SMTP

Query will be:

Select A.LIFNR as Vendor, A.ADRNR as Add Num, C.SMTP as Email from

LFA1 A,

ADR6 C

where A.ADRNR=C.ADDRNUMBER

[gouravkumar64]

Hi vinit,

This thread already answered & very old thread

Thanks.

Gourav

[Former Member]

Get the ADRNR field from LFA1 Table, and get the email ID from adrc table.