SAP role menu

roledeki menuleri bulma;
select * from(
select t1.mandt, t1.agr_name,t1.parent_id,t1.object_id,t1.report ,t2.text,menu_level
from AGR_HIER t1, agr_hiert t2
where
t1.mandt=t2.mandt and t1.mandt='3'
and t1.object_id=t2.object_id
and t2.spras='T'
and t1.agr_name=t2.agr_name and t1.agr_name like 'Z_%' and
t1.agr_name not like 'ZALL%' and t1.agr_name not like'Z%'
--and report='MM03'
order by agr_name, parent_id , object_id) A1

group by parent_id


and parent_id=1
order by object_id
--and spras='T'

----------------------------------------
---------------------------------------------------
select * from(
select t1.mandt, t1.agr_name,t1.parent_id,t1.object_id,t1.report ,t2.text,menu_level
from AGR_HIER t1, agr_hiert t2
where
t1.mandt=t2.mandt and t1.mandt='300'
and t1.object_id=t2.object_id
--and t2.spras='T'
and t1.agr_name=t2.agr_name and t1.agr_name like 'Z:1000_%' and t1.agr_name like 'Z:1000_ELT%' and
t1.agr_name not like 'Z:1000_ALL%' and t1.agr_name not like'Z:1000%'
--and report='MM03'
order by agr_name, parent_id , object_id) A1 ,(select agr_name,object_id,text from AGR_HIERt
where mandt='700'
and agr_name like 'Z:%'
order by object_id) A2
--------------------------------------
SELECT agr_hier.agr_name, agr_hier.object_id, agr_hier.parent_id, agr_hier.sort_order,
agr_hier.menu_level, agr_hier.menu_level, agr_hier.report, agr_hiert.text
FROM agr_hier
INNER JOIN agr_hiert
ON agr_hier.agr_name = agr_hiert.agr_name
AND agr_hier.object_id = agr_hiert.object_id
WHERE agr_hier.agr_name = agr_hiert.agr_name
AND agr_hier.report IN ('_APPATION' , 'APPION22' )
-------------------------------------------

https://wiki.sdn.sap.com/wiki/display/ABAP/Useful+SAP+System+Administration+Transactions
http://help.sap.com/saphelp_nw70/helpdata/EN/44/d8120bdaba5705e10000000a1553f6/frameset.htm
http://wiki.sdn.sap.com/wiki/display/Security/Collection+of+SAP+Security+Tables
http://soumen.wordpress.com/performance-tuning-of-sap-another-experiance/5-st02-another-magic-transaction-for-sap-tuners-ii/

where A1.parent_id=A2.object_id
order by A2.TEXT

select agr_name,object_id,text from AGR_HIERt
where mandt='700'
and agr_name like 'Z:%'
order by object_id
-------------------------------------------