Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

List of User SAP B1

Dear Expect,

I generated query to displayed userid, name, status, creation date, last login date, user group and role.Why certain information i couldn't get example

creation date and status. How to pull out user role and group?

SELECT T0.[USER_CODE], T0.[U_NAME], T0.[lastLogin], T0.[createDate] FROM OUSR T0

Please help.

Thanks,

Saufil

Not what you were looking for? View more on this topic or Ask a question