topic Re: User E-mail address in Application Development and Automation Discussions

User E-mail address

Former Member — Tue, 24 Oct 2006 11:26:59 GMT

Hi ,

Can anybody tell me the table from which i can select the user's E-mail address, with the help of the user id in the "where" clause of the "select" statement.

Regards

Naren Rathinavelu.

Re: User E-mail address

venkata_ramisetti — Tue, 24 Oct 2006 11:30:25 GMT

Hi,

YOu can find in table ADR6.

USR21: TO GET ADDRESS NUMBER OF USER ID

ADR6: TO GET EMAIL ADDRESS OF THE ADDRESS NUMBER

Thanks,

Ramakrishna

Message was edited by: Ramakrishna Prasad Ramisetti

Re: User E-mail address

Former Member — Tue, 24 Oct 2006 11:32:57 GMT

hi,

Use FM ISR_GET_USER_DETAILS. You will get that.

Regards,

Chandra.

Note: Please reward if helpful.

Re: User E-mail address

Former Member — Tue, 24 Oct 2006 11:34:43 GMT

Hi,

thanks for the response, what i have is a user id with me not a personale number, how shall i get the e-mail address using my user id, please help.

Regards

Narendiran Rathinavelu

Re: User E-mail address

eddy_declercq — Tue, 24 Oct 2006 11:35:26 GMT

Hi,

Alternatively, you can use this FM

CALL FUNCTION 'FTR_CORR_CHECK_EMAIL_SAP_USER'

EXPORTING

i_user = user

IMPORTING

e_email_address = email

EXCEPTIONS

mail_address = 1

determination_error = 2

OTHERS = 3.

Eddy

Re: User E-mail address

Former Member — Tue, 24 Oct 2006 11:37:33 GMT

Hi,

use FM BAPI_USER_GET_DETAIL.

there are all Information you need.

regards, Dieter

Re: User E-mail address

Former Member — Tue, 24 Oct 2006 11:38:02 GMT

Hi Naren,

Use function module

EFG_GEN_GET_USER_EMAIL

CALL FUNCTION 'EFG_GEN_GET_USER_EMAIL'

EXPORTING

i_uname = l_dummy_user

IMPORTING

e_email_address = g_mail

EXCEPTIONS

not_qualified = 1

user_not_found = 2

address_not_found = 3

OTHERS = 4.

that should solve your problem

Reward if helpful ****

Re: User E-mail address

Former Member — Tue, 24 Oct 2006 11:38:23 GMT

Hi Naren,

Use the function module ISR_GET_USER_DETAILS, there input parameter is User id. You will get all the details. Check it once.

Regards,

Chandra.

Note: Please reward if helpful.

Re: User E-mail address

venkata_ramisetti — Tue, 24 Oct 2006 11:39:51 GMT

hi,

YOu can find in table ADR6.

USR21: TO GET ADDRESS NUMBER OF USER ID

ADR6: TO GET EMAIL ADDRESS OF THE ADDRESS NUMBER

tHANKS,

rAMAKRISHNA

Re: User E-mail address

Former Member — Tue, 24 Oct 2006 11:51:38 GMT

Hi,

here a short example

REPORT ZGRO_TEST.

DATA: BEGIN OF SMTP OCCURS 0.

INCLUDE STRUCTURE BAPIADSMTP.

DATA: END OF SMTP.

DATA: BEGIN OF RT OCCURS 0.

INCLUDE STRUCTURE BAPIRET2.

DATA: END OF RT.

CALL FUNCTION 'BAPI_USER_GET_DETAIL'

EXPORTING

USERNAME = SY-UNAME

TABLES

RETURN = RT

ADDSMTP = SMTP.

IF RT-NUMBER = 0.

LOOP AT SMTP.

WRITE: / SMTP-E_MAIL.

ENDLOOP.

ENDIF.

Regards, Dieter

Re: User E-mail address

Former Member — Tue, 24 Oct 2006 12:20:44 GMT

hi ,

Please try table <b>pa0105</b> it is an infotype for(Communications)

the 2 fields used are

USRID

USRID_LONG

but be careful with subtype...

0001 SAP System User ID

0005 Business Fax Number

0010 Business e-mail

0020 First Telephone Number at Work

Based on the organisation you may have custom subtypes

if for example you want to select business e-mail using a select query as follows

SELECT SINGLE usrid_long FROM pa0105

INTO wf_email_id WHERE

pernr = p9051-pernr

AND subty = '0010'

AND endda GE sy-datum

AND begda LE sy-datum.

*Hope you found the above information useful

Regards

Re: User E-mail address

Former Member — Tue, 24 Oct 2006 12:34:01 GMT

Hi,

One more point to be added to my above reply..

the user id is also there in pa0105,so you can select the mail id in relation to username also but the subtypes will make it a bit messy for you to grt the right record

Regards