SWF_SDM_STATE

Transparent Table System Table (SAP only)

Workflow: SDM state

SWF_SDM_STATE is an SAP database table in S/4HANA. Workflow: SDM state. It contains 8 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
SWF_SDM_SWF_FLEX_PROC view left_outer Workflow: SWF_FLEX_PROC & SDM state
SWF_SDM_SWF_FLEX_TDRAFT view left_outer Workflow: SWF_FLEX_TDRAFT & SDM state
swf_sdm_swf_flex_templat view left_outer Workflow: SWF_FLEX_TEMPLAT & SDM state
SWF_SDM_SWWWIHEAD view left_outer Workflow: join SDM state to SWWWIHEAD

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY scenario_id SWD_WFD_ID Workflow definition
KEY scenario_version SWD_VERSIO Version
KEY wf_def_id SYSUUID_C UUID
KEY appl_obj_id SIBFBORIID Instance ID
KEY wi_id SWW_WIID Work Item ID
KEY tablename TABNAME Table Name
sdm_state SWF_SDM_STATUS SDM State

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: SDM state
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SWF_SDM_STATE (
    CLIENT,            -- Client [MANDT]
    SCENARIO_ID,       -- Workflow definition [SWD_WFD_ID]
    SCENARIO_VERSION,  -- Version [SWD_VERSIO]
    WF_DEF_ID,         -- UUID [SYSUUID_C]
    APPL_OBJ_ID,       -- Instance ID [SIBFBORIID]
    WI_ID,             -- Work Item ID [SWW_WIID]
    TABLENAME,         -- Table Name [TABNAME]
    SDM_STATE,         -- SDM State [SWF_SDM_STATUS]
    PRIMARY KEY (CLIENT, SCENARIO_ID, SCENARIO_VERSION, WF_DEF_ID, APPL_OBJ_ID, WI_ID, TABLENAME)
);