AGR_1016

Transparent Table Customizing Table
7 Fields 5 CDS Views

Current Subprofiles for Single Roles

AGR_1016 is an SAP database table in S/4HANA. Current Subprofiles for Single Roles. It contains 7 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
/dmbe/I_Activity_Group_Profile view from Name of the activity group profile
I_LogAccMActvActyGrpProfile view from BASIC Activity Group Profile
P_USR_AUTH_ROLE view inner User with Roles or Authorizations
SUIM_AGR_1016_TORSO view_entity from Get first Profile name from a PFCG-Role
SUIM_AGR_START_APPL view left_outer rest

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt SYMANDT Client ID
KEY agr_name AGR_NAME Role
KEY counter MENU_NUM_6 ID
profile AGPROFILE Profile Name
variant TPR_VARI Variant
generated GEN_FLGA Generated
pstate XUAKTPAS Version

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.

-- Current Subprofiles for Single Roles
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AGR_1016 (
    MANDT,      -- Client ID [SYMANDT]
    AGR_NAME,   -- Role [AGR_NAME]
    COUNTER,    -- ID [MENU_NUM_6]
    PROFILE,    -- Profile Name [AGPROFILE]
    VARIANT,    -- Variant [TPR_VARI]
    GENERATED,  -- Generated [GEN_FLGA]
    PSTATE,     -- Version [XUAKTPAS]
    PRIMARY KEY (MANDT, AGR_NAME, COUNTER)
);

Learn More