OPRM Table?

[Former Member]

When in the Authorisations screen, the SAP B1 table this is associated with to OPRM.

BUT the OPRM table is not available in the query generator? And it is not available in crystal?

Can you please advise if this table can be accessed and how?

Thanks in advanced!

[Former Member · Accepted solution]

hi,

Actually OPRM is system table which is hidden.

User Authorization is hard coded in front end itself,

You can't find any information from tables.

Jeyakanthan

[gagan_thareja · Accepted solution]

Dear Lisa,

Table OPRM you see from the Authorizations screen is a virtual table that you

cannot actually visit via queries. The authorizations information are actually saved by different users in the User table(OUSR) in encryption.

This is help to keep it safety used in the system.

Hope this clarifies your doubt.

Regards,

Gagan Thareja

SAP Business One Forums Team

[PauloF · Accepted solution]

Hi,