Fdt_Test_Flight_Al_Cds

DDL: FDT_TEST_FLIGHT_AL_CDS SQL: FDT_TEST_FLIGHTA Type: view

CDS for testing alias , sflight

Fdt_Test_Flight_Al_Cds is a CDS View that provides data about "CDS for testing alias , sflight" in SAP S/4HANA. It reads from 1 data source (sflight) and exposes 18 fields.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
sflight sflight from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName FDT_TEST_FLIGHTA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS for testing alias , sflight view

Fields (18)

KeyFieldSource TableSource FieldDescription
Client 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
cityfrom TestPfli cityfrom
_scarr _scarr
_sbook _sbook
TestPfli TestPfli 
@AbapCatalog.sqlViewName: 'FDT_TEST_FLIGHTA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CDS for testing alias , sflight'
define view Fdt_Test_Flight_Al_Cds as select from sflight 

   association [1..1] to Fdt_Test_Pfli_Cds as TestPfli on(
    $projection.carrid     = TestPfli.carrid
    and $projection.connid = TestPfli.connid
     )

  association [1..1] to Fdt_Test_Carr_Cds as _scarr on(
    $projection.carrid = _scarr.carrid
  )
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [1..*] to Fdt_Test_Book_Cds as _sbook on(
    $projection.carrid     = _sbook.carrid
    and $projection.connid = _sbook.connid
    and $projection.fldate = _sbook.fldate
  )
{
  sflight.mandt as Client,
  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,
  TestPfli.cityfrom,
  /* Associations */
  _scarr,
  _sbook,
  TestPfli

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

Learn More