07-18-2007 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.
07-18-2007 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