SAP权限查询(事务码)
摘要:
SELECT distinct B.AGR_NAME,B.UNAME,right(B.UNAME,6) as xuhao,A.TCODEFROM AGR_TCODES AS A INNER JOIN AGR_USERS AS BON A.AGR_NAME = B.AGR_NAME INNER JOIN V_USERNAME AS CON B.UNAME = C.BNAMEwhere B.UNAME like '%***%'ORDER BY B.UNAME,A.TCODE 阅读全文
posted @ 2010-12-23 14:13 愚工养码 阅读(802) 评论(0) 推荐(0) 编辑