XD01

[Former Member]

Hi all,

I have customer (KUNNR) address number

and i can see address of customer in ADRC table with this address number.

In my customer address there is Email Field and in ADRC table there is flag field fot Email. If the customer had Email then Flag i s'X'.

Now , from which table i can found the Email address of this customer.

Pls tell me

[Former Member]

Hi,

You can Find it from ADR6

Field Name is SMTP_ADDR

Reward Point if Useful.

[Former Member]

Hi,

You can see the e-mail address on ADR6 table.

You can link to this table by addressnumber.

[Former Member]

Hi,

Input customer ( KUNNR) in table KNA1and get ADRNR.

Using this adrnr goto table ADR6 with ADDRNUMBER = KNA1-ADRNR( adress no got from KNA1) and PERSNUMBER = ' ' and get SMTP_ADDR which is the email id.

Alternatively you can use fm ADDR_COMM_GET by inputing ADDRESS_NUMBER = KNA1-ADRNR and TABLE_TYPE = 'ADSMTP'. you will get the email address in table parameter COMM_TABLE.

Hope this helps.

harikrishna.

[Former Member]

Hi,

Go to table T024 and see the field name SMTP_ADDR.

Regards

Kiran Sure