远行的心 发表于 2015-9-21 14:32:59

导出SAP系统内的用户-角色-TCode关系

SELECT
    SAPSR3.agr_users.AGR_NAME,
    SAPSR3.agr_users.UNAME,
    SAPSR3.AGR_TCODES.TCODE,
    SAPSR3.v_username.NAME_TEXT
FROM (SAPSR3.AGR_TCODES INNER JOIN SAPSR3.agr_users ON SAPSR3.AGR_TCODES.AGR_NAME =SAPSR3.agr_users.AGR_NAME)
INNER JOIN SAPSR3.v_username ON SAPSR3.agr_users.UNAME=v_username.BNAME
where (SAPSR3.agr_users.AGR_NAME like 'Role_%' or SAPSR3.agr_users.AGR_NAME like 'COMPROLE_%')
order by SAPSR3.agr_users.UNAME,SAPSR3.AGR_TCODES.TCODE
 ;



页: [1]
查看完整版本: 导出SAP系统内的用户-角色-TCode关系