SDSHSFLIGHT

Transparent Table Application Table
14 Fields 1 CDS Views

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

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