SWPSTEPLOG
Workflow: Instanzdaten der Schritte e. Workflow-Ausführung
SWPSTEPLOG is an SAP database table in S/4HANA. Workflow: Instanzdaten der Schritte e. Workflow-Ausführung. It contains 28 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_EHSWorkflowDecisionStatus | view | from | BASIC | Workflow Decision Status |
| I_WorkflowResult | view | from | BASIC | Exposes result of a workflow instance |
| I_WorkflowTaskResult | view | from | BASIC | Workflow Task Result |
| P_FACVD_WF_STATUS_MAX_TS | view | inner | BASIC | |
| P_LglCntntMWorkflowTaskResult | view | from | BASIC | Private view for Workflow Task Result |
| P_WorkflowLogReturnValue | view | from | BASIC |
Fields (28)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | swp_mandt | Client | |||
| KEY | wf_id | swp_wf_id | Workflow ID | |||
| KEY | node_id | swd_nodeid | Workflow Step | |||
| KEY | node_p_ind | swp_parf_i | ParForEach index | |||
| KEY | log_date | swp_logdat | Date of logging | |||
| KEY | log_time | swp_logtim | Time of logging | |||
| KEY | log_count | sww_logcnt | Log counter | |||
| timestamp | timestampl | Time Stamp | ||||
| deleted | swp_delete | Deleted? | ||||
| retrycount | swp_retryc | RetryCounter | ||||
| wi_id | swp_wi_id | WorkItem ID | ||||
| wi_system | swp_logsys | WI system | ||||
| task_id | swd_step_t | Task | ||||
| wi_agent | sww_aagent | Agent | ||||
| wi_aed | sww_aed | Done On | ||||
| wi_aet | sww_aet | Actual end time | ||||
| returncode | swp_cmp_ev | Terminating event | ||||
| wi_dh_stat | sww_widhst | Deadline Status | ||||
| pred_node | swp_predno | Preceding activity | ||||
| pred_nodep | swp_prednp | Parallelism index | ||||
| pred_wi_id | swp_predwi | WI ID of prec.activ. | ||||
| returnval | swp_retval | Return value | ||||
| returntyp | swp_rettyp | Return Type | ||||
| _dataaging | data_temperature | Data Aging | ||||
| flex_return_value | swf_flex_retval | Returncode | ||||
| flex_return_nature | swf_flex_retnat | Nature | ||||
| flex_step_id | swf_flex_step_id | Id | ||||
| flex_decision_reason | swf_flex_decision_reason_id | Decision Reason ID |
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: Instanzdaten der Schritte e. Workflow-Ausführung
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SWPSTEPLOG (
CLIENT, -- Client [swp_mandt]
WF_ID, -- Workflow ID [swp_wf_id]
NODE_ID, -- Workflow Step [swd_nodeid]
NODE_P_IND, -- ParForEach index [swp_parf_i]
LOG_DATE, -- Date of logging [swp_logdat]
LOG_TIME, -- Time of logging [swp_logtim]
LOG_COUNT, -- Log counter [sww_logcnt]
TIMESTAMP, -- Time Stamp [timestampl]
DELETED, -- Deleted? [swp_delete]
RETRYCOUNT, -- RetryCounter [swp_retryc]
WI_ID, -- WorkItem ID [swp_wi_id]
WI_SYSTEM, -- WI system [swp_logsys]
TASK_ID, -- Task [swd_step_t]
WI_AGENT, -- Agent [sww_aagent]
WI_AED, -- Done On [sww_aed]
WI_AET, -- Actual end time [sww_aet]
RETURNCODE, -- Terminating event [swp_cmp_ev]
WI_DH_STAT, -- Deadline Status [sww_widhst]
PRED_NODE, -- Preceding activity [swp_predno]
PRED_NODEP, -- Parallelism index [swp_prednp]
PRED_WI_ID, -- WI ID of prec.activ. [swp_predwi]
RETURNVAL, -- Return value [swp_retval]
RETURNTYP, -- Return Type [swp_rettyp]
_DATAAGING, -- Data Aging [data_temperature]
FLEX_RETURN_VALUE, -- Returncode [swf_flex_retval]
FLEX_RETURN_NATURE, -- Nature [swf_flex_retnat]
FLEX_STEP_ID, -- Id [swf_flex_step_id]
FLEX_DECISION_REASON, -- Decision Reason ID [swf_flex_decision_reason_id]
PRIMARY KEY (CLIENT, WF_ID, NODE_ID, NODE_P_IND, LOG_DATE, LOG_TIME, LOG_COUNT)
);
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