SWPSTEPLOG

Transparent Table Application Table
28 Fields 8 CDS Views

Workflow: Instance Data of Steps of a Workflow Execution

SWPSTEPLOG is an SAP database table in S/4HANA. Workflow: Instance Data of Steps of a Workflow Execution. It contains 28 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
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_PPS_PurOrdWorkflow_Steplog view_entity from BASIC
P_WorkflowLogReturnValue view from BASIC
R_StepLogMostRecent view_entity from Flexible Workflow: Most recent entry per wf instance

Fields (28)

KeyField Data ElementDescription DomainTypeLength
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: Instance Data of Steps of a Workflow Execution
-- 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