Inactive Profiles in Object - Table/Fields

[corinne_lofts]

Hi,

Can you help please?

I am trying to list all the Authorisation objects that have got an activity field of 01 or 02 for a specific role.

I have pulled the following report which is fine.

Some of the objects have got more than one profile set up and some are set to inactive.

I would like to find the table and field I need to use to exclude the inactive profiles.

Any idea what the table I need to use is?

Thank you

Coco

SELECT

AGR_AGRS.MANDT AS [Client],

AGR_DEFINE.MANDT AS [Client 1],

AGR_1251.MANDT AS [Client 2],

AGR_AGRS.AGR_NAME AS [Composite Role],

AGR_AGRS.CHILD_AGR AS [Single Role],

AGR_DEFINE.PARENT_AGR AS [Parent Role],

AGR_1251.AGR_NAME,

AGR_1251.AUTH,

AGR_1251.OBJECT,

AGR_1251.FIELD,

AGR_1251.LOW,

AGR_1251.HIGH

FROM tst.AGR_AGRS

LEFT JOIN tst.AGR_DEFINE

ON tst.AGR_AGRS.CHILD_AGR = tst.AGR_DEFINE.AGR_NAME

AND tst.AGR_AGRS.MANDT = tst.AGR_DEFINE.MANDT

LEFT JOIN tst.AGR_1251

ON tst.AGR_AGRS.CHILD_AGR = tst.AGR_1251.AGR_NAME

AND tst.AGR_AGRS.MANDT = tst.AGR_1251.MANDT

WHERE

tst.AGR_AGRS.MANDT = 150

AND (tst.AGR_AGRS.AGR_NAME LIKE 'JB%')

AND (tst.AGR_DEFINE.AGR_NAME LIKE 'PR%'

OR tst.AGR_DEFINE.AGR_NAME LIKE 'PX%')

--AND tst.AGR_AGRS.AGR_NAME LIKE 'JB:%'

AND tst.AGR_AGRS.AGR_NAME LIKE 'JB:AA:ABSOFT_DISPLAYFC:ALLXXXX'

--AND OBJECT IN ('M_MRES_BWA','M_MSEG_BMB','M_MSEG_BWA','M_MSEG_BWE','M_MSEG_BWF','M_MSEG_LGO')

AND FIELD = 'ACTVT' AND (LOW IN ('','01','02') OR HIGH IN ('','01','02'))

ORDER BY

tst.AGR_AGRS.AGR_NAME ASC,

tst.AGR_AGRS.CHILD_AGR ASC,

OBJECT ASC,

FIELD ASC

[jurjen_heeck]

AGR_1251 DELETED != "X"

[corinne_lofts]

Thank you

Sorted

Coco