SAPSR3.v_username.NAME_TEXT FROM (SAPSR3.AGR_TCODES INNER JOIN SAPSR3.agr_users ON SAPSR3.AGR_TCODES.AGR_NAME =SAPSR3.agr_users.AGR_NAME) INNER JOIN SAPSR3.v_username ON SAPSR3.agr_users.UNAME=v_username.BNAME where (SAPSR3.agr_users.AGR_NAME like 'Role_%' or SAPSR3.agr_users...
SAP权限查询(事务码) SELECT distinct B.AGR_NAME,B.UNAME,right(B.UNAME,6) as xuhao,A.TCODE FROM AGR_TCODES AS A INNER JOIN AGR_USERS AS B ON A.AGR_NAME = B.AGR_NAME INNER JOIN V_USERNAME AS C ON B.UNAME = C.BNAME where B.UNAME like '%***%' ORDER BY B.UNAME,A.TCODE...
AGR_TCODES and TSTCT are the important tables which are storing the details about each transation codes. There are lakhs of tcodes present in SAP and increasing day by day. In this section you can browse the transation codes by Software components & modules wise.From the transaction code ...
导出SAP系统内的用户-角色-TCode关系 SELECT SAPSR3.agr_users.AGR_NAME, SAPSR3.agr_users.UNAME, SAPSR3.AGR_TCODES.TCODE, SAPSR3.v_username.NAME_TEXTFROM (SAPSR3.AGR_TCODES INNER JOIN SAPSR3.agr_users ON SAPSR3.AGR_TCODES.AGR_NAME =SAPSR3.agr_users.AGR_NAME)INNER JOIN SAPSR3.v_...
Solved: Hi, I am analyzing a specific role which contains some transactions . When I check the table AGR_TCODES i realized that that role is not present in the table.
导出SAP系统内的用户-角色-TCode关系 博客分类: SAP basisSELECT SAPSR3.agr_users.AGR_NAME, SAPSR3.agr_users.UNAME, SAPSR3.AGR_TCODES.TCODE, SAPSR3.v_username.NAME_TEXTFROM (SAPSR3.AGR_TCODES INNER JOIN SAPSR3.agr_users ON SAPSR3.AGR_TCODES.AGR_NAME =SAPSR3.agr_users.AGR_NAME)INNER...
Solved: Hi All, I tried to find the t-codes in a given role, but the number of t-codes varied with all the three methods i.e., SUIM, AGR_1251 and agr_TCODES. I want to
***表: AGR_TCODES 角色名:AGR_NAME 事务代码:TCODE (这个表在ZBA01中使用,ZBA02中没用) *表: AGR_USERS 角色名:AGR_NAME 用户名:UNAME *表: V_USERNAME 用户名:BNAME 完整的人员名称:NAME_TEXT *表: AGR_TEXTS 角色名:AGR_NAME 角色说明:TEXT *** ...
"查找继承角色的TCODE SELECT USR02~BNAME, *AGR_USERS~AGR_NAME, AGR_TCODES~TCODE, TSTCT~TTEXT FROM USR02 LEFT JOIN AGR_USERS ON AGR_USERS~UNAME = USR02~BNAME LEFT JOIN AGR_DEFINE ON AGR_USERS~AGR_NAME = AGR_DEFINE~AGR_NAME LEFT JOIN AGR_TCODES ON AGR_DEFINE~PARENT_AGR = AGR...
SAP 用户权限设定 PFCG 如何根据T-CODE查询属于哪个ROLE(PFCG角色) 查询表AGR_TCODES,输入事务码,如下图