/dmbe/I_User_Roles

Assignment of roles to users | view: /DMBE/USERROLES | Extraction: Not supported | Component: Commodity Management – Deal Capture
Tables used: AGR_USERS
Column Name Description
agr_name FK Role Name
uname FK User Name in User Master Record
from_dat Date of validity
to_dat Date of validity
Column Name Description
Column Name Description
Column Name Description
from_dat Date of validity
to_dat Date of validity
change_dat Date of menu generation
change_tim Time when the menu was generated last
Column Name Description
col_flag Flag: Assignment from composite role Show values
Column Name Description Domain name
exclude Exclusive CHAR1
change_tst UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
org_flag Flag: Assignment Comes From HR Organization Management CHAR1
Master Data Relations Join Conditions
Role Name
  • Role Name
  • ?
  • /DMBE/I_USER_ROLES.AGR_NAME == AGR_DEFINE.AGR_NAME
  • /DMBE/I_USER_ROLES.[column in domain "SYMANDT"] == AGR_DEFINE.MANDT
User Name in User Master Record
  • Client
  • User Name in User Master Record
  • /DMBE/I_USER_ROLES.MANDT == USR02.MANDT
  • /DMBE/I_USER_ROLES.UNAME == USR02.BNAME