Table Name for Authorization

[Former Member]

Hai!

I am trying to write a query like, it should display the list of Authorization names and Authorization set for that user.

From the Authorization window i noticed it is storing in OPRM Table, but in the DB there is no Table called OPRM. Can anyone no where it storing?

Thanks,

Thanga Raj.K

[Former Member · Accepted solution]

It is possible to get with a bit of investigation. The table where it is stored is AUSR, usercode field is user, allowences field stores the authorizations, but youll have to parse it. But here you have no warranty, that in new PL the order of authorization will be the same.

[Former Member · Accepted solution]

Thanks Petr!

Can u say me how to parse it?

Thanks,

Thanga Raj.K

[Former Member · Accepted solution]

I dont know, but when youll look at the field and records in this table, for one user is there more records, so I think that for the final authorization youll have to get all values from allowances field and combine it together, becuase in my opinion only changes are stored.

As I wrote before, this is undocumented and better is dont make select for this. It is possible to do with SDK and connect with UI API to authorization tree and get the values from there (some job running every x minutes).

[Former Member]

thanks all

[Former Member]

Hai!

Gordon,Kerstin thanks for ur help.

Can u please tell me,if OPRM Table is hidden then how the change log is updated? Is it possible to hide a table in sql DB?

Regards,

Thanga Raj.K

[K_Pauquet]

Hi Thanga,

please see SAP Note [1175770 - User authorisations cannot be queried|https://service.sap.com/sap/support/notes/1175770]

All the best,

Kerstin

[Former Member]

Please check these theads:

Thanks,

Gordon

[former_member186095]

Hi,

it is hidden. you can't use the query to the table. What would you like the query shows ?

Rgds,

[Former Member]

Hai!

Thanks for your information.

Actualy i am writing a Log Report based on USER.

Expected Result is this:

Selection 1 : From date

Selection 2 : To Date

Selection 3 : User Name

Query should return :

User Code User Name Authorization-SubName Autho

Jim Jim Sales Order Full

Thanks,

Thanga Raj.K