FPMT_AIRLINE

DDL: FPMT_AIRLINE SQL: FPMT_VAIRLINE Type: view
4 Fields 1 Data Sources

Airline

FPMT_AIRLINE is a CDS View of category Dimension that provides data about "Airline" in SAP S/4HANA. It reads from 1 data source (scarr) and exposes 4 fields with key field Airline.

Data Sources (1)

SourceAliasJoin Type
scarr scarr from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName FPMT_VAIRLINE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Airline view
Analytics.dataCategory #DIMENSION view
ObjectModel.representativeKey Airline view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Airline carrid Carrier
Carrname carrname Carrier
Currcode currcode Currency (SAP)
Url

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_AIRLINE.
-- 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_VAIRLINE

CREATE VIEW FPMT_AIRLINE AS
SELECT
  carrid AS Airline,
  Carrname,
  Currcode,
  left(url, 250) AS Url
FROM scarr
;

Learn More