USR05

Transparent Table Application Table
4 Fields 12 CDS Views

User Master Parameter ID

USR05 is an SAP database table in S/4HANA. User Master Parameter ID. It contains 4 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
APS_IAM_DPP view left_outer Display Publishing Processes
ATOV_USER_ASSIGNMENT view from ATO: User Assignment
I_EAMUserParameter view from BASIC User Parameter
I_TimeEntryUserParameter view_entity from HCM Timesheet User Parameter
I_UserParameter_F2200 view from BASIC User Parameter
P_MyEHSLocationUser05 view_entity 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.

-- User Master 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