topic Re: Customer e-mail address in Application Development and Automation Discussions

Customer e-mail address

Former Member — Tue, 11 Dec 2007 07:07:40 GMT

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 — Tue, 11 Dec 2007 07:09:12 GMT

Hi,

Check the Table ADR6.

SMTP_ADDR-->Field Name..

Former Member — Tue, 11 Dec 2007 07:09:36 GMT

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 — Tue, 11 Dec 2007 07:20:40 GMT

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 — Tue, 11 Dec 2007 08:10:09 GMT

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)