2007 Jul 18 12:39 PM
In 2004s,
Does anyone know the table that contains the user ID and their assigned Profitcenter hierarchy node (using 0Profitcenter as Auth relevant)?
We need a quick way to validate the correct assignments by user.
I am not sure exactly what you are looking for but here are a few tables that might help
RSECAUTHTRUSER - list users assigned to authorizations
RSECHIE - links authorizations-characteristic-hierachy name and piece
RSECHIEVIEW - user to authorization to hierachy to infoobject
RSECUSERAUTH - user to authorization
RSECVAL - authorization to characteristic to value (values not in a hierarchy)
RSECVALVIEW - user to authorization to infoobject (characteristic) to value not in hierarchy
2007 Jul 18 1:53 PM
I am not sure exactly what you are looking for but here are a few tables that might help
RSECAUTHTRUSER - list users assigned to authorizations
RSECHIE - links authorizations-characteristic-hierachy name and piece
RSECHIEVIEW - user to authorization to hierachy to infoobject
RSECUSERAUTH - user to authorization
RSECVAL - authorization to characteristic to value (values not in a hierarchy)
RSECVALVIEW - user to authorization to infoobject (characteristic) to value not in hierarchy
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |