SWIWIOBJCT
Generated Table for View
SWIWIOBJCT is an SAP database table in S/4HANA. Generated Table for View. It contains 54 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_AbpUserBatch | view | inner | BASIC | ABP - User Payment Batch |
Fields (54)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | objtype | SWO_OBJTYP | Object Type | |||
| KEY | objkey | SWO_TYPEID | Key | |||
| KEY | wi_id | SWW_WIID | Work Item ID | |||
| KEY | wi_type | SWW_WITYPE | Type | |||
| KEY | wi_creator | SWW_OBJID | Creator | |||
| KEY | wi_lang | SWW_LANG | Language | |||
| KEY | wi_text | SWW_WITEXT | Work item text | |||
| KEY | wi_rhtext | SWW_RHTEXT | Task text | |||
| KEY | wi_stat | SWW_WISTAT | Status | |||
| KEY | wi_cd | SWW_CD | Creation Date | |||
| KEY | wi_ct | SWW_CT | Creation Time | |||
| KEY | wi_aagent | SWW_AAGENT | Agent | |||
| KEY | wi_chckwi | SWW_CHCKWI | Workflow | |||
| KEY | wi_rh_task | SWW_TASK | Task | |||
| KEY | wi_prio | SWW_PRIO | Priority | |||
| KEY | wi_confirm | SWW_WICONF | Confirm | |||
| KEY | wi_forw_by | SWW_FORWBY | Forwarder | |||
| KEY | wi_disable | SWW_DISABL | Lock flag | |||
| KEY | wi_reject | SWW_REJECT | Rejectable | |||
| KEY | tclass | HR_TASK_CL | Classification | |||
| KEY | note_exist | SWW_NOTEEX | Attachments | |||
| KEY | wi_dh_stat | SWW_WIDHST | Deadline Status | |||
| KEY | wi_release | SYSAPRL | SAP Release | |||
| KEY | element | SWC_ELEM | Element | |||
| KEY | wi_aed | SWW_AED | Done On | |||
| KEY | wi_aaddr | SWWADDRESS | Address | |||
| KEY | wi_cruser | SWW_CRUSER | Creator | |||
| KEY | wi_craddr | SWWADDRESS | Address | |||
| KEY | wi_cbfb | SWW_CBFB | Callback Funct. Mod. | |||
| KEY | wi_comp_ev | SWW_COMPEV | Completion by event | |||
| KEY | notify | SWW_NOTIFY | Notif. of completion | |||
| KEY | retry_cnt | SWW_RETCNT | Repeat counter | |||
| KEY | max_retry | SWW_RETCNT | Repeat counter | |||
| KEY | rc_modeled | SWW_RCMODL | RC modeled | |||
| KEY | cb_done | SWW_CBDONE | Callback flag | |||
| KEY | handle | SWT_HANDL_ | Trace ID | |||
| KEY | syncchain | SWW_CHAIN | Synch. chain | |||
| KEY | no_deadl | SWW_DEADFL | Deadlines | |||
| KEY | wlc_displ | SWW_MODDIS | Modeled display | |||
| KEY | wi_restlog | SWD_NOLOG | Minimize Number of Entries in Workflow Log | |||
| KEY | remote_id | SWW_WIID | Work Item ID | |||
| KEY | remote_sys | LOGSYS | Logical system | |||
| KEY | status_evt | SWW_STAEVT | Status event | |||
| KEY | timeout | SWD_BI_W_O | Time Until Timeout | |||
| KEY | wf_type | SWD_WFTYPE | Workflow type | |||
| KEY | wlc_flags | SWW_WLC_FLAGS | Attributes | |||
| KEY | xmlprot | SWD_XMLPRT | Transfer format | |||
| KEY | wait4cb | SWD_WAIT4C | Wait for feedback | |||
| KEY | top_wi_id | SWFRTWIID | Top Level Workflow | |||
| KEY | def_guid | SWFRDGUID | Unique ID | |||
| KEY | exec_time | SWFREXECTM | Duration | |||
| KEY | note_count | SWFRNOTECN | Attachments | |||
| KEY | crea_tmp | SWFRCRETS | Created |
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.
-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SWIWIOBJCT (
CLIENT, -- Client [MANDT]
OBJTYPE, -- Object Type [SWO_OBJTYP]
OBJKEY, -- Key [SWO_TYPEID]
WI_ID, -- Work Item ID [SWW_WIID]
WI_TYPE, -- Type [SWW_WITYPE]
WI_CREATOR, -- Creator [SWW_OBJID]
WI_LANG, -- Language [SWW_LANG]
WI_TEXT, -- Work item text [SWW_WITEXT]
WI_RHTEXT, -- Task text [SWW_RHTEXT]
WI_STAT, -- Status [SWW_WISTAT]
WI_CD, -- Creation Date [SWW_CD]
WI_CT, -- Creation Time [SWW_CT]
WI_AAGENT, -- Agent [SWW_AAGENT]
WI_CHCKWI, -- Workflow [SWW_CHCKWI]
WI_RH_TASK, -- Task [SWW_TASK]
WI_PRIO, -- Priority [SWW_PRIO]
WI_CONFIRM, -- Confirm [SWW_WICONF]
WI_FORW_BY, -- Forwarder [SWW_FORWBY]
WI_DISABLE, -- Lock flag [SWW_DISABL]
WI_REJECT, -- Rejectable [SWW_REJECT]
TCLASS, -- Classification [HR_TASK_CL]
NOTE_EXIST, -- Attachments [SWW_NOTEEX]
WI_DH_STAT, -- Deadline Status [SWW_WIDHST]
WI_RELEASE, -- SAP Release [SYSAPRL]
ELEMENT, -- Element [SWC_ELEM]
WI_AED, -- Done On [SWW_AED]
WI_AADDR, -- Address [SWWADDRESS]
WI_CRUSER, -- Creator [SWW_CRUSER]
WI_CRADDR, -- Address [SWWADDRESS]
WI_CBFB, -- Callback Funct. Mod. [SWW_CBFB]
WI_COMP_EV, -- Completion by event [SWW_COMPEV]
NOTIFY, -- Notif. of completion [SWW_NOTIFY]
RETRY_CNT, -- Repeat counter [SWW_RETCNT]
MAX_RETRY, -- Repeat counter [SWW_RETCNT]
RC_MODELED, -- RC modeled [SWW_RCMODL]
CB_DONE, -- Callback flag [SWW_CBDONE]
HANDLE, -- Trace ID [SWT_HANDL_]
SYNCCHAIN, -- Synch. chain [SWW_CHAIN]
NO_DEADL, -- Deadlines [SWW_DEADFL]
WLC_DISPL, -- Modeled display [SWW_MODDIS]
WI_RESTLOG, -- Minimize Number of Entries in Workflow Log [SWD_NOLOG]
REMOTE_ID, -- Work Item ID [SWW_WIID]
REMOTE_SYS, -- Logical system [LOGSYS]
STATUS_EVT, -- Status event [SWW_STAEVT]
TIMEOUT, -- Time Until Timeout [SWD_BI_W_O]
WF_TYPE, -- Workflow type [SWD_WFTYPE]
WLC_FLAGS, -- Attributes [SWW_WLC_FLAGS]
XMLPROT, -- Transfer format [SWD_XMLPRT]
WAIT4CB, -- Wait for feedback [SWD_WAIT4C]
TOP_WI_ID, -- Top Level Workflow [SWFRTWIID]
DEF_GUID, -- Unique ID [SWFRDGUID]
EXEC_TIME, -- Duration [SWFREXECTM]
NOTE_COUNT, -- Attachments [SWFRNOTECN]
CREA_TMP, -- Created [SWFRCRETS]
PRIMARY KEY (CLIENT, OBJTYPE, OBJKEY, WI_ID, WI_TYPE, WI_CREATOR, WI_LANG, WI_TEXT, WI_RHTEXT, WI_STAT, WI_CD, WI_CT, WI_AAGENT, WI_CHCKWI, WI_RH_TASK, WI_PRIO, WI_CONFIRM, WI_FORW_BY, WI_DISABLE, WI_REJECT, TCLASS, NOTE_EXIST, WI_DH_STAT, WI_RELEASE, ELEMENT, WI_AED, WI_AADDR, WI_CRUSER, WI_CRADDR, WI_CBFB, WI_COMP_EV, NOTIFY, RETRY_CNT, MAX_RETRY, RC_MODELED, CB_DONE, HANDLE, SYNCCHAIN, NO_DEADL, WLC_DISPL, WI_RESTLOG, REMOTE_ID, REMOTE_SYS, STATUS_EVT, TIMEOUT, WF_TYPE, WLC_FLAGS, XMLPROT, WAIT4CB, TOP_WI_ID, DEF_GUID, EXEC_TIME, NOTE_COUNT, CREA_TMP)
);
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