Fdt_Test_Flt_P3_Cds

DDL: FDT_TEST_FLT_P3_CDS SQL: FDT_TEST_FLT_P3 Type: view

Flight with native parameters

Fdt_Test_Flt_P3_Cds is a CDS View that provides data about "Flight with native parameters" 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 (2)

NameTypeDefault
p_seatmax abap.int4
p_carrid abap.char(6)

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName FDT_TEST_FLT_P3 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Flight with native parameters 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_P3'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Flight with native parameters'
define view Fdt_Test_Flt_P3_Cds
    with parameters
    p_seatmax : abap.int4,
    p_carrid : abap.char(6)
//    p_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.seatsmax = $parameters.p_seatmax and
      sflight.carrid = $parameters.p_carrid
//      sflight.price = $parameters.p_price

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SFLIGHT"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More