SAP mb51/mb52 migo 含有价格金额权限的用户

gavin_gxh

已于 2024-06-17 10:37:12 修改

阅读量699

点赞数 1

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

于 2024-06-17 10:14:56 首次发布

gavin-gxh

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

版权

BASIS 专栏收录该内容

138 篇文章 9 订阅

订阅专栏

关于价格和金额的显示，需要权限控制，当权限对象F_BKPF_BUK,检查对应【公司代码】和 ACTVT有'03’的权限，如果没有03的权限，对应行的价格和金额显示为空
关于价格和金额的显示，需要权限控制，当权限对象M_INVVAL,检查字段 ACTVT 为03 和字段DISPINVVAL 为1，若检查不通过，则金额那些列隐藏

要有对应的事务代码 mb51/mb52/migo

即权限对象 S_TCODE 检查字段 TCD 值里面又 mb51 mb52 migo

整理之后 SQL 如下

SELECT 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 = 'F_BKPF_BUK' 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_INVVAL' 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_INVVAL' AND agr_1251.field = 'DISPINVVAL' AND agr_1251.low IN ('1','*') 
     	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 ('MB51','MB52','MIGO')
     	) a GROUP BY a.uname HAVING  count(*) = 4
     	ORDER BY a.uname