Table Name which stores Vendor e-mail id

[Former Member]

Hi Team,

Please let me know in which table the e-mail ids of vendors would be stored.

I have gon ethrough the t.code XKO3.iN E-MAIL id field it is directing to structure and field <b>SZA1_D0100-SMTP_ADDR</b>.

Regards

Badari Talanki

[Former Member]

Hi badri,

look for ADR6 table

take the address number of the vendor and get the mail id from the address number from this table .

adr6-SMTP_ADDR

regards,

Vijay

<b>lfa1- lifnr ,

lfa1-adrnr,

adr6-adrnr

adr6-SMTP_ADDR</b>

Message was edited by: Vijay

[Former Member]

EKKO contains Address number (ADRNR) field,with that addres number go to ADR6 table and get the email adrress(SMTP_ADDR).

[anversha_s]

hi,

chk this

adr6-adrnr
adr6-SMTP_ADDR

lfa1-adrnr

Rgds

anver

pls mark all hlpful answers