BAPI_USER_GET_DETAIL - Last Logon Date not available

[Former Member]

From R3 I want to check the last logon Date (USR02-TRDAT) of a user in an outside system such as EBP or BW. BAPI_USER_GET_DETAIL seemed like a good choice but TRDAT is not passed to the BAPI. Last Logon Time is (LTIME) but not Last logon date (TRDAT). How can this be easily done.

Thanks,

-don.

[former_member589029]

If there is no standard BAPI available providing the last logon date you might want to think about creating an RFC that returns this data (USR02-TRDAT and LTIME). Don't forget to add an authorization check to your RFC to avoid unauthorized users to call it.

Hope that helps,

Michael

[Former Member]

Try using the RFC SUSR_GET_ADMIN_USER_LOGIN_INFO, the export parameter LAST_LOGON_DATE will return the Last logon date.

Regards,

Trikanth Basetty

[Former Member]

Yes, that will do the trick. Thanks for the quick response.

-d.

[Former Member]

the problem with this is that it makes a call for each user. If you have 100k users it becomes a very inefficient process.

If you build something in the backend to collect the details a useble format....1) it is custom, and 2) you need to deply in each backend and 3) maintain it in each backend.

not a good solution.

If anyone has better idea please shout. Again....this RFC call does the job.....but it is like empting a pool full of water with a  teaspoon, does the job but very inefficiently.

DenisO