USR05

Transparent Table Application Table
4 Fields 10 CDS Views

Benutzerstamm Parameter-ID

USR05 is an SAP database table in S/4HANA. Benutzerstamm Parameter-ID. It contains 4 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
ATOV_USER_ASSIGNMENT view from ATO: User Assignment
I_EAMUserParameter view from BASIC User Parameter
I_UserParameter_F2200 view from BASIC User Parameter
P_MyEHSLocationChar32 view from BASIC
P_UserParameter view from BASIC
P_UserParameterBname view from BASIC
P_Usersetgetparamforctrlgarea view left_outer BASIC
P_UserSettingsForCompanyCode view inner BASIC
P_UserSettingsForDeprArea view inner BASIC
R_CashPositionUserSetting view_entity from BASIC User Settings for Cash Position

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bname xubname User
KEY parid memoryid Parameter ID
parva xuvalue Parameter value

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.

-- Benutzerstamm Parameter-ID
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE USR05 (
    MANDT,  -- Client [mandt]
    BNAME,  -- User [xubname]
    PARID,  -- Parameter ID [memoryid]
    PARVA,  -- Parameter value [xuvalue]
    PRIMARY KEY (MANDT, BNAME, PARID)
);

Learn More