Fdt_Test_Flt_P2_Cds

DDL: FDT_TEST_FLT_P2_CDS SQL: FDT_TEST_FLT_P2 Type: view

Flight with amount parameter

Fdt_Test_Flt_P2_Cds is a CDS View that provides data about "Flight with amount parameter" in SAP S/4HANA. It reads from 1 data source (sflight) and exposes 14 fields.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
sflight sflight from

Parameters (1)

NameTypeDefault
p_price s_price

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName FDT_TEST_FLT_P2 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Flight with amount parameter view

Fields (14)

KeyFieldSource TableSource FieldDescription
mandt sflight mandt
carrid sflight carrid
connid sflight connid
fldate sflight fldate
price sflight price
currency sflight currency
planetype sflight planetype
seatsmax sflight seatsmax
seatsocc sflight seatsocc
paymentsum sflight paymentsum
seatsmax_b sflight seatsmax_b
seatsocc_b sflight seatsocc_b
seatsmax_f sflight seatsmax_f
seatsocc_f sflight seatsocc_f 
@AbapCatalog.sqlViewName: 'FDT_TEST_FLT_P2'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Flight with amount parameter'
define view Fdt_Test_Flt_P2_Cds
    with parameters
    p_price   : s_price
  as select from sflight
{
   sflight.mandt,
   sflight.carrid,
   sflight.connid,
   sflight.fldate,
   sflight.price,
   sflight.currency,
   sflight.planetype,
   sflight.seatsmax,
   sflight.seatsocc,
   sflight.paymentsum,
   sflight.seatsmax_b,
   sflight.seatsocc_b,
   sflight.seatsmax_f,
   sflight.seatsocc_f
}
where sflight.price = $parameters.p_price
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SFLIGHT"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More