SWDSHEADER

Transparent Table System Table (transport)
75 Fields 2 CDS Views

WF Definition: Basic Data

SWDSHEADER is an SAP database table in S/4HANA. WF Definition: Basic Data. It contains 75 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ADM_WORKFLOW view left_outer COMPOSITE Workflow work items
SWF_FLEX_I_SCEN_VERSION_USAGE view from Flexible Workflow Scenario Version Usage

Fields (75)

KeyField Data ElementDescription DomainTypeLength
KEY wfd_id SWD_WFD_ID Workflow definition
KEY version SWD_VERSIO Version
KEY exetyp SWD_EXETYP Type
status SWD_STATU_ Status of WFD
suspend_e SWD_SUSP_E Suspended
suspend_i SWD_SUSP_I Suspended
activ SWD_ACTFLG Active version
calendar SWD_CALEND FactoryCalendar
language SWD_MLANGU Maint. Language
dynpprog SWD_DYNPRG Program Name
dynnr SWD_DYNNR Screen number
priority SWD_PRIO Priority
longtext SWD_LNGTXT Documentation
created_by SWD_DEFUSR User
created_on SWD_DEFDAT Date
created_at SWD_DEFTIM Time
created_rl SWD_DEFREL Release
changed_by SWD_CHGUSR User
changed_on SWD_CHGDAT Date
changed_at SWD_CHGTIM Time
changed_rl SWD_CHGREL Release
activat_by SWD_ACTUSR User
activat_on SWD_ACTDAT Date
activat_at SWD_ACTTIM Time
activat_rl SWD_ACTREL Activation Release
deadl_agt SWD_D_AGT Object ID
deadl_cont SWD_DEACON Container elem.
notify_agt SWD_N_AGT Object ID
notif_cont SWD_NOTCON Container elem.
wfi_admin SWD_ADMIN Workflow sys. admin.
admin_cont SWD_ADMCON Container elem.
avg_actext SWD_AVG_ET Workflow definition: Average effective processing time
min_actext SWD_MIN_ET Minimum
max_actext SWD_MAX_ET Maximum
avg_totalt SWD_AVG_TT Workflow definition: Average total duration
min_totalt SWD_MIN_TT Minimum
max_totalt SWD_MAX_TT Maximum
task SWD_STEP_T Task
dummy1 SWD_CHAR20 Workflow definition: Dummy
dummy2 SWD_CHAR20 Workflow definition: Dummy
des_st_b SWD_DST_B Refer.date/time
des_st_u SWD_MEINS Time Unit
des_st_o SWD_DST_O Offset
des_end_b SWD_DE_B Refer.date/time
des_end_u SWD_MEINS Time Unit
des_end_o SWD_DE_O Offset
late_end_b SWD_LE_B Refer.date/time
late_end_u SWD_MEINS Time Unit
late_end_o SWD_LE_O Offset
dial_flag SWD_DIALOG No advancing with dialog
created_ul SWD_DEFULV <<Obsolete>>
changed_ul SWD_CHGULV <<Obsolete>>
max_nodes SWP_MAXNOD Maximum node number
max_subwf SWP_MAXSUB Subworkflow level
no_log SWD_NOLOG Minimize Number of Entries in Workflow Log
orig_vers SWD_VERSIO Version
transient SWD_TRANSI Transient
wftype SWD_WFTYPE Workflow type
review_wf SWD_REVWWF Review Workflow
fb_wf_crea SWD_FBWCRE Function Module
appl CATAPPL Application
sappl CATSUBAP Subapplication
thst1 CATTHST1 Component
prind SWD_PRIND Index
prs_profil SWD_PERSID Persistence Profile
enqueque SWD_ENQUQU Lock Behavior of Workflow Runtime System
xmlprot SWD_XMLPRT Transfer format
xmlgrp SWD_XMLGRP Log Group
roll_selection SWP_ROLL_SELECTION Roll-Out/-In Setting
roll_interval SWP_ROLL_INTERVAL Time Interval for Roll-Out/-In
roll_fork_count SWP_ROLL_FORK_COUNT No. Branches for Roll-Out/-In
orig_uuid SWD_ORIG_ID Original ID
tr_request TRKORR Request/Task
langu_update SWD_LANGUPD Workflow: last language update via LANG PDWS transport
replicate SWD_REPLICAT replicate behavior

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.

-- WF Definition: Basic Data
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SWDSHEADER (
    WFD_ID,           -- Workflow definition [SWD_WFD_ID]
    VERSION,          -- Version [SWD_VERSIO]
    EXETYP,           -- Type [SWD_EXETYP]
    STATUS,           -- Status of WFD [SWD_STATU_]
    SUSPEND_E,        -- Suspended [SWD_SUSP_E]
    SUSPEND_I,        -- Suspended [SWD_SUSP_I]
    ACTIV,            -- Active version [SWD_ACTFLG]
    CALENDAR,         -- FactoryCalendar [SWD_CALEND]
    LANGUAGE,         -- Maint. Language [SWD_MLANGU]
    DYNPPROG,         -- Program Name [SWD_DYNPRG]
    DYNNR,            -- Screen number [SWD_DYNNR]
    PRIORITY,         -- Priority [SWD_PRIO]
    LONGTEXT,         -- Documentation [SWD_LNGTXT]
    CREATED_BY,       -- User [SWD_DEFUSR]
    CREATED_ON,       -- Date [SWD_DEFDAT]
    CREATED_AT,       -- Time [SWD_DEFTIM]
    CREATED_RL,       -- Release [SWD_DEFREL]
    CHANGED_BY,       -- User [SWD_CHGUSR]
    CHANGED_ON,       -- Date [SWD_CHGDAT]
    CHANGED_AT,       -- Time [SWD_CHGTIM]
    CHANGED_RL,       -- Release [SWD_CHGREL]
    ACTIVAT_BY,       -- User [SWD_ACTUSR]
    ACTIVAT_ON,       -- Date [SWD_ACTDAT]
    ACTIVAT_AT,       -- Time [SWD_ACTTIM]
    ACTIVAT_RL,       -- Activation Release [SWD_ACTREL]
    DEADL_AGT,        -- Object ID [SWD_D_AGT]
    DEADL_CONT,       -- Container elem. [SWD_DEACON]
    NOTIFY_AGT,       -- Object ID [SWD_N_AGT]
    NOTIF_CONT,       -- Container elem. [SWD_NOTCON]
    WFI_ADMIN,        -- Workflow sys. admin. [SWD_ADMIN]
    ADMIN_CONT,       -- Container elem. [SWD_ADMCON]
    AVG_ACTEXT,       -- Workflow definition: Average effective processing time [SWD_AVG_ET]
    MIN_ACTEXT,       -- Minimum [SWD_MIN_ET]
    MAX_ACTEXT,       -- Maximum [SWD_MAX_ET]
    AVG_TOTALT,       -- Workflow definition: Average total duration [SWD_AVG_TT]
    MIN_TOTALT,       -- Minimum [SWD_MIN_TT]
    MAX_TOTALT,       -- Maximum [SWD_MAX_TT]
    TASK,             -- Task [SWD_STEP_T]
    DUMMY1,           -- Workflow definition: Dummy [SWD_CHAR20]
    DUMMY2,           -- Workflow definition: Dummy [SWD_CHAR20]
    DES_ST_B,         -- Refer.date/time [SWD_DST_B]
    DES_ST_U,         -- Time Unit [SWD_MEINS]
    DES_ST_O,         -- Offset [SWD_DST_O]
    DES_END_B,        -- Refer.date/time [SWD_DE_B]
    DES_END_U,        -- Time Unit [SWD_MEINS]
    DES_END_O,        -- Offset [SWD_DE_O]
    LATE_END_B,       -- Refer.date/time [SWD_LE_B]
    LATE_END_U,       -- Time Unit [SWD_MEINS]
    LATE_END_O,       -- Offset [SWD_LE_O]
    DIAL_FLAG,        -- No advancing with dialog [SWD_DIALOG]
    CREATED_UL,       -- <<Obsolete>> [SWD_DEFULV]
    CHANGED_UL,       -- <<Obsolete>> [SWD_CHGULV]
    MAX_NODES,        -- Maximum node number [SWP_MAXNOD]
    MAX_SUBWF,        -- Subworkflow level [SWP_MAXSUB]
    NO_LOG,           -- Minimize Number of Entries in Workflow Log [SWD_NOLOG]
    ORIG_VERS,        -- Version [SWD_VERSIO]
    TRANSIENT,        -- Transient [SWD_TRANSI]
    WFTYPE,           -- Workflow type [SWD_WFTYPE]
    REVIEW_WF,        -- Review Workflow [SWD_REVWWF]
    FB_WF_CREA,       -- Function Module [SWD_FBWCRE]
    APPL,             -- Application [CATAPPL]
    SAPPL,            -- Subapplication [CATSUBAP]
    THST1,            -- Component [CATTHST1]
    PRIND,            -- Index [SWD_PRIND]
    PRS_PROFIL,       -- Persistence Profile [SWD_PERSID]
    ENQUEQUE,         -- Lock Behavior of Workflow Runtime System [SWD_ENQUQU]
    XMLPROT,          -- Transfer format [SWD_XMLPRT]
    XMLGRP,           -- Log Group [SWD_XMLGRP]
    ROLL_SELECTION,   -- Roll-Out/-In Setting [SWP_ROLL_SELECTION]
    ROLL_INTERVAL,    -- Time Interval for Roll-Out/-In [SWP_ROLL_INTERVAL]
    ROLL_FORK_COUNT,  -- No. Branches for Roll-Out/-In [SWP_ROLL_FORK_COUNT]
    ORIG_UUID,        -- Original ID [SWD_ORIG_ID]
    TR_REQUEST,       -- Request/Task [TRKORR]
    LANGU_UPDATE,     -- Workflow: last language update via LANG PDWS transport [SWD_LANGUPD]
    REPLICATE,        -- replicate behavior [SWD_REPLICAT]
    PRIMARY KEY (WFD_ID, VERSION, EXETYP)
);

Learn More