P_USER_ROLE

Get Roles for Users with Reference User | view: PUSERROLE | Extraction: Not supported | Component: User and Authorization Management
Tables used: AGR_TEXTSAGR_USERSUSR02USREFUS
Column Name Description
bname User Name in User Master Record
Column Name Description
Column Name Description
Column Name Description
from_dat Date of validity
to_dat Date of validity
Column Name Description
col_flag Flag: Assignment from composite role Show values
Column Name Description Domain name
refuser null
org_flag Flag: Assignment Comes From HR Organization Management CHAR1
text Role Description TEXT80
Master Data Relations Join Conditions
Role Name
  • ?
  • Role Name
  • P_USER_ROLE.[column in domain "SYMANDT"] == AGR_DEFINE.MANDT
  • P_USER_ROLE.AGR_NAME == AGR_DEFINE.AGR_NAME
User group
  • Client
  • User group in user master maintenance
  • P_USER_ROLE.MANDT == USGRP.MANDT
  • P_USER_ROLE.CLASS == USGRP.USERGROUP