S_Flights

DDL: S_FLIGHT SQL: S_FLIGHTSV Type: view

Flights

S_Flights is a CDS View that provides data about "Flights" in SAP S/4HANA. It reads from 1 data source (sflight) and exposes 18 fields with key fields CarrierId, ConnectionId, FlightDate. It has 5 associations to related views.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
sflight sflight from

Associations (5)

CardinalityTargetAliasCondition
[1..1] tcurc _Currency $projection.currencyCode = _Currency.waers
[1] S_Carrier _Carrier $projection.CarrierId = _Carrier.CarrierId
[1] S_Connections _Connection $projection.CarrierId = _Connection.CarrierId and $projection.ConnectionId = _Connection.ConnectionId
[1] S_Planes _Plane $projection.planetype = _Plane.planetype
[*] S_Bookings _Bookings $projection.CarrierId = _Bookings.CarrierId and $projection.ConnectionId = _Bookings.ConnectionId and $projection.FlightDate = _Bookings.FlightDate

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName S_FLIGHTSV view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Flights view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY CarrierId carrid
KEY ConnectionId connid
KEY FlightDate fldate
price price
currencyCode currency
planetype planetype
seatsmax seatsmax
seatsocc seatsocc
paymentsum paymentsum
seatsmax_b seatsmax_b
seatsocc_b seatsocc_b
seatsmax_f seatsmax_f
seatsocc_f seatsocc_f
_Currency _Currency
_Carrier _Carrier
_Connection _Connection
_Plane _Plane
_Bookings _Bookings 
@AbapCatalog.sqlViewName: 'S_FLIGHTSV'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Flights'
define view S_Flights as select from sflight
    association [1..1]    to tcurc            as _Currency   on $projection.currencyCode =   _Currency.waers
    association [1]    to S_Carrier        as _Carrier on $projection.CarrierId =  _Carrier.CarrierId                                                    
    association [1]    to S_Connections   as _Connection on $projection.CarrierId =  _Connection.CarrierId 
                                                          and $projection.ConnectionId = _Connection.ConnectionId                                                                                                     
    association [1]    to S_Planes         as _Plane      on $projection.planetype =   _Plane.planetype
    association [*]    to S_Bookings       as _Bookings   on $projection.CarrierId =  _Bookings.CarrierId 
                                                           and $projection.ConnectionId = _Bookings.ConnectionId
                                                           and $projection.FlightDate = _Bookings.FlightDate                                                                                                     
 {

 key carrid as CarrierId, 
 key connid as ConnectionId, 
 key fldate as FlightDate, 
 
  price, 
  currency as currencyCode,  
  planetype, 
  seatsmax, 
  seatsocc, 
  paymentsum, 
  seatsmax_b, 
  seatsocc_b, 
  seatsmax_f, 
  seatsocc_f,
  
  _Currency,
  _Carrier,
  _Connection,
  _Plane,
  _Bookings
}    
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SFLIGHT"
],
"ASSOCIATED":
[
"S_BOOKINGS",
"S_CARRIER",
"S_CONNECTIONS",
"S_PLANES",
"TCURC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More