Customer e-mail address

[Former Member]

Hi,

How to get the customer e-Mail address and in which table is stored.

Is there any function module to get that...

and in which transaction, I can see the mail ID.

Regards

Jiku

[former_member188829]

Hi,

Check the Table ADR6.

SMTP_ADDR-->Field Name..

[Former Member]

Hi

Take the KNA1-ADRNR field and pass to <b>ADR6</b> table and take the email id (SMTP_ADDR) field and use it

Regards

Anji

[Former Member]

In ADR6, ADRNR is not only the key field....there are three more fields which are part of the primary keys...

PERSNUMBER

DATE_FROM

CONSNUMBER

How to handle this...

i.e, For same ADRNR, there are so many PERSNUMBER in my case...how to get a unique e-Mail ID???

[JozsefSzikszai]

hi Jiku,

KNA1-ADRNR = ADR6-ADDRNUMBER

there should be only one entry for a customer (the rest of the key fields are handled internally by the system)

ec