Skip to Content
avatar image
Former Member

Search table AGR_1252 for Org Value Within a Range

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 01, 2013 at 07:41 AM

    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

    Add comment
    10|10000 characters needed characters exceeded