Fdt_Test_Pfli_P2_Cds

DDL: FDT_TEST_PFLI_P2_CDS SQL: FDT_TEST_PFLI_P2 Type: view
12 Fields 1 Data Sources

Pfli with carrid and deptime parameters

Fdt_Test_Pfli_P2_Cds is a CDS View that provides data about "Pfli with carrid and deptime parameters" in SAP S/4HANA. It reads from 1 data source (spfli) and exposes 12 fields.

Data Sources (1)

SourceAliasJoin Type
spfli spfli from

Parameters (2)

NameTypeDefault
p_carrid s_carr_id
p_deptime s_dep_time

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName FDT_TEST_PFLI_P2 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Pfli with carrid and deptime parameters view

Fields (12)

KeyFieldSource TableSource FieldDescription
mandt spfli mandt Editing Client
carrid spfli carrid Carrier
connid spfli connid Flight Number
countryfr spfli countryfr Departure Country/Region
cityfrom spfli cityfrom Departure City
airpfrom spfli airpfrom Departure Airport
countryto spfli countryto Destination Country/Region
cityto spfli cityto Destination City
airpto spfli airpto Destination Airport
fltime spfli fltime Flight time
deptime spfli deptime Departure Time
arrtime spfli arrtime Arrival Time

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 Fdt_Test_Pfli_P2_Cds.
-- 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: FDT_TEST_PFLI_P2
-- Parameters: p_carrid : s_carr_id, p_deptime : s_dep_time

CREATE VIEW Fdt_Test_Pfli_P2_Cds AS
SELECT
  spfli.mandt AS mandt,
  spfli.carrid AS carrid,
  spfli.connid AS connid,
  spfli.countryfr AS countryfr,
  spfli.cityfrom AS cityfrom,
  spfli.airpfrom AS airpfrom,
  spfli.countryto AS countryto,
  spfli.cityto AS cityto,
  spfli.airpto AS airpto,
  spfli.fltime AS fltime,
  spfli.deptime AS deptime,
  spfli.arrtime AS arrtime
FROM spfli
;

Learn More