AGR_USERS_USREFUS

CDS View

User-Role Assignment for ref. User

AGR_USERS_USREFUS is a CDS View in S/4HANA. User-Role Assignment for ref. User. It contains 3 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
Pfcg_Role_To_User view union Assigmnt:PFCGRoleName-User(incl.RefUser)

Fields (3)

KeyField CDS FieldsUsed in Views
KEY role_name role_name 1
KEY valid_from valid_from 1
KEY valid_to valid_to 1

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.

-- User-Role Assignment for ref. User
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AGR_USERS_USREFUS (
    ROLE_NAME,
    VALID_FROM,
    VALID_TO,
    PRIMARY KEY (ROLE_NAME, VALID_FROM, VALID_TO)
);