AGR_DEFINE

Transparent Table Control Table (SAP+Cust)
12 Fields 6 CDS Views

Role definition

AGR_DEFINE is an SAP database table in S/4HANA. Role definition. It contains 12 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
P_PFCG_ROLE_DEFINITION view_entity from Role definition
P_UserRoles view_entity left_outer User role assignments
SUIM_ACGR_SUPO_INFO_X view_entity from SUIM | help view for view entity SUIM_ACHR_SUPO_INFO
SUIM_AGR_HEADER view_entity from Role Header Data for List Output
SUIM_AGR_TITLE view_entity from SUIM|Role Title with Language Fallback
suim_get_cr_agr_attrib view_entity from SUIM|Role Attr. for Crit.-Auth.

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt SYMANDT Client ID
KEY agr_name AGR_NAME Role
parent_agr PAR_AGR Role
create_usr SYUNAME User Name
create_dat MENU_DATE Date
create_tim MENU_TIME Time
create_tmp RSTIMESTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
change_usr SYUNAME User Name
change_dat MENU_DATE Date
change_tim MENU_TIME Time
change_tmp RSTIMESTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
attributes MENU_ATTR Attributes

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.

-- Role definition
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AGR_DEFINE (
    MANDT,       -- Client ID [SYMANDT]
    AGR_NAME,    -- Role [AGR_NAME]
    PARENT_AGR,  -- Role [PAR_AGR]
    CREATE_USR,  -- User Name [SYUNAME]
    CREATE_DAT,  -- Date [MENU_DATE]
    CREATE_TIM,  -- Time [MENU_TIME]
    CREATE_TMP,  -- UTC Time Stamp in Short Form (YYYYMMDDhhmmss) [RSTIMESTMP]
    CHANGE_USR,  -- User Name [SYUNAME]
    CHANGE_DAT,  -- Date [MENU_DATE]
    CHANGE_TIM,  -- Time [MENU_TIME]
    CHANGE_TMP,  -- UTC Time Stamp in Short Form (YYYYMMDDhhmmss) [RSTIMESTMP]
    ATTRIBUTES,  -- Attributes [MENU_ATTR]
    PRIMARY KEY (MANDT, AGR_NAME)
);

Learn More