SAP 权限控制 mm01/2/3 会计视图成本视图账户授权

gavin_gxh

已于 2024-06-17 16:25:20 修改

阅读量552

点赞数 2

分类专栏： BASIS 文章标签：其他经验分享

于 2024-06-17 10:42:53 首次发布

gavin-gxh

本文链接：https://blog.csdn.net/xiaofei2008gxh/article/details/139737547

版权

BASIS 专栏收录该内容

138 篇文章 9 订阅

订阅专栏

1、事务代码检查 S_TCODE 权限对象字段 TCD 值包含 mm01/mm02/mm03

2、检查 M_MATE_MAT 字段 ACTVT 03 并且字段 BEGRU B / G

SELECT DISTINCT  a.* FROM  ( SELECT DISTINCT 
    agr_users.uname 
    FROM agr_1251
    INNER JOIN agr_users ON agr_1251.agr_name = agr_users.agr_name AND agr_1251.MANDT  = agr_users.MANDT 
    JOIN usrefus ON usrefus.bname = agr_users.uname AND usrefus.MANDT  = agr_users.MANDT 
    WHERE agr_1251.agr_name LIKE 'Z%' AND agr_1251.deleted <> 'X' AND  agr_users.MANDT  = '800' and
     	agr_1251.OBJECT = 'M_MATE_STA' AND agr_1251.field = 'ACTVT' AND agr_1251.low IN ('03','*')
	UNION ALL 
	SELECT  DISTINCT 
     agr_users.uname
    FROM agr_1251
   INNER JOIN agr_users ON agr_1251.agr_name = agr_users.agr_name AND agr_1251.MANDT  = agr_users.MANDT 
    JOIN usrefus ON usrefus.bname = agr_users.uname AND usrefus.MANDT  = agr_users.MANDT 
    WHERE agr_1251.agr_name LIKE 'Z%' AND agr_1251.deleted <> 'X' AND  agr_users.MANDT  = '800' AND 
     	agr_1251.OBJECT = 'M_MATE_STA' AND agr_1251.field = 'STATM' AND agr_1251.low in ('B','G','*')
    UNION ALL 
	SELECT  DISTINCT 
     agr_users.uname
    FROM agr_1251
   INNER JOIN agr_users ON agr_1251.agr_name = agr_users.agr_name AND agr_1251.MANDT  = agr_users.MANDT 
    JOIN usrefus ON usrefus.bname = agr_users.uname AND usrefus.MANDT  = agr_users.MANDT 
    WHERE agr_1251.agr_name LIKE 'Z%' AND agr_1251.deleted <> 'X' AND  agr_users.MANDT  = '800' AND 
     	agr_1251.OBJECT = 'S_TCODE' AND agr_1251.field = 'TCD' AND agr_1251.low in ('MM01','MM02','MM03')
     	) a GROUP BY a.uname HAVING  count(*) = 3
     	ORDER BY a.uname