The CDBD_DATESEG table in SAP ERP or S/4HANA stores Time segment for class CL_APPOINTMENT_SEG data. There are total 16 fields in CDBD_DATESEG table. The Time segment for class CL_APPOINTMENT_SEG 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 CDBD_DATESEG table. It is in CRM Order: CDB Objects for General Sales Order Processing (CDB_ORDER) ABAP package and is part of the Business Transactions (CRM-BTX) module.
SAP CDBD_DATESEG Table Fields
Following is the list of fields that are available in SAP CDBD_DATESEG table. The primary key fields of Time segment for class CL_APPOINTMENT_SEG table in SAP are CLIENT (Client), DATESEG_GUID (GUID for an Appointment (Date Class CL_APPOINTMENT_SEG)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| DATESEG_GUID | GUID for an Appointment (Date Class CL_APPOINTMENT_SEG) | CDBT_DATE_GUID | RAW (16) | |
| DATECLASS_S_GUID | Own Guid for Dateclass header set | CDBT_DATECLASS_S_GUID | RAW (16) | |
| TST_FROM | Time Stamp (UTC) of Start Time of Appointment | SC_TSTFRO | DEC (15) | |
| ZONE_FROM | Appointment calendar: Time zone of start of appointment | SC_ZONEFRO | * | CHAR (6) |
| TST_TO | Time stamp of end of appointment | SC_TSTTO | DEC (15) | |
| ZONE_TO | Appointment calendar: Time zone of end of appointment | SC_ZONETO | * | CHAR (6) |
| APPT_TYPE | Technical Date Type Name | SC_APPTTYP | * | CHAR (12) |
| TXT_PUB_ID | Internal Identification of Rules of Periodic Appointments | SC_RULEID | CHAR (25) | |
| GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| TR_USER | Character field, length 32 | CHAR32 | CHAR (32) | |
| TR_ID | Character field, length 32 | CHAR32 | CHAR (32) | |
| TR_STATUS | Undefined range (can be used for patch levels) | CHAR4 | CHAR (4) | |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| DELETED | Single-Character Flag | CHAR1 | CHAR (1) | |
| TR_ROOTID | Character field, length 32 | CHAR32 | CHAR (32) |
