SPFLI

Transparent Table Application Table
16 Fields 52 CDS Views

Flugplan

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

CDS Views using this table (52)

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

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