WORKDATE in CATSDB
Date (DE: Datum)
WORKDATE is a field in SAP table CATSDB (CATS: Database Table for Time Sheet). It represents "Date". Data element: CATSDATE. Available in 24 CDS view(s) as HCMWorkDate, TimeSheetDate, CalendarDate.
Business Meaning
| Description (EN) | Date |
|---|---|
| Beschreibung (DE) | Datum |
| Data Element | CATSDATE |
| Key Field | No |
CDS Views & Technical Names (24)
CATSDB.WORKDATE is exposed in CDS views under the following technical names. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
HCMWorkDate
(15 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_HCMTimeSheetRecord | direct | BASIC | HCM Timesheet Records for Employee | |
| C_HCMTimeShtWorkCalendar | via 2 level | CONSUMPTION | HCM Timesheet Work Calendar | |
| I_HCMActualActivitiesBase | via 2 level | COMPOSITE | Timesheet Actual Activities | |
| I_HCMCompliance | via 2 level | COMPOSITE | HCM Timesheet Compliance | |
| I_HCMTimeSheetRecordTP | via 2 level | TRANSACTIONAL | HCM Timesheet Record - TP | |
| I_HCMTmeShtApprvlTP | via 2 level | TRANSACTIONAL | Timesheet approval - TP | |
| C_HCMCompliance | via 3 levels | CONSUMPTION | HCM Timesheet Compliance | |
| C_HCMComplianceDetails | via 3 levels | CONSUMPTION | HCM Timesheet Compliance Details | |
| C_HCMComplianceEmpl | via 3 levels | CONSUMPTION | HCM Timesheet Compliance Employee | |
| C_HCMTimeSheetRecordTP | via 3 levels | CONSUMPTION | HCM Timesheet Record | |
| C_HCMTmeShtApprvlTP | via 3 levels | CONSUMPTION | Timesheet record for processing | |
| I_HCMActualActivities | via 3 levels | COMPOSITE | Timesheet Actual Activities | |
| C_HCMActivityDetails | via 4 levels | CONSUMPTION | HCM Timesheet Activity Details | |
| C_HCMActualActivities | via 4 levels | CONSUMPTION | HCM Timesheet Actual Activities | |
| C_HCMActualActivitiesEmpl | via 4 levels | CONSUMPTION | HCM Timesheet Actual Activities Employee |
TimeSheetDate
(7 views)
Date
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_TimeSheetRecord | direct | BASIC | Time Recording Data | |
| P_TimeShtEntriesForApprvl | via 2 level | COMPOSITE | ||
| P_TimeShtHrsAnlysForProjects | via 2 level | COMPOSITE | ||
| R_TimeSheet | via 2 level | BASIC | Time Sheet | |
| I_TimeSheet | via 3 levels | BASIC | Time Sheet | |
| R_TimeSheetTP | via 3 levels | TRANSACTIONAL | Time Sheet - TP | |
| I_TimeSheetTP | via 4 levels | TRANSACTIONAL | Time Sheet - TP |
CalendarDate
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_CATSDATAWITHCATEGORY | via 2 level | COMPOSITE | ||
| P_PROJMGRCATSBYPO | via 3 levels | COMPOSITE |
HCMWeeklyViewWorkDate
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_HCMTmeShtApprvlTP | via 2 level | TRANSACTIONAL | Timesheet approval - TP | |
| C_HCMTmeShtApprvlTP | via 3 levels | CONSUMPTION | Timesheet record for processing |
Other Tables with Field WORKDATE (1)
| Table | Data Element | Key | Description |
|---|---|---|---|
| CATSMM | CATSDATE | Cross-Application Time Sheet (CATS): Transfer to MM |
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