AGR_DEFINE

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

Definition Rollen

AGR_DEFINE is an SAP database table in S/4HANA. Definition Rollen. It contains 12 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
aps_iam_vbca_ddl view inner Business Catalog (Assignable)
aps_iam_vbcc_ddl view inner Business Catalog (Common)
aps_iam_vbcr_ddl view inner Business Catalog (Restrictable)
aps_iam_vbuc_ddl view inner Business Catalog
aps_iam_vrbuc_ddl view inner Restricted Business Catalog
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.

-- Definition Rollen
-- 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