topic Re: database table in Application Development and Automation Discussions

database table

Former Member — Thu, 31 Jan 2008 05:41:02 GMT

Hi,

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

Re: database table

Former Member — Thu, 31 Jan 2008 05:43:09 GMT

Hi,

U can maintain your email Id in the SCot transaction.

reward Appropriate points.

Regards,

SIMI.

Re: database table

former_member188829 — Thu, 31 Jan 2008 05:43:15 GMT

Hi,

ADR6

Re: database table

Former Member — Thu, 31 Jan 2008 05:45:33 GMT

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

Re: database table

Former Member — Thu, 31 Jan 2008 05:45:34 GMT

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....

Re: database table

Former Member — Thu, 31 Jan 2008 05:47:50 GMT

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

Re: database table

Former Member — Thu, 31 Jan 2008 05:50:36 GMT

Hi,

How can i get the customer mail id..

please help me

Re: database table

Former Member — Thu, 31 Jan 2008 05:55:26 GMT

table is ADDR6 and field is SMTP_ADDR

reward points if helpful,

kushagra

Re: database table

Former Member — Thu, 31 Jan 2008 05:58:44 GMT

Hi,

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

Regards,

Abdullah

Re: database table

Former Member — Thu, 31 Jan 2008 06:00:18 GMT

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.

Re: database table

former_member188829 — Thu, 31 Jan 2008 06:06:42 GMT

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