SAP Knowledge Base Article - Public

2571568 - Query includes cancelled entries


  • 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


  • The standard view, I_TIMESHEETRECORD, includes all timesheet entries recorded, even those which are cancelled


  • 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


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


SAP S/4HANA Cloud all versions