topic Re: Table Name which stores Vendor e-mail id in Application Development and Automation Discussions

Table Name which stores Vendor e-mail id

Former Member — Mon, 06 Nov 2006 07:14:04 GMT

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 — Mon, 06 Nov 2006 07:19:31 GMT

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 — Mon, 06 Nov 2006 07:20:37 GMT

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

anversha_s — Mon, 06 Nov 2006 07:28:10 GMT

hi,

chk this

adr6-adrnr
adr6-SMTP_ADDR

lfa1-adrnr

Rgds

anver

pls mark all hlpful answers