topic Inactive Profiles in Object - Table/Fields in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/inactive-profiles-in-object-table-fields/m-p/5376594#M1236722 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you help please?</P><P></P><P>I am trying to list all the Authorisation objects that have got an activity field of 01 or 02 for a specific role.</P><P></P><P>I have pulled the following report which is fine.</P><P>Some of the objects have got more than one profile set up and some are set to inactive.</P><P>I would like to find the table and field I need to use to exclude the inactive profiles.</P><P></P><P>Any idea what the table I need to use is?</P><P></P><P>Thank you</P><P></P><P>Coco</P><P></P><P>SELECT </P><P> AGR_AGRS.MANDT AS [Client],</P><P> AGR_DEFINE.MANDT AS [Client 1],</P><P> AGR_1251.MANDT AS [Client 2],</P><P> AGR_AGRS.AGR_NAME AS [Composite Role],</P><P> AGR_AGRS.CHILD_AGR AS [Single Role],</P><P> AGR_DEFINE.PARENT_AGR AS [Parent Role], </P><P> AGR_1251.AGR_NAME, </P><P> AGR_1251.AUTH, </P><P> AGR_1251.OBJECT, </P><P> AGR_1251.FIELD, </P><P> AGR_1251.LOW, </P><P> AGR_1251.HIGH</P><P>FROM tst.AGR_AGRS</P><P> LEFT JOIN tst.AGR_DEFINE </P><P> ON tst.AGR_AGRS.CHILD_AGR = tst.AGR_DEFINE.AGR_NAME </P><P> AND tst.AGR_AGRS.MANDT = tst.AGR_DEFINE.MANDT </P><P> LEFT JOIN tst.AGR_1251</P><P> ON tst.AGR_AGRS.CHILD_AGR = tst.AGR_1251.AGR_NAME</P><P> AND tst.AGR_AGRS.MANDT = tst.AGR_1251.MANDT</P><P>WHERE </P><P> tst.AGR_AGRS.MANDT = 150 </P><P> AND (tst.AGR_AGRS.AGR_NAME LIKE 'JB%')</P><P> AND (tst.AGR_DEFINE.AGR_NAME LIKE 'PR%' </P><P> OR tst.AGR_DEFINE.AGR_NAME LIKE 'PX%')</P><P> --AND tst.AGR_AGRS.AGR_NAME LIKE 'JB:%'</P><P> AND tst.AGR_AGRS.AGR_NAME LIKE 'JB:AA:ABSOFT_DISPLAYFC:ALLXXXX'</P><P> --AND OBJECT IN ('M_MRES_BWA','M_MSEG_BMB','M_MSEG_BWA','M_MSEG_BWE','M_MSEG_BWF','M_MSEG_LGO')</P><P> AND FIELD = 'ACTVT' AND (LOW IN ('<STRONG>','01','02') OR HIGH IN ('</STRONG>','01','02'))</P><P></P><P>ORDER BY </P><P> tst.AGR_AGRS.AGR_NAME ASC, </P><P> tst.AGR_AGRS.CHILD_AGR ASC,</P><P> OBJECT ASC,</P><P> FIELD ASC</P></BODY></HTML> Mon, 23 Mar 2009 13:36:31 GMT corinne_lofts 2009-03-23T13:36:31Z Inactive Profiles in Object - Table/Fields https://community.sap.com/t5/application-development-and-automation-discussions/inactive-profiles-in-object-table-fields/m-p/5376594#M1236722 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you help please?</P><P></P><P>I am trying to list all the Authorisation objects that have got an activity field of 01 or 02 for a specific role.</P><P></P><P>I have pulled the following report which is fine.</P><P>Some of the objects have got more than one profile set up and some are set to inactive.</P><P>I would like to find the table and field I need to use to exclude the inactive profiles.</P><P></P><P>Any idea what the table I need to use is?</P><P></P><P>Thank you</P><P></P><P>Coco</P><P></P><P>SELECT </P><P> AGR_AGRS.MANDT AS [Client],</P><P> AGR_DEFINE.MANDT AS [Client 1],</P><P> AGR_1251.MANDT AS [Client 2],</P><P> AGR_AGRS.AGR_NAME AS [Composite Role],</P><P> AGR_AGRS.CHILD_AGR AS [Single Role],</P><P> AGR_DEFINE.PARENT_AGR AS [Parent Role], </P><P> AGR_1251.AGR_NAME, </P><P> AGR_1251.AUTH, </P><P> AGR_1251.OBJECT, </P><P> AGR_1251.FIELD, </P><P> AGR_1251.LOW, </P><P> AGR_1251.HIGH</P><P>FROM tst.AGR_AGRS</P><P> LEFT JOIN tst.AGR_DEFINE </P><P> ON tst.AGR_AGRS.CHILD_AGR = tst.AGR_DEFINE.AGR_NAME </P><P> AND tst.AGR_AGRS.MANDT = tst.AGR_DEFINE.MANDT </P><P> LEFT JOIN tst.AGR_1251</P><P> ON tst.AGR_AGRS.CHILD_AGR = tst.AGR_1251.AGR_NAME</P><P> AND tst.AGR_AGRS.MANDT = tst.AGR_1251.MANDT</P><P>WHERE </P><P> tst.AGR_AGRS.MANDT = 150 </P><P> AND (tst.AGR_AGRS.AGR_NAME LIKE 'JB%')</P><P> AND (tst.AGR_DEFINE.AGR_NAME LIKE 'PR%' </P><P> OR tst.AGR_DEFINE.AGR_NAME LIKE 'PX%')</P><P> --AND tst.AGR_AGRS.AGR_NAME LIKE 'JB:%'</P><P> AND tst.AGR_AGRS.AGR_NAME LIKE 'JB:AA:ABSOFT_DISPLAYFC:ALLXXXX'</P><P> --AND OBJECT IN ('M_MRES_BWA','M_MSEG_BMB','M_MSEG_BWA','M_MSEG_BWE','M_MSEG_BWF','M_MSEG_LGO')</P><P> AND FIELD = 'ACTVT' AND (LOW IN ('<STRONG>','01','02') OR HIGH IN ('</STRONG>','01','02'))</P><P></P><P>ORDER BY </P><P> tst.AGR_AGRS.AGR_NAME ASC, </P><P> tst.AGR_AGRS.CHILD_AGR ASC,</P><P> OBJECT ASC,</P><P> FIELD ASC</P></BODY></HTML> Mon, 23 Mar 2009 13:36:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/inactive-profiles-in-object-table-fields/m-p/5376594#M1236722 corinne_lofts 2009-03-23T13:36:31Z Re: Inactive Profiles in Object - Table/Fields https://community.sap.com/t5/application-development-and-automation-discussions/inactive-profiles-in-object-table-fields/m-p/5376595#M1236723 <HTML><HEAD></HEAD><BODY><P>AGR_1251 DELETED != "X"</P></BODY></HTML> Mon, 23 Mar 2009 13:42:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/inactive-profiles-in-object-table-fields/m-p/5376595#M1236723 jurjen_heeck 2009-03-23T13:42:38Z Re: Inactive Profiles in Object - Table/Fields https://community.sap.com/t5/application-development-and-automation-discussions/inactive-profiles-in-object-table-fields/m-p/5376596#M1236724 <HTML><HEAD></HEAD><BODY><P>Thank you</P><P></P><P>Sorted</P><P></P><P>Coco</P></BODY></HTML> Mon, 23 Mar 2009 13:48:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/inactive-profiles-in-object-table-fields/m-p/5376596#M1236724 corinne_lofts 2009-03-23T13:48:00Z