first name , second name , tel no. ?

[Former Member]

Having user ID ,

from which table i can get first name , second name , tel no. of the user ?.

and also i want to get the IP address of the user system.

help regarding this .

[former_member188685]

You can get the data from USR03 table

[Former Member]

Hi,

Use tables USR03,USR41.

Regards,

Sankar.

Edited by: sankar on Mar 25, 2008 7:16 AM

[Former Member]

Hi,

goto the table USR03.

rgds,

bharat.

[Former Member]

I am getting the details of the user such as first name, second name, tel number etc, in the transaction SU01

but in the table USR03 i didnt got those details ,

so is there any other table to store user details.

[former_member188685]

Step#1

Go to the Table USR21.

Give the user name , get the PERSNUMBER.

Step#2.

Go to the table ADRP with the PERSNUMBER from Step#1.

Thats all

[Former Member]

use

THUSRINFO fm to get all the connected users and then use TERMINAL_ID_GET to get the IP address

telefone number, first naem and second name you can get from USR03 table

-pankaj

[former_member708410]

hI,

DATA:TERMINAL LIKE USR41-TERMINAL.

CALL FUNCTION 'TERMINAL_ID_GET'

EXPORTING

USERNAME = SY-UNAME

IMPORTING

TERMINAL = TERMINAL

• EXCEPTIONS*

• MULTIPLE_TERMINAL_ID = 1*

• NO_TERMINAL_FOUND = 2*

• OTHERS = 3*

.

Reward if helpful

Regards

Vodka.

[former_member188685]

You can get the Ip address using the

system function

DATA: BEGIN OF USR_TABL OCCURS 10.

INCLUDE STRUCTURE USRINFO.

DATA: END OF USR_TABL.

call 'ThUsrInfo' id 'OPCODE' field opcode_list
      id 'TABUSR' field usr_tabl-*sys*

or else run the Function module

THUSRINFO

USR_TABL-HOSTADDR is the ip address field.

[Clemenss]

Hi jean,

it depends partly on the configuration and/or release/patch level of your system.

You can call the function BAPI_USER_GET_DETAIL. All you need can be found in export parameter ADDRESS.

The big advantage of using the BAPI is that it will always work.

Regards,

Clemens