SFLIGHT

Transparent Table Application Table
14 Fields 57 CDS Views

Flight

SFLIGHT is an SAP database table in S/4HANA. Flight. It contains 14 fields. 57 CDS views read from this table.

CDS Views using this table (57)

ViewTypeJoinVDMDescription
CDS_TDAI_ENTITY_HAVING view_entity from
CDS_TDAI_TEST_GEN_MUL_EXPR view_entity from CDS for test generation using AI demo
Cds_With_Dcl_Pfcg view from CDS based on DCL with PFCG conditions
cds_with_session_variable view from cds having session variable
CdsFrwk_Spcl_Functions view from cds having currency and unit conversion
Ddls_Api_State_Test view from test
Demo_Cds_Cached_View view from
DEMO_CDS_COMPARE_FILTER_V1 view from CDS view, compare filter annotation
DEMO_CDS_EXCEPT view_entity from CDS view entity, set operator EXCEPT
DEMO_CDS_FULL_BUFFERED_VIEW view_entity from
DEMO_CDS_GET_NUMERIC_VALUE view_entity from CDS view entity, GET_NUMERIC_VALUE
DEMO_CDS_INTERSECT view_entity from CDS view entity, set operator INTERSECT
DEMO_CDS_SCALAR_USE_RATIO view_entity from CDS view entity, scalar func
demo_cds_sflight view from
DEMO_CDS_SFLIGHT_VE view_entity from CDS view entity, sflight
demo_cds_simple_root_entity view from
DEMO_CDS_VIEW_ENTITY_GROUP_BY view_entity from
DEMO_CDS_VIEW_ENTITY_HAVING view_entity from
DEMO_CDS_WITH_DCL_PFCG_1 view from CDS based on DCL with PFCG
Demo_Rap_Instance_Filter_Ch view_entity from Child entity, managed instance filter
DEMO_SFLIGHT view_entity from
Fdt_Test_Flight_Al_Cds view from CDS for testing alias , sflight
FDT_TEST_FLIGHT_CDS view from SFLIGHT CDS
Fdt_Test_Flight_Ne_Cds view from CDS with Associations for Testing Negative (wrong values)
Fdt_Test_Flt_P1_Cds view from Flight with carrid parameter
Fdt_Test_Flt_P2_Cds view from Flight with amount parameter
Fdt_Test_Flt_P3_Cds view from Flight with native parameters
Fdt_Test_Flt_P4_Cds view from Flight w unsupported native parameters
Fdt_Test_Flt_P5_Cds view from Flight with carrid and fldate parameters
FDT_TEST_SFLIGHT view from SFLIGHT for test purposes
FPMT_FLIGHT view from Flight
mwk_flights view from
S_Flights view from Flights
SADL_AUNITSubItem_111 view from RESTful ABAP: CDS for Testing (111)
SADL_GW_MDE_Alias view from test alias
SADL_GW_MDE_Analytics view from test analytics scenario
SADL_GW_MDE_AX view from Auto Exposure Via @Odata.Publish: true
SADL_GW_MDE_DataField view from test datafield
SADL_GW_MDE_DATAPOINT view from test datapoint annotations
SADL_GW_MDE_ENTITY view from entity level annotations
SADL_GW_MDE_INLINE view from test inline annotations
SADL_GW_MDE_Merge_Datafield view from test merge datafield
SADL_GW_MDE_Merge_Entity view from test
SADL_GW_MDE_Merge_Facets view from test merge facets
SADL_GW_MDE_Merge_Inline view from test
SADL_GW_MDE_Merge_SelectionFld view from test merge selectionfields
sadl_sb_aunit_ddic_assoc view from
sadl_sb_aunit_sflight view from
Sadl_V_Cds_Db_Cache view from Test entity for DB cache control
sadl_v_cds_sflight view from
sadl_v_cds_sflight3 view from
Sadl_V_CDSAssocAlias view from Aliasing for Associations
SADL_V_EXP_NO_KEY view from
SADL_V_EXPOSURE view from
SADL_V_NO_KEY view from
salv_ida_test_cds_sflight view from
Spak_Cls_Ddl_Test_View view from View used by unit tests

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.

-- Flight
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SFLIGHT (
    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