SAP用户权限清单 sql查询

原创已于 2023-03-07 15:04:44 修改 · 4.1k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#SAP #权限

于 2018-03-19 18:01:08 首次发布

SAP 同时被 2 个专栏收录

4 篇文章

订阅专栏

计算机

2 篇文章

订阅专栏

本文提供了一个复杂的SQL查询案例，详细展示了如何通过多个表之间的连接来获取所需的数据，并按特定字段进行排序。该查询涉及多个表如AGR_USERS、AGR_DEFINE等，并通过内连接的方式将这些表关联起来。

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

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