SAP Knowledge Base Article - Public

2571568 - Query includes cancelled entries

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 all versions