CRMS4D_SCHEDLIN

Transparent Table Application Table
18 Fields 1 CDS Views

Scheduled Lines Table

CRMS4D_SCHEDLIN is an SAP database table in S/4HANA. Scheduled Lines Table. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SrvcDocItmScheduleLines view from BASIC View for reading schedule lines of Service document

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY objtype_h CRMT_SUBOBJECT_CATEGORY_DB Trans. Cat.
KEY object_id CRMT_OBJECT_ID_DB Transaction ID
KEY number_int CRMS4_NUMBER_INT Item Number in Doc.
KEY schedlin_no CRMT_SCHEDLIN_NO Schedule line
parent_sdln_no CRMT_SCHEDLIN_NO Schedule line
event_type_appl EV_TYPE_APPL Appl. date type
event_type EV_TYPE Date Type
from_flagfixed EV_FR_FLAGFIXED Start Fix
to_flagfixed EV_TO_FLAGFIXED Fixed end
quantity CRMT_SCHEDLIN_QUAN Quantity
source CRMT_SCHEDLIN_SOURCE Source
from_time EV_FR_TIME Start
from_timezone EV_FR_TIMEZONE Start Time Zone
to_time EV_TO_TIME End time
to_timezone EV_TO_TIMEZONE End time zone
from_time_io TZTF_IO_FIELD Time
sched_no_ext CRMT_SCHED_NO_EXT Ex.Sched.LineNo

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.

-- Scheduled Lines Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_SCHEDLIN (
    CLIENT,           -- Client [MANDT]
    OBJTYPE_H,        -- Trans. Cat. [CRMT_SUBOBJECT_CATEGORY_DB]
    OBJECT_ID,        -- Transaction ID [CRMT_OBJECT_ID_DB]
    NUMBER_INT,       -- Item Number in Doc. [CRMS4_NUMBER_INT]
    SCHEDLIN_NO,      -- Schedule line [CRMT_SCHEDLIN_NO]
    PARENT_SDLN_NO,   -- Schedule line [CRMT_SCHEDLIN_NO]
    EVENT_TYPE_APPL,  -- Appl. date type [EV_TYPE_APPL]
    EVENT_TYPE,       -- Date Type [EV_TYPE]
    FROM_FLAGFIXED,   -- Start Fix [EV_FR_FLAGFIXED]
    TO_FLAGFIXED,     -- Fixed end [EV_TO_FLAGFIXED]
    QUANTITY,         -- Quantity [CRMT_SCHEDLIN_QUAN]
    SOURCE,           -- Source [CRMT_SCHEDLIN_SOURCE]
    FROM_TIME,        -- Start [EV_FR_TIME]
    FROM_TIMEZONE,    -- Start Time Zone [EV_FR_TIMEZONE]
    TO_TIME,          -- End time [EV_TO_TIME]
    TO_TIMEZONE,      -- End time zone [EV_TO_TIMEZONE]
    FROM_TIME_IO,     -- Time [TZTF_IO_FIELD]
    SCHED_NO_EXT,     -- Ex.Sched.LineNo [CRMT_SCHED_NO_EXT]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID, NUMBER_INT, SCHEDLIN_NO)
);

Learn More