Search table AGR_1252 for Org Value Within a Range

[Former Member]

Does anyone know how to search for a specific organizational value within the low and high fields in the AGR_1252 table?  Either through SE16N or SQVI preferably.  I am able to find the data I need in SUIM however I have huge amounts of data to query on including joining table AGR_USERS and AGR_1251 so it would be helpful to be able to use SQVI instead.

An example of what I am searching for is to find org value $WERKS (plant) 1000 within the range low 999, high 2000. 

Thank you!

[Former Member]

You can build more complex queries with report rsusr008_009_new and also use AND and OR operators between groups of the objects being queried. You just need to get the hang of how the customizing works first - many people fail here already when seeing a view cluster for the first time... 😉

Working with subsets in the other SUIM reports also works for me.

Otherwise you will need a write your own program because sqvi wont handle that.

Cheers,

Julius

[Frank_Buchholz]

I doubt that this report can find roles containing specifig authorization org. values (I cannot verify this currently because of missing system access). Nevertheless here are some important links for this report:

Online Documentation RSUSR008_009_NEW

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/f9/558f40f3b19920e10000000a1550b0/frameset.htm

Export/Import Critical Authorizations for RSUSR008_009_NEW

https://cw.sdn.sap.com/cw/groups/exportimport-critical-authorizations-for-rsusr008009new

Kind regards

Frank