DEMO_CDS_PARAM_VIEW_ENTITY
View Entity with Input Parameters
DEMO_CDS_PARAM_VIEW_ENTITY is a CDS View in S/4HANA. View Entity with Input Parameters. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| DEMO_CDS_DATA_SOURCE | view_entity | from | CDS view entity data source example |
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'View Entity with Input Parameters'
define view entity Demo_Cds_Param_View_Entity
with parameters
p_distance_l :s_distance,
p_distance_u :s_distance,
p_unit :s_distid
as select from
spfli
{
key carrid,
key connid,
cityfrom,
cityto,
distance,
distid
}
where
distid = $parameters.p_unit
and distance between $parameters.p_distance_l
and $parameters.p_distance_u;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SPFLI"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/