03-23-2009 1:36 PM
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
03-23-2009 1:42 PM
03-23-2009 1:42 PM
03-23-2009 1:48 PM