SWWUSERWI

Transparent Table Application Table
7 Fields 9 CDS Views

Aktuelle Workitems eines Benutzers

SWWUSERWI is an SAP database table in S/4HANA. Aktuelle Workitems eines Benutzers. 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.

-- Aktuelle Workitems eines Benutzers
-- 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