table name - urgent

[Former Member]

hi all..

can any one tell me where the users email address is stored .. i mean which table holds the value..

thnx

[Former Member]

check the table <b>ADR6</b>

[Former Member]

<b>ADR6 - E-Mail Addresses (Business Address Services)</b>

Regards,

Pavan

[Former Member]

<b>Hiii

Users Email address are stored in ADR6

Donot forgot to reward points if helpful

Regards

hitesh</b>

[Former Member]

try the below code.

SELECT persnumber addrnumber

INTO (w_persnumber, w_addrnumber) UP TO 1 ROWS

FROM usr21 WHERE bname EQ sy-uname.

ENDSELECT.

IF sy-subrc EQ 0.

SELECT smtp_addr FROM adr6

INTO w_adr6

UP TO 1 ROWS

WHERE addrnumber = w_addrnumber

AND persnumber = w_persnumber.

ENDSELECT.

[Former Member]

Hi,

Check the following mail threads.

1.

Reward points if useful.

- Irudayaraj Peter

[graghavendra_sharma]

Best way to find out user's Email is using the following FM

EFG_GET_USER_EMAIL