04-27-2010 11:58 AM
Hi All,
I want to pull out all plants maintained in composite roles.Is there any tableu2019s do we have to pull out this report?
If not please help me to find all plants which is maintained in single roles which are inside the composite roles.
Thanks in advance
04-27-2010 12:14 PM
Hi Santhos,
You cannot get the data for composite role 1st of all...You have to go by all single role present in a composite role. In table agr_1252 give all the single role in field AGR_NAME and in field VARBL give $WERKS then execute
Arpan
04-27-2010 12:14 PM
Hi Santhos,
You cannot get the data for composite role 1st of all...You have to go by all single role present in a composite role. In table agr_1252 give all the single role in field AGR_NAME and in field VARBL give $WERKS then execute
Arpan
04-27-2010 6:55 PM
Check out the following tables.
AGR_1251 : For Roles/AuthObjects with $ORG_FIELD
AGR_1252 : For Org Values
AGR_DEFINE : Role Name/Desc
AGR_AGRS : Single Roles Within Composite Roles
Thanks.
Matt