Phone number and email ID

[Former Member]

Hi,

Can you please tell me which tables should be looked into to find a person's telephone number and email,Thanks.

Regards,

Pinky

[Former Member · Accepted solution]

hi , check the table

ADR2 - for telephone number ,

ADR6 - for email address .

key field in both tables ADDRNUMBER,PERSNUMBER

THANKS

chinnaiya

[Former Member]

Hi,

select BNAME from USR03 for your user name

Get Person number and address number from USR21 with BNAME from USR03

and then with address number obtained fetch email address from ADR6.

[Former Member]

Hi,

You can get the information from the table ADRC Addresses (Business Address Services)

Field name for telephone number TEL_NUMBER

For Email address

SMTP_ADDR

And you have the common field between these two tables

ADDRNUMBER

Thanks

Ramakrishna Pathi