WLF_D_SWL_HEAD

Transparent Table Temporary Data

Settlement Management Scheduling Worklist Head

WLF_D_SWL_HEAD is an SAP database table in S/4HANA. Settlement Management Scheduling Worklist Head. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SetlMgmtSchedgWl view from BASIC Scheduling Worklist

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY worklist_uuid WLF_SWL_UUID Scheduling Worklist UUID
worklist_id WLF_SWL_ID Scheduling Worklist ID
bo_type WLF_BO_TYPE SAP Object Type
bo_node_type WLF_BO_NODE_TYPE SAP Object Node Type
worklist_type WLF_SWL_TYPE Scheduling Worklist Type
worklist_template WLF_SWL_TEMPL Scheduling Worklist Template
job_id BTCJOB Job Name
job_count BTCJOBCNT Job No.
worklist_status WLF_SWL_HEAD_STATUS Scheduling Worklist Status
job_starts_immediately WLF_SWL_START_IMMEDIATELY Start Immediately
job_execution_datetime WLF_SWL_JOB_TIMESTAMP Job Execution Date and Time
created_by WLF_CREATED_BY Created By
created_on WLF_CREATED_ON_TIMESTAMP Created Date Time
last_changed_by WLF_CHANGED_BY Changed By
last_changed_on WLF_CHANGED_ON_TIMESTAMP Last Changed Date and Time
description WLF_SWL_DESC Scheduling Worklist Description
run_category WLF_SWL_RUN_CATEGORY Scheduling Worklist Run Category
posting_date WFDAT Posting Date
document_date WLF_DOCUMENT_DATE Document Date
activity_reason WFGRU Activity Reason
is_recurring WLF_SWL_IS_RECURRING Recurrence Scheduling Worklist
scheduling_status WLF_SWL_SCHEDULING_STATUS Scheduling Status
last_execution_status WLF_SWL_RUN_STATUS_LAST Last Run Status
last_execution_datetime WLF_SWL_JOB_TIMESTAMP_LAST Last Job Execution Date and Time

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.

-- Settlement Management Scheduling Worklist Head
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WLF_D_SWL_HEAD (
    CLIENT,                   -- Client [MANDT]
    WORKLIST_UUID,            -- Scheduling Worklist UUID [WLF_SWL_UUID]
    WORKLIST_ID,              -- Scheduling Worklist ID [WLF_SWL_ID]
    BO_TYPE,                  -- SAP Object Type [WLF_BO_TYPE]
    BO_NODE_TYPE,             -- SAP Object Node Type [WLF_BO_NODE_TYPE]
    WORKLIST_TYPE,            -- Scheduling Worklist Type [WLF_SWL_TYPE]
    WORKLIST_TEMPLATE,        -- Scheduling Worklist Template [WLF_SWL_TEMPL]
    JOB_ID,                   -- Job Name [BTCJOB]
    JOB_COUNT,                -- Job No. [BTCJOBCNT]
    WORKLIST_STATUS,          -- Scheduling Worklist Status [WLF_SWL_HEAD_STATUS]
    JOB_STARTS_IMMEDIATELY,   -- Start Immediately [WLF_SWL_START_IMMEDIATELY]
    JOB_EXECUTION_DATETIME,   -- Job Execution Date and Time [WLF_SWL_JOB_TIMESTAMP]
    CREATED_BY,               -- Created By [WLF_CREATED_BY]
    CREATED_ON,               -- Created Date Time [WLF_CREATED_ON_TIMESTAMP]
    LAST_CHANGED_BY,          -- Changed By [WLF_CHANGED_BY]
    LAST_CHANGED_ON,          -- Last Changed Date and Time [WLF_CHANGED_ON_TIMESTAMP]
    DESCRIPTION,              -- Scheduling Worklist Description [WLF_SWL_DESC]
    RUN_CATEGORY,             -- Scheduling Worklist Run Category [WLF_SWL_RUN_CATEGORY]
    POSTING_DATE,             -- Posting Date [WFDAT]
    DOCUMENT_DATE,            -- Document Date [WLF_DOCUMENT_DATE]
    ACTIVITY_REASON,          -- Activity Reason [WFGRU]
    IS_RECURRING,             -- Recurrence Scheduling Worklist [WLF_SWL_IS_RECURRING]
    SCHEDULING_STATUS,        -- Scheduling Status [WLF_SWL_SCHEDULING_STATUS]
    LAST_EXECUTION_STATUS,    -- Last Run Status [WLF_SWL_RUN_STATUS_LAST]
    LAST_EXECUTION_DATETIME,  -- Last Job Execution Date and Time [WLF_SWL_JOB_TIMESTAMP_LAST]
    PRIMARY KEY (CLIENT, WORKLIST_UUID)
);