Symptom
- Customer developed a custom analytical query to report on number of hours recorded in 'Manage My Timesheet' application
- Report shows time entries recorded but also includes entries which are cancelled
Cause
-
The standard view, I_TIMESHEETRECORD, includes all timesheet entries recorded, even those which are cancelled
Resolution
-
The custom CDS view developed against I_TIMESHEETRECORD should include the column TIMESHEETSTATUS, as a hidden column, and the view should filter on TIMESHEETSTATUS to exclude statuses, including cancelled, which are not to be included in the result set, as per Customer Requirements
Keywords
Analytical Query, Filter, Timesheet, Custom CDS View , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , BC-SRV-APS-GKE , Generic CDS Key User Editor , Problem
Product
SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions