Application Development and Automation 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: 
Read only

first name , second name , tel no. ?

Former Member
0 Likes
1,596

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 .

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,556

You can get the data from USR03 table

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 .

9 REPLIES 9
Read only

Former Member
0 Likes
1,557

You can get the data from USR03 table

Read only

Former Member
0 Likes
1,556

Hi,

Use tables USR03,USR41.

Regards,

Sankar.

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

Read only

Former Member
0 Likes
1,556

Hi,

goto the table USR03.

rgds,

bharat.

Read only

0 Likes
1,556

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.

Read only

0 Likes
1,556

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

Read only

Former Member
0 Likes
1,556

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

Read only

Former Member
0 Likes
1,556

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.

Read only

Former Member
0 Likes
1,556

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.

Read only

Clemenss
Active Contributor
0 Likes
1,556

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