SAPLANE

Transparent Table Application Table
18 Fields 2 CDS Views

Plane

SAPLANE is an SAP database table in S/4HANA. Plane. 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.

-- Plane
-- 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