FPMT_BOOKING_QUERY_1

DDL: FPMT_BOOKING_QUERY_1 SQL: FPMT_VQBOOKING1 Type: view
24 Fields 1 Data Sources

Flight Booking Query - without Variables

FPMT_BOOKING_QUERY_1 is a CDS View that provides data about "Flight Booking Query - without Variables" in SAP S/4HANA. It reads from 1 data source (FPMT_BOOKING_CUBE) and exposes 24 fields with key fields Airline, ConnectionNumber, FlightDate, BookingId.

Data Sources (1)

SourceAliasJoin Type
FPMT_BOOKING_CUBE FPMT_BOOKING_CUBE from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName FPMT_VQBOOKING1 view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Flight Booking Query - without Variables view
Analytics.query true view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY Airline Airline Airline
KEY ConnectionNumber ConnectionNumber
KEY FlightDate FlightDate
KEY BookingId BookingId
Customid Customid Customer Number
Custtype Custtype B/P customer
Smoker Smoker Smoker
LuggageWeight LuggageWeight
WeightUnit WeightUnit Weight unit
Invoice Invoice Orig.Inv.Number
Class Class User Group
Forcuram Forcuram Amount
ForeignCurrency ForeignCurrency
Loccuram Loccuram Amount
LocalCurrency LocalCurrency Local Currency
OrderDate OrderDate Item Order Date
Counter Counter Version
AgencyId AgencyId
Cancelled Cancelled Item Discarded
Reserved Reserved Reserved
Passname Passname Passenger Name
Passform Passform Title
Passbirth Passbirth DOB of Passeng.
Planetype Planetype Planetype

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view FPMT_BOOKING_QUERY_1.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: FPMT_VQBOOKING1

CREATE VIEW FPMT_BOOKING_QUERY_1 AS
SELECT
  Airline,
  ConnectionNumber,
  FlightDate,
  BookingId,
  Customid,
  Custtype,
  Smoker,
  LuggageWeight,
  WeightUnit,
  Invoice,
  Class,
  Forcuram,
  ForeignCurrency,
  Loccuram,
  LocalCurrency,
  OrderDate,
  Counter,
  AgencyId,
  Cancelled,
  Reserved,
  Passname,
  Passform,
  Passbirth,
  Planetype
FROM FPMT_BOOKING_CUBE
;

Learn More