SWWUSERWI

Transparent Table Application Table
7 Fields 9 CDS Views

Current Work Items Assigned to a User

SWWUSERWI is an SAP database table in S/4HANA. Current Work Items Assigned to a User. It contains 7 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_MyChemicalApprovalRole view left_outer COMPOSITE Chemical Approval Role
I_SWI_WIIinvUsers view_entity from Work Items with Invalid Users
I_SWI_WIIinvUsers view_entity union Work Items with Invalid Users
I_WORKFLOWCLOUDREP_NRTASKSUSER view from Retrieves the number of direct assigned tasks per user
I_WorkflowTaskRecipient view inner BASIC Work item recipients
I_WorkflowUserWorkItem view from BASIC User Work Item
P_MyChemicalApprovals view left_outer COMPOSITE
P_UserWorkItems view from BASIC
P_WorkflowUserWorkItems view from BASIC

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY user_id XUBNAME User
KEY wi_id SWW_WIID Work Item ID
task_obj OTJID Obj.type/obj.ID
no_sel HR_NO_SEL Not relevant
no_execute WI_NO_EXEC No execution
forward HR_FORWARD Forwarded

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 Work Items Assigned to a User
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SWWUSERWI (
    MANDT,       -- Client [MANDT]
    USER_ID,     -- User [XUBNAME]
    WI_ID,       -- Work Item ID [SWW_WIID]
    TASK_OBJ,    -- Obj.type/obj.ID [OTJID]
    NO_SEL,      -- Not relevant [HR_NO_SEL]
    NO_EXECUTE,  -- No execution [WI_NO_EXEC]
    FORWARD,     -- Forwarded [HR_FORWARD]
    PRIMARY KEY (MANDT, USER_ID, WI_ID)
);

Learn More