Table for user details.

[Former Member]

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.

[former_member214131]

hello,

check: BAPI_USER_GET_DETAIL

you get the Mail-ID in table ADDSMTP

regds; Murugesh AS

[former_member188685]

check the table <b>USR03</b>

REGARDS

VIJAY

[Former Member]

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]

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]

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]

Hi,

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

Regards

vijay

[Former Member]

hi,

  No not get  Email address  in ADR6 table.