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: 

Table for user details.

Former Member
0 Kudos
1,206

I need to get the email address of all users. Some body please tell which system table is used to get the details of all the users.

Thanks.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
165

Hi eswar,

1. There are 2 tables:

ADR6

USR21

2. From Usr21

Get PERSNUMBER

ADDRNUMBER

For BNAME = username

3. Then

From ADR6

Get SMTP_ADDR , etc.

For Above

ADDRNUMBER and

PERSNUMBER

I hope it helps.

regards,

amit m.

7 REPLIES 7

former_member214131
Active Contributor
0 Kudos
165

hello,

check: BAPI_USER_GET_DETAIL

you get the Mail-ID in table ADDSMTP

regds; Murugesh AS

former_member188685
Active Contributor
0 Kudos
165

check the table <b>USR03</b>

REGARDS

VIJAY

Former Member
0 Kudos
166

Hi eswar,

1. There are 2 tables:

ADR6

USR21

2. From Usr21

Get PERSNUMBER

ADDRNUMBER

For BNAME = username

3. Then

From ADR6

Get SMTP_ADDR , etc.

For Above

ADDRNUMBER and

PERSNUMBER

I hope it helps.

regards,

amit m.

Former Member
0 Kudos
165

Hello,

To get the email add of the user, use these following tables.

USR21 & ADR6.

From USR21 get the Address number & Personal Number .

By using the above details u can get the email Id of the user the table ADR6.

Regards,

Vasanth

former_member188685
Active Contributor
0 Kudos
165

hi,

check these fm's for full details of user.

      USERNAME_ = IT_SALESDATA-USERID.

      CALL FUNCTION 'SUSR_USER_READ'
        EXPORTING
          USER_NAME            = USERNAME_
        IMPORTING
          USER_LOGONDATA       = LOGONDATA_
          USER_DEFAULTS        = DEFAULTS_
          USER_ADDRESS         = USER_ADDRESS
        TABLES
          USER_PARAMETERS      = IT_PARAMETERS
        EXCEPTIONS
          USER_NAME_NOT_EXISTS = 1
          INTERNAL_ERROR       = 2
          OTHERS               = 3.
      IF SY-SUBRC = 0.

        CALL FUNCTION 'ADDR_PERS_COMP_GET_COMPLETE'
          EXPORTING
            ADDRNUMBER        = USER_ADDRESS-ADDRNUMBER
            PERSNUMBER        = USER_ADDRESS-PERSNUMBER
          IMPORTING
            ADDR3_COMPLETE    = ADDR3_COMPLETE
          EXCEPTIONS
            PARAMETER_ERROR   = 1
            ADDRESS_NOT_EXIST = 2
            PERSON_NOT_EXIST  = 3
            INTERNAL_ERROR    = 4
            OTHERS            = 5.
        IF SY-SUBRC = 0.
          CALL FUNCTION 'ADDR_CONVERT_TO_BAPIADDR3_V2'
            EXPORTING
              ADDR3_COMPLETE      = ADDR3_COMPLETE
            IMPORTING
              ADDR3_COMPLETE_BAPI = IT_ADDRESS.
          IF SY-SUBRC = 0.
            I_SFTMEMBER      = IT_ADDRESS-FULLNAME.
            I_SFTMEMBERPHONE = IT_ADDRESS-TEL1_NUMBR.
            I_FIRSTNAME      = IT_ADDRESS-FIRSTNAME.
            I_LASTNAME      = IT_ADDRESS-LASTNAME.
          ENDIF.
        ENDIF.
      ENDIF.

regards

vijay

former_member188685
Active Contributor
0 Kudos
165

Hi,

Check the table ADR6 here you can get the e-mail address.

Regards

vijay

0 Kudos
165

hi,

  No not get  Email address  in ADR6 table.