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 ...
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...
"查找继承角色的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系统内的用户-角色-TCode关系 SELECT SAPSR3.agr_users.AGR_NAME, SAPSR3.agr_users.UNAME, SAPSR3.AGR_TCODES.TCODE, 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_u...
计划生产: 其它: USER_ADDR-系统用户信息表 AGR_TEXTS-权限角色描述表 AGR_TCODES-权限角色事务码信息表 AGR_1251-权限角色组织级别数据 AGR_1252-权限角色 AGR_DEFINE-子、父角色关联关系表 AGR_USERS-角色、用户对应关系表 USGRP_USER-用户用户组对应关系表 USR41-当前在线用户 TSTC-事务码描述表编辑...
导出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...
SAP中有关角色和权限的重要数据库表 1. AGR_USERS 角色与用户对应关系2. AGR_TEXTS 角色的中文描述3. AGR_TCODES 查询角色所有的T-code, 报表类型 = TR4. 用户信息USER_ADDR5. AGR_1251 查询角色所有的T-code ,角色对象 = S_TCODE6. USR02 查看哪些用户被锁定(UFLAG) ...
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.
***表: AGR_TCODES 角色名:AGR_NAME 事务代码:TCODE (这个表在ZBA01中使用,ZBA02中没用) *表: AGR_USERS 角色名:AGR_NAME 用户名:UNAME *表: V_USERNAME 用户名:BNAME 完整的人员名称:NAME_TEXT *表: AGR_TEXTS 角色名:AGR_NAME 角色说明:TEXT *** ...
"abap_table_selector": { "agr_tcodes_full": "False", "usr01_full": "False", "usr02_full": "False", "usr02_incremental": "False", "agr_1251_full": "False", "agr_users_full": "False", "agr_users_incremental": "False", "agr_prof_full": "False", "ust04_full": "False...