本文介绍了一段SQL查询代码，用于从SAP系统中获取特定名称模式的角色及其相关的交易代码(TCODE)。通过内连接将角色表与用户表及用户名表关联起来，并筛选出名称以'Role_'或'COMPROLE_'开头的角色。最后按用户名和交易代码进行排序。
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
;
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
;
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
