@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Tour load'
define view entity {{P}}I_TOUR_LOAD
  as select from {{p}}tour as tour
    left outer join   {{p}}parcel as parcel on parcel.tour_id = tour.tour_id
{
  key tour.tour_id        as tour_id,
      tour.driver         as driver,
      tour.depot          as depot,
      count( * )          as parcel_count,
      sum( parcel.weight ) as total_weight
}
group by
  tour.tour_id,
  tour.driver,
  tour.depot