Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Org Value AGR table

Former Member

‎03-17-2009 2:26 AM

0 Kudos

Hi All,

I am trying to find the org values of my roles. I know about tables AGR_1251 and AGR_1252.

AGR_1252 does not help me. I need the org values as well as the activity values, obviousley AGR_1251

does not help either.

Is there any way i can combine any tables which can give me the following.

1- Roll Name

2-Org values along with activities.

Any help would be appriciated.

Raj

5 REPLIES 5

Former Member

‎03-17-2009 7:26 AM

0 Kudos

Hi,

Join the tables AGR_1251 and AGR1252 and add the select the below fields in SQVI.

Role Name (AGR_1251)

Field name of an authorization (AGR_1251)

Authorization value (AGR_1251)

Profile generator: Organizational levels (AGR_1252)

Authorization value (AGR_1252)

Authorization value (AGR_1252)

You will get the desired output.

Regards,

Gowrinadh

Former Member
In response to Former Member

‎03-17-2009 1:59 PM

0 Kudos

To the best of my knowledge 1252 does not bring up org values like authorizations values in 51. You can not make a link between 51 and 52 since 52 does not bring up org levels along with their auth Objects. If you still think there is a connection, help me understand which fields would joing with what beside AGR

Former Member
In response to Former Member

‎03-17-2009 3:44 PM

0 Kudos

just look at the variable field in AGR_1252 in there you will see the authorisation field like $BUKRS that links to the authorisation field BUKRS in AGR_1251. And in AGR_1251 you will see $BUKRS as value!

ther is no Object field in AGR_1252 as the value is supposed to be active against all Objects with the same field in AGR_1251.

As that is the general idea behind the table split!

Former Member
In response to Former Member

‎03-19-2009 2:38 PM

0 Kudos

Hi,

You get the object information as well. You just need to select the below fields from respective tables listed in brackets and execute the quick view.

Role Name (AGR_1251)

Field name of an authorization (AGR_1251)

Authorization value (AGR_1251)

Auth. Object in User Master Maintenance (AGR_1251)

Profile generator: Organizational levels (AGR_1252)

Authorization value (AGR_1252)

Authorization value (AGR_1252)

Regards,

Gowrinadh

Former Member

‎03-17-2009 2:35 PM

0 Kudos

Not completely sure what you want but ...but all the Org levels are Auth fields correct ...

so use AGR_1251 to execute for fields ACTVT and lets say if plant is your Org level then for WERKS

you will get the list of roles with activtiy and plants