03-17-2009 2:26 AM
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
03-17-2009 7:26 AM
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
03-17-2009 1:59 PM
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
03-17-2009 3:44 PM
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!
03-19-2009 2:38 PM
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
03-17-2009 2:35 PM
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