topic Re: Org Value AGR table in Application Development and Automation Discussions

Org Value AGR table

Former Member — Tue, 17 Mar 2009 02:26:16 GMT

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

Re: Org Value AGR table

Former Member — Tue, 17 Mar 2009 07:26:06 GMT

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)

You will get the desired output.

Regards,

Gowrinadh

Re: Org Value AGR table

Former Member — Tue, 17 Mar 2009 13:59:10 GMT

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

Re: Org Value AGR table

Former Member — Tue, 17 Mar 2009 14:35:14 GMT

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

Re: Org Value AGR table

Former Member — Tue, 17 Mar 2009 15:44:01 GMT

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!

Re: Org Value AGR table

Former Member — Thu, 19 Mar 2009 14:38:57 GMT

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)

Regards,

Gowrinadh