FPMT_AIRPLANE

DDL: FPMT_AIRPLANE SQL: FPMT_VAIRPLANE Type: view Package: BW_REPORTING_FPM_TESTS
17 Fields 1 Data Sources

Airplane

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

Data Sources (1)

SourceAliasJoin Type
saplane saplane from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName FPMT_VAIRPLANE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Airplane view
Analytics.dataCategory #DIMENSION view
ObjectModel.representativeKey Planetype view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Planetype planetype Planetype
Seatsmax seatsmax Max. Seats
Consum consum Consumption
ConUnit con_unit Unit
Tankcap tankcap Fuel
CapUnit cap_unit Unit
Weight weight Weight Used
WeiUnit wei_unit Unit of measure
Span span Span
SpanUnit span_unit Unit
Leng leng No. of Characters
LengUnit leng_unit Unit
OpSpeed op_speed Speed
SpeedUnit speed_unit Unit
Producer producer Producer ID
SeatsmaxB seatsmax_b Max. Capacity Bus.
SeatsmaxF seatsmax_f Max. Capacity 1st

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_AIRPLANE.
-- 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_VAIRPLANE

CREATE VIEW FPMT_AIRPLANE AS
SELECT
  Planetype,
  Seatsmax,
  Consum,
  con_unit AS ConUnit,
  Tankcap,
  cap_unit AS CapUnit,
  Weight,
  wei_unit AS WeiUnit,
  Span,
  span_unit AS SpanUnit,
  Leng,
  leng_unit AS LengUnit,
  op_speed AS OpSpeed,
  speed_unit AS SpeedUnit,
  Producer,
  seatsmax_b AS SeatsmaxB,
  seatsmax_f AS SeatsmaxF
FROM saplane
;

Learn More