ISLM_PLND_TASKS

Transparent Table Application Table
37 Fields 1 CDS Views

Planned Tasks Header information

ISLM_PLND_TASKS is an SAP database table in S/4HANA. Planned Tasks Header information. It contains 37 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
i_islm_p_plannedtasks view_entity from Planned Tasks

Fields (37)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY guid ISLM2_DE_UUID GUID
scenario_name ISLM2_DE_PS_NAME Intelligent Scenario
md_guid ISLM2_DE_UUID GUID
task_type ISLM2_DE_TASK_TYPE Task Type
description ISLM2_DE_DESC100 Description
start_timestamp ISLM_DE_START_TIMESTAMP Start Timestamp
start_immediately ISLM_DE_START_IMD Start Immediately
type ISLM_DE_JOB_ENDTYPE End Type
end_timestamp ISLM_DE_END_TIMESTAMP End Timestamp
max_iterations ISLM_DE_MAX_ITERATIONS Iterations Counter
frequency ISLM_DE_SCHDL_FREQUENCY Job Frequency
recur_interval ISLM_DE_RECUR_INTERVAL Job Recurrence Inter
status ISLM_DE_SCHDL_STATUS Schedule Status
schdl_timezone ISLM_DE_TIMEZONE Time Zone
calendar_id ISLM_DE_CALID Calendar
start_restriction_code ISLM_DE_START_RESTRICTION Restriction of Start
on_monday ISLM_DE_MONDAY On Monday
on_tuesday ISLM_DE_TUESDAY On Tuesday
on_wednesday ISLM_DE_WEDNESDAY On Wednesday
on_thursday ISLM_DE_THURSDAY On Thursday
on_friday ISLM_DE_FRIDAY On Friday
on_saturday ISLM_DE_SATURDAY On Saturday
on_sunday ISLM_DE_SUNDAY On Sunday
month_day ISLM_DE_MONTHDAY Month Day
use_working_days_ind ISLM_DE_WORK_DAY_IND Working Day Ind
shift_direction ISLM_DE_SHIFT_DIRECTION Count direction
week_number ISLM_DE_WEEK_NUMBER Periodic job
bindings ISLM2_DE_JSON Serialized JSON
job_template ISLM_DE_JOB_TEMPLATE Job Template Name
job_catalogue ISLM_DE_JOB_CATALOGUE Job Catalog
job_name ISLM_DE_JOB_NAME Job Name
job_count ISLM_DE_JOB_ID Job No.
created_by ISLM_DE_CRUSER Created by
created_at ISLM_DE_CREATIONDATE_UTC Creation Date
changed_by ISLM_DE_CHUSER Changed By
changed_at ISLM_DE_LASTMODIFIED_UTC Last Modified Date

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.

-- Planned Tasks Header information
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ISLM_PLND_TASKS (
    MANDT,                   -- Client [MANDT]
    GUID,                    -- GUID [ISLM2_DE_UUID]
    SCENARIO_NAME,           -- Intelligent Scenario [ISLM2_DE_PS_NAME]
    MD_GUID,                 -- GUID [ISLM2_DE_UUID]
    TASK_TYPE,               -- Task Type [ISLM2_DE_TASK_TYPE]
    DESCRIPTION,             -- Description [ISLM2_DE_DESC100]
    START_TIMESTAMP,         -- Start Timestamp [ISLM_DE_START_TIMESTAMP]
    START_IMMEDIATELY,       -- Start Immediately [ISLM_DE_START_IMD]
    TYPE,                    -- End Type [ISLM_DE_JOB_ENDTYPE]
    END_TIMESTAMP,           -- End Timestamp [ISLM_DE_END_TIMESTAMP]
    MAX_ITERATIONS,          -- Iterations Counter [ISLM_DE_MAX_ITERATIONS]
    FREQUENCY,               -- Job Frequency [ISLM_DE_SCHDL_FREQUENCY]
    RECUR_INTERVAL,          -- Job Recurrence Inter [ISLM_DE_RECUR_INTERVAL]
    STATUS,                  -- Schedule Status [ISLM_DE_SCHDL_STATUS]
    SCHDL_TIMEZONE,          -- Time Zone [ISLM_DE_TIMEZONE]
    CALENDAR_ID,             -- Calendar [ISLM_DE_CALID]
    START_RESTRICTION_CODE,  -- Restriction of Start [ISLM_DE_START_RESTRICTION]
    ON_MONDAY,               -- On Monday [ISLM_DE_MONDAY]
    ON_TUESDAY,              -- On Tuesday [ISLM_DE_TUESDAY]
    ON_WEDNESDAY,            -- On Wednesday [ISLM_DE_WEDNESDAY]
    ON_THURSDAY,             -- On Thursday [ISLM_DE_THURSDAY]
    ON_FRIDAY,               -- On Friday [ISLM_DE_FRIDAY]
    ON_SATURDAY,             -- On Saturday [ISLM_DE_SATURDAY]
    ON_SUNDAY,               -- On Sunday [ISLM_DE_SUNDAY]
    MONTH_DAY,               -- Month Day [ISLM_DE_MONTHDAY]
    USE_WORKING_DAYS_IND,    -- Working Day Ind [ISLM_DE_WORK_DAY_IND]
    SHIFT_DIRECTION,         -- Count direction [ISLM_DE_SHIFT_DIRECTION]
    WEEK_NUMBER,             -- Periodic job [ISLM_DE_WEEK_NUMBER]
    BINDINGS,                -- Serialized JSON [ISLM2_DE_JSON]
    JOB_TEMPLATE,            -- Job Template Name [ISLM_DE_JOB_TEMPLATE]
    JOB_CATALOGUE,           -- Job Catalog [ISLM_DE_JOB_CATALOGUE]
    JOB_NAME,                -- Job Name [ISLM_DE_JOB_NAME]
    JOB_COUNT,               -- Job No. [ISLM_DE_JOB_ID]
    CREATED_BY,              -- Created by [ISLM_DE_CRUSER]
    CREATED_AT,              -- Creation Date [ISLM_DE_CREATIONDATE_UTC]
    CHANGED_BY,              -- Changed By [ISLM_DE_CHUSER]
    CHANGED_AT,              -- Last Modified Date [ISLM_DE_LASTMODIFIED_UTC]
    PRIMARY KEY (MANDT, GUID)
);

Learn More