17 lines
589 B
Plaintext
17 lines
589 B
Plaintext
@AccessControl.authorizationCheck: #NOT_REQUIRED
|
|
@EndUserText.label: 'Hotel stay'
|
|
define view entity {{P}}I_STAY
|
|
as select from {{p}}stay
|
|
left outer join {{p}}hotel as hotel on hotel.hotel_id = stay.hotel_id
|
|
association [0..1] to {{P}}I_HOTEL as _Hotel
|
|
on $projection.hotel_id = _Hotel.hotel_id
|
|
{
|
|
key stay.stay_id as stay_id,
|
|
stay.hotel_id as hotel_id,
|
|
stay.guest as guest,
|
|
stay.nights as nights,
|
|
cast( stay.nights as abap.dec(15,2) ) * stay.price_per_night as total_price,
|
|
hotel.city_name as city_name,
|
|
hotel.star_rating as star_rating
|
|
}
|