Fetch users from USR02 based on System ID's.

[Former Member]

Hi All ,

I am having a requirement in which I need to fetch Users from USR02 from the system other than I am logged into.

I need to get users based on System ID's.

Please provide me your inputs on the same to proceed further.

Thanks in Advance.

[Former Member]

Step1 : You need to create RFC in each system from where you want to fetch the data.

in that RFC write the select queries and pass all the parameters by Value only.

Step 2: Get all the System Id's with you.

Step 3: Write a report .

Case Sysytem ID;

When 'abc'.

call your RFC Function module DESTINATION "Logical System Name of the System"

Endcase.

[Former Member]

Hi,

Are you looking for below code?

SELECT * FROM USR02 CLIENT SPECIFIED WHERE MANDT = T000-MANDT AND

BNAME = USER.

Thanks,

Surya

[Former Member]

Use RFC_READ_TABLE and pass the table USR02 to this RFC FM.

you will be able to fetch the data. this way you can get the users data.

Also you can use TH_USER_LIST....Pass the MANDT value in TABLES parameter of this FM and it will return you the users terminal ID (TID)...

Regards

[Former Member]

Please help to resolve this..

Edited by: harsh bhalla on Jun 18, 2009 8:46 AM

[GauthamV]

Use this FM.

THUSRINFO