topic Re: XD01 in Application Development and Automation Discussions

XD01

Former Member — Mon, 10 Mar 2008 11:43:25 GMT

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

Re: XD01

Former Member — Mon, 10 Mar 2008 11:45:17 GMT

Hi,

You can Find it from ADR6

Field Name is SMTP_ADDR

Reward Point if Useful.

Re: XD01

Former Member — Mon, 10 Mar 2008 11:59:44 GMT

Hi,

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

You can link to this table by addressnumber.

Re: XD01

Former Member — Mon, 10 Mar 2008 12:18:15 GMT

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.

Re: XD01

Former Member — Mon, 10 Mar 2008 12:26:13 GMT

Hi,

Go to table T024 and see the field name SMTP_ADDR.

Regards

Kiran Sure