SDSHSFLIGHT

Transparent Table Application Table
14 Fields 1 CDS Views

Flug

SDSHSFLIGHT is an SAP database table in S/4HANA. Flug. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
sdsh_sflight_cds_view view from cds view for sflight for dcl

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt s_mandt Client
KEY carrid s_carr_id Airline
KEY connid s_conn_id Flight Number
KEY fldate s_date Date
price s_price Airfare
currency s_currcode Airline Currency
planetype s_planetye Plane Type
seatsmax s_seatsmax Max. Capacity Econ.
seatsocc s_seatsocc Occupied Econ.
paymentsum s_sum Total
seatsmax_b s_smax_b Max. Capacity Bus.
seatsocc_b s_socc_b Occupied Bus.
seatsmax_f s_smax_f Max. Capacity 1st
seatsocc_f s_socc_f Occupied 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.

-- Flug
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDSHSFLIGHT (
    MANDT,       -- Client [s_mandt]
    CARRID,      -- Airline [s_carr_id]
    CONNID,      -- Flight Number [s_conn_id]
    FLDATE,      -- Date [s_date]
    PRICE,       -- Airfare [s_price]
    CURRENCY,    -- Airline Currency [s_currcode]
    PLANETYPE,   -- Plane Type [s_planetye]
    SEATSMAX,    -- Max. Capacity Econ. [s_seatsmax]
    SEATSOCC,    -- Occupied Econ. [s_seatsocc]
    PAYMENTSUM,  -- Total [s_sum]
    SEATSMAX_B,  -- Max. Capacity Bus. [s_smax_b]
    SEATSOCC_B,  -- Occupied Bus. [s_socc_b]
    SEATSMAX_F,  -- Max. Capacity 1st [s_smax_f]
    SEATSOCC_F,  -- Occupied 1st [s_socc_f]
    PRIMARY KEY (MANDT, CARRID, CONNID, FLDATE)
);

Learn More