Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

database table

Former Member
0 Kudos

Hi,

In which table email id of the perticular employee will be stored.

10 REPLIES 10

Former Member
0 Kudos

Hi,

U can maintain your email Id in the SCot transaction.

reward Appropriate points.

Regards,

SIMI.

former_member188829
Active Contributor
0 Kudos

Hi,

ADR6

Former Member
0 Kudos

Pls check the table ' ADR6' and field 'SMTP_ADDR'

Former Member
0 Kudos

Hi,

call function 'BAPI_USER_GET_DETAIL'

exporting

username = username

importing

address = wa_address

tables

return = i_return.

move wa_address-e_mail to wa_recipients-recipient.

Don't forget to reward if useful..

Table is ADR6.

Don't forget to reward if useful....

Former Member
0 Kudos

Hi,

Infotype 105

Check pa0105 for the email addresses of an employee.

ADR6 is used for storing addresses of vendors. You get the address number(ADRNR) from LFA1 and pass it to the ADDRESSNUMBER of ADR6 to get the email address.

Regards,

Abdullah

Edited by: Abdullah Ismail on Jan 31, 2008 11:18 AM

0 Kudos

Hi,

How can i get the customer mail id..

please help me

0 Kudos

Hi,

Take ADRNR value from KNA1Table and pass it to ADR6 table ( where KNA1-ADRNR = ADR6-ADDRNUMBER) and get the email id (SMTP_ADDR) value.

Regards,

VISHNU

Former Member
0 Kudos

table is ADDR6 and field is SMTP_ADDR

reward points if helpful,

kushagra

0 Kudos

Hi,

you will get the adrnr field from table kna1 for the customer. pass this into ADDRNUMBER of adr6.

Regards,

Abdullah

Former Member
0 Kudos

Use Data element AD_SMTPADR for

the field in which you want to

store email address.

And the table in which it is used is ADR6 for SMTP number

and ADR7 for Remote Mail Addresses, similary you can look at ADRx series for business card service.

Reward if helpful.