SAPLANE

Transparent Table Application Table
18 Fields 2 CDS Views

Flugzeug

SAPLANE is an SAP database table in S/4HANA. Flugzeug. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
Fdt_Test_Plane_Type_Cds view from Plane Type
FPMT_AIRPLANE view from Airplane

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt s_mandt Client
KEY planetype s_planetye Plane Type
seatsmax s_seatsmax Max. Capacity Econ.
consum s_consum Consumption
con_unit s_conunit Unit
tankcap s_capacity Fuel
cap_unit s_capunit Unit
weight s_plan_wei Weight
wei_unit s_wei_unit Unit of measure
span s_span Span
span_unit s_unit Unit
leng s_length Length of plane
leng_unit s_unit Unit
op_speed s_speed Speed
speed_unit s_unit Unit
producer s_prod Manufacturer
seatsmax_b s_smax_b Max. Capacity Bus.
seatsmax_f s_smax_f Max. Capacity 1st

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Flugzeug
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SAPLANE (
    MANDT,       -- Client [s_mandt]
    PLANETYPE,   -- Plane Type [s_planetye]
    SEATSMAX,    -- Max. Capacity Econ. [s_seatsmax]
    CONSUM,      -- Consumption [s_consum]
    CON_UNIT,    -- Unit [s_conunit]
    TANKCAP,     -- Fuel [s_capacity]
    CAP_UNIT,    -- Unit [s_capunit]
    WEIGHT,      -- Weight [s_plan_wei]
    WEI_UNIT,    -- Unit of measure [s_wei_unit]
    SPAN,        -- Span [s_span]
    SPAN_UNIT,   -- Unit [s_unit]
    LENG,        -- Length of plane [s_length]
    LENG_UNIT,   -- Unit [s_unit]
    OP_SPEED,    -- Speed [s_speed]
    SPEED_UNIT,  -- Unit [s_unit]
    PRODUCER,    -- Manufacturer [s_prod]
    SEATSMAX_B,  -- Max. Capacity Bus. [s_smax_b]
    SEATSMAX_F,  -- Max. Capacity 1st [s_smax_f]
    PRIMARY KEY (MANDT, PLANETYPE)
);

Learn More