SAP 采购订单价格条件权限控制授权账户

最新推荐文章于 2024-10-23 15:01:50 发布

gavin_gxh

最新推荐文章于 2024-10-23 15:01:50 发布

阅读量543

点赞数 4

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

gavin-gxh

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

版权

BASIS 专栏收录该内容

153 篇文章

订阅专栏

采购订单价格条件权限控制授权账户

1、事务代码 me21/22/23/N

2、权限对像如下几个 M_BEST_BSA/EKG/EKO/WRK ACTVT 09

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_BEST_EKG' AND agr_1251.field = 'ACTVT' AND agr_1251.low IN ('09','*')
	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_BEST_BSA' AND agr_1251.field = 'ACTVT' AND agr_1251.low IN ('09','*')
	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_BEST_WRK' AND agr_1251.field = 'ACTVT' AND agr_1251.low IN ('09','*')
    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_BEST_EKO' AND agr_1251.field = 'ACTVT' AND agr_1251.low IN ('09','*')
    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 ('ME21','ME21N','ME22','ME22N','ME23','ME23N')
     	) a GROUP BY a.uname HAVING  count(*) = 5
     	ORDER BY a.uname