FPMT_BOOKING_QUERY_2

DDL: FPMT_BOOKING_QUERY_2 SQL: FPMT_VQBOOKING2 Type: view
24 Fields 1 Data Sources

Flight Booking Query with Variable

FPMT_BOOKING_QUERY_2 is a CDS View that provides data about "Flight Booking Query with Variable" 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

Parameters (1)

NameTypeDefault
p_airline s_carrid

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName FPMT_VQBOOKING2 view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Flight Booking Query with Variable 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_2.
-- 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_VQBOOKING2
-- Parameters: p_airline : s_carrid

CREATE VIEW FPMT_BOOKING_QUERY_2 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