FPMT_AIRPLANE2

DDL: FPMT_AIRPLANE2 SQL: FPMT_VAIRPLANE2 Type: view Package: BW_REPORTING_FPM_TESTS
18 Fields 1 Data Sources

Airplane

FPMT_AIRPLANE2 is a CDS View of category Dimension that provides data about "Airplane" in SAP S/4HANA. It reads from 1 data source (FPMT_AIRPLANE) and exposes 18 fields with key field Planetype. Part of development package BW_REPORTING_FPM_TESTS.

Data Sources (1)

SourceAliasJoin Type
FPMT_AIRPLANE FPMT_AIRPLANE from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName FPMT_VAIRPLANE2 view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Airplane view
Analytics.dataCategory #DIMENSION view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY Planetype FPMT_AIRPLANE Planetype Planetype
Seatsmax FPMT_AIRPLANE Seatsmax Max. Seats
Consum FPMT_AIRPLANE Consum Consumption
ConUnit FPMT_AIRPLANE ConUnit Unit
Tankcap FPMT_AIRPLANE Tankcap Fuel
CapUnit FPMT_AIRPLANE CapUnit Unit of measure
Weight FPMT_AIRPLANE Weight Weight Used
WeiUnit FPMT_AIRPLANE WeiUnit Unit of measure
Span FPMT_AIRPLANE Span Span
SpanUnit FPMT_AIRPLANE SpanUnit Unit
Leng FPMT_AIRPLANE Leng No. of Characters
LengUnit FPMT_AIRPLANE LengUnit Unit
OpSpeed FPMT_AIRPLANE OpSpeed Speed
SpeedUnit FPMT_AIRPLANE SpeedUnit Unit
Producer FPMT_AIRPLANE Producer Producer ID
SeatsmaxB FPMT_AIRPLANE SeatsmaxB Max. Capacity Bus.
SeatsmaxF FPMT_AIRPLANE SeatsmaxF Max. Capacity 1st
_Hier _Hier

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_AIRPLANE2.
-- 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_VAIRPLANE2

CREATE VIEW FPMT_AIRPLANE2 AS
SELECT
  FPMT_AIRPLANE.Planetype AS Planetype,
  FPMT_AIRPLANE.Seatsmax AS Seatsmax,
  FPMT_AIRPLANE.Consum AS Consum,
  FPMT_AIRPLANE.ConUnit AS ConUnit,
  FPMT_AIRPLANE.Tankcap AS Tankcap,
  FPMT_AIRPLANE.CapUnit AS CapUnit,
  FPMT_AIRPLANE.Weight AS Weight,
  FPMT_AIRPLANE.WeiUnit AS WeiUnit,
  FPMT_AIRPLANE.Span AS Span,
  FPMT_AIRPLANE.SpanUnit AS SpanUnit,
  FPMT_AIRPLANE.Leng AS Leng,
  FPMT_AIRPLANE.LengUnit AS LengUnit,
  FPMT_AIRPLANE.OpSpeed AS OpSpeed,
  FPMT_AIRPLANE.SpeedUnit AS SpeedUnit,
  FPMT_AIRPLANE.Producer AS Producer,
  FPMT_AIRPLANE.SeatsmaxB AS SeatsmaxB,
  FPMT_AIRPLANE.SeatsmaxF AS SeatsmaxF
FROM FPMT_AIRPLANE
;

Learn More