Fdt_Test_Plane_Type_Cds

DDL: FDT_TEST_PLANE_TYPE_CDS SQL: FDT_TEST_PL_TYPE Type: view

Plane Type

Fdt_Test_Plane_Type_Cds is a CDS View that provides data about "Plane Type" in SAP S/4HANA. It reads from 1 data source (saplane) and exposes 18 fields with key fields mandt, planetype.

Data Sources (1)

SourceAliasJoin Type
saplane saplane from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName FDT_TEST_PL_TYPE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Plane Type view
Search.searchable true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY mandt saplane mandt Editing Client
KEY planetype saplane planetype Planetype
seatsmax saplane seatsmax Max. Seats
consum saplane consum Consumption
con_unit saplane con_unit Fuel Unit
tankcap saplane tankcap Fuel
cap_unit saplane cap_unit Capacity Unit
weight saplane weight Weight Used
wei_unit saplane wei_unit Weight Unit
span saplane span Span
span_unit saplane span_unit Span Unit
leng saplane leng No. of Characters
leng_unit saplane leng_unit Length of Plane Unit
op_speed saplane op_speed Speed
speed_unit saplane speed_unit Speed Unit
producer saplane producer Producer ID
seatsmax_b saplane seatsmax_b Max. Capacity Bus.
seatsmax_f saplane 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 Fdt_Test_Plane_Type_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_PL_TYPE

CREATE VIEW Fdt_Test_Plane_Type_Cds AS
SELECT
  saplane.mandt AS mandt,
  saplane.planetype AS planetype,
  saplane.seatsmax AS seatsmax,
  saplane.consum AS consum,
  saplane.con_unit AS con_unit,
  saplane.tankcap AS tankcap,
  saplane.cap_unit AS cap_unit,
  saplane.weight AS weight,
  saplane.wei_unit AS wei_unit,
  saplane.span AS span,
  saplane.span_unit AS span_unit,
  saplane.leng AS leng,
  saplane.leng_unit AS leng_unit,
  saplane.op_speed AS op_speed,
  saplane.speed_unit AS speed_unit,
  saplane.producer AS producer,
  saplane.seatsmax_b AS seatsmax_b,
  saplane.seatsmax_f AS seatsmax_f
FROM saplane
;