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