SPFLI

Transparent Table Application Table
16 Fields 53 CDS Views

Flight schedule

SPFLI is an SAP database table in S/4HANA. Flight schedule. It contains 16 fields. 53 CDS views read from this table.

CDS Views using this table (53)

ViewTypeJoinVDMDescription
CdsFrwk_Spcl_Functions view inner cds having currency and unit conversion
demo_cds_aggregate view from
demo_cds_anno_inheritance_2 view_entity from
demo_cds_anno_null_value_1 view_entity from
demo_cds_assoc_spfli view_entity from
demo_cds_assoc_spfli_scarr view_entity from
demo_cds_association view from
DEMO_CDS_ASSOCIATION_VE view_entity from
DEMO_CDS_CAR_NUMERIC view_entity from CDS view entity, numeric cardinality
DEMO_CDS_FIELDS_ASSOC_VE view_entity from
DEMO_CDS_FLIGHT_TREE_SOURCE view union
DEMO_CDS_FLIGHTS view_entity from
demo_cds_join1 view from
DEMO_CDS_JOIN1_VE view_entity from
demo_cds_join2 view from
DEMO_CDS_JOIN2_VE view_entity from
DEMO_CDS_LITERALS_VE view_entity from CDS View Entity with Literals
demo_cds_original_view view from Further information about the CDS entity
DEMO_CDS_ORIGINAL_VIEW_VE view_entity from Further information about the CDS entity
Demo_Cds_Param_View_Entity view_entity from View Entity with Input Parameters
demo_cds_parameters view_entity from Demo für Parameter-View
demo_cds_parameters_ve view_entity from
demo_cds_scarr_spfli view from
DEMO_CDS_SCARR_SPFLI_2 view_entity from
DEMO_CDS_SCARR_SPFLI_VE view_entity from
demo_cds_searched_case view from
demo_cds_searched_case_ve view_entity from
DEMO_CDS_SELECT_LIST_V1 view from
demo_cds_spfli view from
demo_cds_spfli_client_0 view from
demo_cds_spfli_client_0a view from
demo_cds_spfli_client_1 view from
demo_cds_spfli_client_1a view from
demo_cds_spfli_client_2 view from
demo_cds_spfli_client_3 view from
DEMO_CDS_SPFLI_ENTITY view_entity from
DEMO_CDS_SPFLI_VE view_entity from CDS view entity that selects from spfli
demo_cds_spfli4graph view_entity from SPFLI View for AMDP Graph
DEMO_CDS_VIEW_ENTITY_KEY view_entity from
DEMO_CDS_VIEW_KEY view from
DEMO_RAP_INSTANCE_FILTER view_entity from CDS view, managed instance filter
DEMO_SALES_CDS_SALES_ORDER_VE view_entity from
DEMO_SPFLI_FLIGHTS view_entity from spfli view
Fdt_Test_Pfli_Cds view from Flight schedule
Fdt_Test_Pfli_P1_Cds view from Pfli with quantity parameter
Fdt_Test_Pfli_P2_Cds view from Pfli with carrid and deptime parameters
FINKET_S_SFLIGHT_19 view from Flight Test1
FPMT_SCHEDULE view from Flight Schedule
S_Connections view from Flight Connections
SADL_AUNITItem_11 view from RESTful ABAP: CDS for Testing (11)
SADL_SB_AUNIT_SPFLI view from
SADL_V_ExpVoc_Connection view from Connection
SADL_V_ExpVoc_Connection_Par view from Connection

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt S_MANDT Client
KEY carrid S_CARR_ID Airline
KEY connid S_CONN_ID Flight Number
countryfr LAND1 Country/Reg.
cityfrom S_FROM_CIT Depart.city
airpfrom S_FROMAIRP Dep. airport
countryto LAND1 Country/Reg.
cityto S_TO_CITY Arrival city
airpto S_TOAIRP Dest. airport
fltime S_FLTIME Flight time
deptime S_DEP_TIME Departure
arrtime S_ARR_TIME Arrival Time
distance S_DISTANCE Distance
distid S_DISTID Distance in
fltype S_FLTYPE Charter
period S_PERIOD n day(s) later

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 schedule
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SPFLI (
    MANDT,      -- Client [S_MANDT]
    CARRID,     -- Airline [S_CARR_ID]
    CONNID,     -- Flight Number [S_CONN_ID]
    COUNTRYFR,  -- Country/Reg. [LAND1]
    CITYFROM,   -- Depart.city [S_FROM_CIT]
    AIRPFROM,   -- Dep. airport [S_FROMAIRP]
    COUNTRYTO,  -- Country/Reg. [LAND1]
    CITYTO,     -- Arrival city [S_TO_CITY]
    AIRPTO,     -- Dest. airport [S_TOAIRP]
    FLTIME,     -- Flight time [S_FLTIME]
    DEPTIME,    -- Departure [S_DEP_TIME]
    ARRTIME,    -- Arrival Time [S_ARR_TIME]
    DISTANCE,   -- Distance [S_DISTANCE]
    DISTID,     -- Distance in [S_DISTID]
    FLTYPE,     -- Charter [S_FLTYPE]
    PERIOD,     -- n day(s) later [S_PERIOD]
    PRIMARY KEY (MANDT, CARRID, CONNID)
);

Learn More