The CRMS4D_SCHEDLIN table in SAP ERP or S/4HANA stores Scheduled Lines Table data. There are total 18 fields in CRMS4D_SCHEDLIN table. The Scheduled Lines Table table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRMS4D_SCHEDLIN table. It is in One Order: Redesign of Persistence Layer (CRMS4_ORDER) ABAP package and is part of the S4CRM: Business Transaction Framework (CRM-S4-BTX) module.
SAP CRMS4D_SCHEDLIN Table Fields
Following is the list of fields that are available in SAP CRMS4D_SCHEDLIN table. The primary key fields of the table are CLIENT (Client), OBJTYPE_H (Business Trans. Cat.), OBJECT_ID (Transaction ID), NUMBER_INT (Shortened Item Number in Document), SCHEDLIN_NO (Schedule Line Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| OBJTYPE_H | Business Trans. Cat. | CRMT_SUBOBJECT_CATEGORY_DB | CRMC_SUBOB_CAT | CHAR (10) |
| OBJECT_ID | Transaction ID | CRMT_OBJECT_ID_DB | CHAR (10) | |
| NUMBER_INT | Shortened Item Number in Document | CRMS4_NUMBER_INT | NUMC (6) | |
| SCHEDLIN_NO | Schedule Line Number | CRMT_SCHEDLIN_NO | NUMC (4) | |
| PARENT_SDLN_NO | Schedule Line Number | CRMT_SCHEDLIN_NO | NUMC (4) | |
| EVENT_TYPE_APPL | Application: Date Type | EV_TYPE_APPL | CHAR (4) | |
| EVENT_TYPE | Date Type | EV_TYPE | CHAR (12) | |
| FROM_FLAGFIXED | Flag Whether Start Time is Fixed | EV_FR_FLAGFIXED | CHAR (1) | |
| TO_FLAGFIXED | Flag Whether End Time is Fixed | EV_TO_FLAGFIXED | CHAR (1) | |
| QUANTITY | CRM Schedule Line Quantity | CRMT_SCHEDLIN_QUAN | QUAN (13) | |
| SOURCE | Source of Schedule Line | CRMT_SCHEDLIN_SOURCE | CHAR (1) | |
| FROM_TIME | Start Time Stamp: Date | EV_FR_TIME | DEC (15) | |
| FROM_TIMEZONE | Start Time Zone: Date | EV_FR_TIMEZONE | TTZZ | CHAR (6) |
| TO_TIME | End Time Stamp: Date | EV_TO_TIME | DEC (15) | |
| TO_TIMEZONE | End Time Zone: Date | EV_TO_TIMEZONE | TTZZ | CHAR (6) |
| FROM_TIME_IO | Field for Date Input | TZTF_IO_FIELD | CHAR (26) | |
| SCHED_NO_EXT | External Schedule Line Number for Type ORDERED | CRMT_SCHED_NO_EXT | CHAR (10) |
