Role ID, querying multiple auth objects & single value

Question: I'm looking for away within SAP that I can (possibly SUIM) do the following:

Query multiple authorization objects within the same criteria using a single value to determine all roles that fit this criteria. For example, lets say that I want to find all of the roles that have all Warehouse Number auth objects with exactly 600 as its value? This is what I know.

L_BWLVS
L_LGNUM
M_IS_LGNUM
M_MATE_LGN
W_APPT

Warhouse Number (Value): 600 = What ROLES?

Any Ideas? Can it be done?

Answer:
Hi refunk,
try looking in AGR_1251 Table.

further info at
/forums/viewtopic.php?t=10145&highlight=agr1251

try using the search engine on "AGR_1251".
regards.
_________________
by finding out what the problem is, you got 50% of the solution.
( sentence is not mine, but trust me, it's true! ).
full time member of 'tuly idiot club'.

Answer:
You will need a report, one that SAP doe snot have. Table search will not resolve ranges OR org levle field that are translated in another table. OPF0 using Info-overview-authorization ( type all in caps ) will give you the closes answer.

Answer:
Note 587410 gives an example of how you can search for profiles and roles which contain a specific value.

Tarryn

Answer:
Note 587410 gives an example of how you can search for profiles and roles which contain a specific value.

Tarryn
That will not work for combinations of 5 objects. A custom report or plenty of patience would be your best bet.
Copyright ?2007 - 2008 www.jt77.com