USR05

Transparent Table Application Table
4 Fields 18 CDS Views

Benutzerstamm Parameter-ID

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

CDS Views using this table (18)

ViewTypeJoinVDMDescription
APS_COM_COMM_IBS view left_outer COM: Inbound Scenarios
APS_COM_COMM_IBS_CUST_AUX view left_outer Auxiliary Custom IBS view w/ all services
APS_COM_COMM_OBS view left_outer COM: Outbound Services
aps_com_cs_csmpt view left_outer Custom Communication Scenarios
aps_iam_app_ddl view left_outer Applications
APS_IAM_DPP view left_outer Display Publishing Processes
ATOV_USER_ASSIGNMENT view from ATO: User Assignment
I_APS_COM_CS_CSMPT_D view_entity left_outer Custom Communication Scenarios
I_EAMUserParameter view_entity from BASIC User Parameter
I_UserParameter_F2200 view from BASIC User Parameter
I_UserSettingsForDeprArea view inner BASIC Depreciation Area User Default Value
P_MyEHSLocationUser05 view_entity from BASIC My Location (as Character 32)
P_UserParameter view from BASIC User Parameter
P_UserParameterBname view from BASIC User Parameter with Bname
P_Usersetgetparamforctrlgarea view left_outer BASIC User Set Get Parameter for Controlling Area
P_UserSettingsForCompanyCode view inner BASIC P_UserSettingsForCompanyCode
P_UserSettingsForDeprArea view inner BASIC P_UserSettingsForDeprArea
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