THRFIO_CALEVT
Team Calendar Event Type
THRFIO_CALEVT is an SAP database table in S/4HANA. Team Calendar Event Type. It contains 10 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_HCMTeamCalendarEventType | view_entity | from | BASIC | Teamcalendar Event Type |
Fields (10)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | event_type_id | HRFIO_CAL_EVENT_TYPE_ID | Event Type ID | |||
| event_category | HRFIO_CAL_EVENT_CATEGORY | Event Category | ||||
| event_subcategory | HRFIO_CAL_EVENT_SUBCATEGORY | Event Subcategory | ||||
| color_type | HRFIO_CAL_COLOR_TYPE | Color Type | ||||
| color_code | HRFIO_CAL_COLOR_CODE | Color Code | ||||
| icon | HRFIO_CAL_ICON | Icon | ||||
| is_relevant_for_absence | HRFIO_CAL_IS_REL_FOR_ABSENCE | Relevant f. Absence | ||||
| show_as_non_working_day | HRFIO_CAL_SHOW_AS_N_WORK_DAY | Non Working Day | ||||
| use_for_new_requested_leave | HRFIO_CAL_USE_FOR_NEW_LEAVE | Use for New Leave |
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.
-- Team Calendar Event Type
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE THRFIO_CALEVT (
CLIENT, -- Client [MANDT]
EVENT_TYPE_ID, -- Event Type ID [HRFIO_CAL_EVENT_TYPE_ID]
EVENT_CATEGORY, -- Event Category [HRFIO_CAL_EVENT_CATEGORY]
EVENT_SUBCATEGORY, -- Event Subcategory [HRFIO_CAL_EVENT_SUBCATEGORY]
COLOR_TYPE, -- Color Type [HRFIO_CAL_COLOR_TYPE]
COLOR_CODE, -- Color Code [HRFIO_CAL_COLOR_CODE]
ICON, -- Icon [HRFIO_CAL_ICON]
IS_RELEVANT_FOR_ABSENCE, -- Relevant f. Absence [HRFIO_CAL_IS_REL_FOR_ABSENCE]
SHOW_AS_NON_WORKING_DAY, -- Non Working Day [HRFIO_CAL_SHOW_AS_N_WORK_DAY]
USE_FOR_NEW_REQUESTED_LEAVE, -- Use for New Leave [HRFIO_CAL_USE_FOR_NEW_LEAVE]
PRIMARY KEY (CLIENT, EVENT_TYPE_ID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA