FINKET_S_SFLIGHT_19

DDL: FINKET_S_SFLIGHT_19 SQL: FINKET_SFL19 Type: view
6 Fields 2 Data Sources

Flight Test1

FINKET_S_SFLIGHT_19 is a CDS View that provides data about "Flight Test1" in SAP S/4HANA. It reads from 2 data sources (scarr, spfli) and exposes 6 fields with key fields carrid, connid.

Data Sources (2)

SourceAliasJoin Type
scarr scarr left_outer
spfli spfli from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FINKET_SFL19 view
EndUserText.label Flight Test1 view
Search.searchable true view
EnterpriseSearch.enabled true view
EnterpriseSearch.nlp.semanticDomain #ANALYTICS view
Metadata.allowExtensions true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY carrid spfli carrid Carrier
KEY connid spfli connid Flight Number
carrname scarr carrname Carrier
cityfrom spfli cityfrom Departure City
cityto spfli cityto Destination City
DepTime spfli deptime Departure 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 FINKET_S_SFLIGHT_19.
-- 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: FINKET_SFL19

CREATE VIEW FINKET_S_SFLIGHT_19 AS
SELECT
  spfli.carrid AS carrid,
  spfli.connid AS connid,
  scarr.carrname AS carrname,
  spfli.cityfrom AS cityfrom,
  spfli.cityto AS cityto,
  spfli.deptime AS DepTime
FROM spfli
LEFT OUTER JOIN scarr ON /* join condition not captured in parsed metadata */
;

Learn More