Fdt_Test_Plane_Type_Cds
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)
| Source | Alias | Join Type |
|---|---|---|
| saplane | saplane | from |
Annotations (5)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
;
Learn More
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA