SAP用户权限清单 sql查询

select a~BNAME a~NAME_TEXT  b~agr_name f~TEXT y~tcode d~TTEXT tt~OBJCT tt~FIELD TT~VALUE
from v_username as a 
inner join AGR_USERS  as b  on a~bname = b~UNAME
inner join agr_define as x  on b~agr_name = x~agr_name
inner join agr_tcodes as y on x~parent_agr = y~agr_name 
inner join tstct as d  on y~TCODE = d~TCODE
inner join USR02 as e on a~BNAME = e~BNAME 
inner join AGR_TEXTS as f on x~AGR_NAME = f~AGR_NAME 
inner join TSTCA as tt on d~tcode = tt~tcode
where  a~MANDT = '500'   and e~UFLAG = 0  and  f~SPRAS = '1'  and d~SPRSL = '1'   

order by a~bname

还没入门的basis 

如有不对之处，请指出。谢谢