SWW_WI2OBJ
Workflow Runtime: Relation of Work Item to Object
SWW_WI2OBJ is an SAP database table in S/4HANA. Workflow Runtime: Relation of Work Item to Object. It contains 16 fields. 9 CDS views read from this table.
CDS Views using this table (9)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BankAccSentItems | view_entity | inner | BASIC | Bank Account Sent Items |
| I_DocLatestWorkflow | view | inner | BASIC | one document to latest workflow |
| I_WorkflowTaskApplObject | view | from | BASIC | Application object of work items |
| P_DOCLATESTWORKFLOW | view | inner | BASIC | one document to latest workflow |
| P_Facvd_Ver_Diag_Max_Timestamp | view | inner | BASIC | Workflow Latest Dialog timestamp |
| P_FACVD_WF_STATUS_MAX_TS | view | inner | BASIC | max timestamp of workflow |
| P_Facvd_Wf_Task_Max_Timestamp | view | inner | BASIC | max timestamp of workflow |
| P_WorkflowToObject | view | from | BASIC | Workflow to Object Private |
| P_WorkflowVerifyDialogItem | view | inner | BASIC | Workflow Verify Dialog Item |
Fields (16)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | mandt | Client | |||
| KEY | guid | guid_16 | GUID 16 | |||
| wi_id | sww_wiid | Work Item ID | ||||
| top_wi_id | swfrtwiid | Top Level Workflow | ||||
| wi_rh_task | sww_task | Task | ||||
| wi_release | sysaprl | SAP Release | ||||
| crea_tmp | abp_creation_tstmpl | Created On | ||||
| catid | sibfcatid | Object Category | ||||
| instid | sibfboriid | Instance ID | ||||
| typeid | sibftypeid | Object Type | ||||
| wi_reltype | sww_reltyp | Type of Relation | ||||
| removed | sww_relrmv | Relation Deleted | ||||
| local_created_by | abp_creation_user | Created By | ||||
| local_last_changed_by | abp_locinst_lastchange_user | Changed By | ||||
| local_last_changed_at | abp_locinst_lastchange_tstmpl | Changed On | ||||
| last_changed_at | abp_lastchange_tstmpl | Changed On |
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: Relation of Work Item to Object
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SWW_WI2OBJ (
CLIENT, -- Client [mandt]
GUID, -- GUID 16 [guid_16]
WI_ID, -- Work Item ID [sww_wiid]
TOP_WI_ID, -- Top Level Workflow [swfrtwiid]
WI_RH_TASK, -- Task [sww_task]
WI_RELEASE, -- SAP Release [sysaprl]
CREA_TMP, -- Created On [abp_creation_tstmpl]
CATID, -- Object Category [sibfcatid]
INSTID, -- Instance ID [sibfboriid]
TYPEID, -- Object Type [sibftypeid]
WI_RELTYPE, -- Type of Relation [sww_reltyp]
REMOVED, -- Relation Deleted [sww_relrmv]
LOCAL_CREATED_BY, -- Created By [abp_creation_user]
LOCAL_LAST_CHANGED_BY, -- Changed By [abp_locinst_lastchange_user]
LOCAL_LAST_CHANGED_AT, -- Changed On [abp_locinst_lastchange_tstmpl]
LAST_CHANGED_AT, -- Changed On [abp_lastchange_tstmpl]
PRIMARY KEY (CLIENT, GUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA