WLF_D_SWL_HEAD
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_SetlMgmtSchedgWl | view | from | BASIC | Scheduling Worklist |
Fields (25)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
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