SAP 定价 VK11/VK12/VK13 ME11/ME12/ME13权限控制及授权账户

最新推荐文章于 2024-12-17 02:19:49 发布

gavin_gxh

最新推荐文章于 2024-12-17 02:19:49 发布

阅读量657

点赞数 5

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

gavin-gxh

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

版权

BASIS 专栏收录该内容

138 篇文章 9 订阅

订阅专栏

1、事务代码 VK11/VK12/VK13 ME11/ME12/ME13

2、权限对象 V_KONH_VKS ACTVT 03

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 = 'V_KONH_VKS' AND agr_1251.field = 'ACTVT' AND agr_1251.low IN ('01','02','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 = 'S_TCODE' AND agr_1251.field = 'TCD' AND agr_1251.low in ('VK11','VK12','VK13','ME11','ME12','ME13','ZVK13','ZSD013')
     	) a GROUP BY a.uname HAVING  count(*) = 2
     	ORDER BY a.uname