topic Re: Fetch users from USR02 based on System ID's. in Application Development and Automation Discussions

Fetch users from USR02 based on System ID's.

Former Member — Wed, 17 Jun 2009 07:03:54 GMT

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 — Wed, 17 Jun 2009 07:08:10 GMT

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 — Wed, 17 Jun 2009 07:09:15 GMT

Hi,

Are you looking for below code?

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

BNAME = USER.

Thanks,

Surya

Former Member — Wed, 17 Jun 2009 07:09:55 GMT

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 — Wed, 17 Jun 2009 10:45:08 GMT

Please help to resolve this..

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

GauthamV — Thu, 18 Jun 2009 03:49:34 GMT

Use this FM.

THUSRINFO