which tbale contains the user EMAIL address?
i want user email address of user.
i am not able find which table it will contains...
System -> User Profile -> Own Data.
This email field value in which table it will store...
Jorge Diogo replied
Tables USR21 and ADR6.
In table USR21 in field BNAME insert the username, you will get the PERSNUMBER and ADDRNUMBER, with it insert it in ADR6, unhide the field SMTP ADDR, or click two times on the entry and you will see the e-mail field.