15 lines
542 B
Plaintext
15 lines
542 B
Plaintext
@AccessControl.authorizationCheck: #NOT_REQUIRED
|
|
@EndUserText.label: 'Table fee of a visit'
|
|
define view entity {{P}}I_VISIT_FEE
|
|
with parameters p_rate : abap.dec( 5, 2 )
|
|
as select from {{p}}visit as v
|
|
inner join {{p}}area as a on a.area_id = v.area_id
|
|
{
|
|
key v.visit_id as visit_id,
|
|
v.guest as guest,
|
|
a.area_name as area_name,
|
|
v.num_hours as num_hours,
|
|
v.num_hours * $parameters.p_rate as fee
|
|
}
|
|
where v.visit_state = 'Z'
|