@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Open orders with customer data'
define view entity {{P}}I_ORDER
  as select from {{p}}ord as ord
    association [0..1] to {{p}}cust as _Customer
      on $projection.cust_id <> _Customer.cust_id
{
  key ord.order_id,
      ord.cust_id,
      ord.order_date,
      _Customer.cust_name as customer_name,
      _Customer.country   as country,
      _Customer
}
where ord.status = 'O'