AGR_USERS

Transparent Table Customizing Table
11 Fields 19 CDS Views

Assignment of roles to users

AGR_USERS is an SAP database table in S/4HANA. Assignment of roles to users. It contains 11 fields. 19 CDS views read from this table.

CDS Views using this table (19)

ViewTypeJoinVDMDescription
/AGIL/LUR_I_RoleNumberOfUsers view from Number of Users in Role
/AGIL/LUR_I_RoleUserObjAccess view inner Role/User Auth Object Access
/dmbe/I_User_Roles view from Assignment of roles to users
Agr_Users_Usrefus view inner User-Role Assignment for ref. User
C_SuplrActyPotntlEmplRespVH view inner CONSUMPTION Potential resp.employees for an activity
FCLM_BAM_SHLP_REVIEWER view left_outer Search help for reviewer
I_ACMRoleAssignmentForUser view from BASIC Interface layer for role assigned to the user
I_PPM_AuthznByUserRoleH view inner BASIC Project Authorizations by User Role
P_PPM_AuthorizationByUserRole view inner BASIC
P_PPM_LocalAuthorizations view inner BASIC
P_USER_ROLE view inner Get roles for users with reference user
P_UserRoles view_entity from User role assignments
P_USR_AUTH_ROLE view inner User with Roles or Authorizations
Pfcg_Role_To_User view from Assigmnt:PFCGRoleName-User(incl.RefUser)
SUIM_ACGR_SUPO_INFO_X view_entity left_outer SUIM | help view for view entity SUIM_ACHR_SUPO_INFO
SUIM_AGR_USR_CNT view_entity from SUIM | Count of Assigned Users per Role
SUIM_AGR_VALID_USER_CNT view_entity from SUIM | Count of valid user in role
SUIM_AGR_WITH_TCD view from SUIM - Get (assigned) roles with tcode
SUIM_PFCG_HEAD_WUSR view_entity inner SUIM | Role Header with Assigned User

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt SYMANDT Client ID
KEY agr_name AGR_NAME Role
KEY uname XUBNAME User
KEY from_dat AGR_FDATE Start date
KEY to_dat AGR_TDATE End date
exclude AGR_EXCL Exclusive
change_dat MENU_DATE Date
change_tim MENU_TIME Time
change_tst RSTIMESTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
org_flag AGR_ORG HR Org Mgt
col_flag AGR_COL Assgmt Comes From Composite Role

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Assignment of roles to users
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AGR_USERS (
    MANDT,       -- Client ID [SYMANDT]
    AGR_NAME,    -- Role [AGR_NAME]
    UNAME,       -- User [XUBNAME]
    FROM_DAT,    -- Start date [AGR_FDATE]
    TO_DAT,      -- End date [AGR_TDATE]
    EXCLUDE,     -- Exclusive [AGR_EXCL]
    CHANGE_DAT,  -- Date [MENU_DATE]
    CHANGE_TIM,  -- Time [MENU_TIME]
    CHANGE_TST,  -- UTC Time Stamp in Short Form (YYYYMMDDhhmmss) [RSTIMESTMP]
    ORG_FLAG,    -- HR Org Mgt [AGR_ORG]
    COL_FLAG,    -- Assgmt Comes From Composite Role [AGR_COL]
    PRIMARY KEY (MANDT, AGR_NAME, UNAME, FROM_DAT, TO_DAT)
);

Learn More