Report of general authorizations

[Former Member]

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]

Hi,

The query which you have post wrong code / syntax.

Right syntax is post by Manvendra Singh , which will resolved.

Thanks

Kevin

[Former Member]

Hello

Manvendra Singh

Good day, I guess you do not understand.

I can not find the table OPRM is it that I need to do more to JOIN the two tables that already have.

The SELECT statement that brings some already assembled, but just give me the name and title, but must bring more commitments that OPRM this table, but when I SELECT this table SAP does not see this table.

Shows how this table does not exist.

I do a test:

SELECT * FROM OPRM

vera not hesitate.

Somebody else to help?

Att

Daniel Becker

[Former Member]

Hello Daniel Becker ,

Are you sure for this table(OPRM) which you find by system info if yes then let me know in whcih version you working .

Because SAP 2005 B,SAP 2007 B ,SAP 8.8 and SAP 8.81 does not have this table.

Thanks

Manvendra

Edited by: Manvendra Singh Niranjan on May 11, 2011 8:11 PM

[Former Member]

Friend,

It's just that you can not find the table.

But it is there, mark it so you system information and pass the mouse over the screen Commitments vera in the bottom of the screen, informing the OPRM own SAP table.

Then when you do a SELECT on the table, the result says that this table does not hesitate.

This is my doubt, which table can I find the authorization of the users of SAP

Version 8.1 of SAP

Att

Daniel Becker

[Former Member]

Hi Daniel,

For security, this table is never exposed to any users. In another word, it is not possible to use query to get user authorization.

If you need get general authorizations, you can only get them through export to Excel from authorization form.

Thanks,

Gordon

[Former Member]

Thanks Gordon, I've got the same question.

[Former Member]

Hello,

Try this,

-

---

SELECT T0.U_NAME As "User Name", T1.[Name] AS "Department"

FROM OUSR T0 INNER JOIN

OUDP T1 ON T0.Department = T1.Code

-

---

Thanks

Manvendra