Skip to Content
0
Former Member
May 10, 2011 at 08:18 PM

Report of general authorizations

23 Views

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