SWW_USRATT

Transparent Table Application Table
18 Fields 2 CDS Views

Workflow Runtime: User Attributes

SWW_USRATT is an SAP database table in S/4HANA. Workflow Runtime: User Attributes. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_WorkflowTaskCustomAttribute view from BASIC Workflow Task Custom Attribute
SWW_SDDL_SWW_USRATT view from Workflow: Work item custom values

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY guid GUID_16 GUID 16
wi_id SWW_WIID Work Item ID
scenario TEXT20 Description
attribute_name SWC_ELEM Element
tab_index abap.int2
type SWC_TYPE ABAP type
value_field abap.char
value_c abap.strg
value_i abap.int4
value_d abap.d34d
unit MSEH6 Technical
top_task SWW_TASK Task
wi_stat SWW_WISTAT Status
pfe_index abap.int2
def_task SWW_TASK Task
def_nodeid SWD_NODEID Workflow Step
last_change SWFUTLCREATST Created At

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.

-- Workflow Runtime: User Attributes
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SWW_USRATT (
    CLIENT,          -- Client [MANDT]
    GUID,            -- GUID 16 [GUID_16]
    WI_ID,           -- Work Item ID [SWW_WIID]
    SCENARIO,        -- Description [TEXT20]
    ATTRIBUTE_NAME,  -- Element [SWC_ELEM]
    TAB_INDEX,       -- abap.int2
    TYPE,            -- ABAP type [SWC_TYPE]
    VALUE_FIELD,     -- abap.char
    VALUE_C,         -- abap.strg
    VALUE_I,         -- abap.int4
    VALUE_D,         -- abap.d34d
    UNIT,            -- Technical [MSEH6]
    TOP_TASK,        -- Task [SWW_TASK]
    WI_STAT,         -- Status [SWW_WISTAT]
    PFE_INDEX,       -- abap.int2
    DEF_TASK,        -- Task [SWW_TASK]
    DEF_NODEID,      -- Workflow Step [SWD_NODEID]
    LAST_CHANGE,     -- Created At [SWFUTLCREATST]
    PRIMARY KEY (CLIENT, GUID)
);

Learn More