Skip to Content

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

Report of general authorizations

Messrs.

Good afternoon, I have to report a user of SAP, that this report will come your user name, department and the commitments that this user owns.

But being with the system information marked, sailed to the screen with '* Commitments *'at the bottom appeared to me the table name OPRM when I do a SELECT * * me return this table that this table does not exist, even if I do the SELECT * * by the query generator * SAP * or * * SQLSERVER not find is the table.

Anybody can help me as I come to this table by select, select follows below:

  • SELECT *

  • T0. [U_NAME] the 'User name', *

  • T1. [Name] as'Department' *

  • T0 * FROM OUSR

  • INNER JOIN T1 ON OUDP T0.Department = T1.Code *

Att

Daniel Becker

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