SPFLI
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| CdsFrwk_Spcl_Functions | view | inner | cds having currency and unit conversion | |
| demo_cds_aggregate | view | from | CDS DDIC-based view, aggregates | |
| demo_cds_anno_inheritance_2 | view_entity | from | CDS view entity, inherited and derived annotations | |
| demo_cds_anno_null_value_1 | view_entity | from | CDS view entity, null values | |
| demo_cds_assoc_spfli | view_entity | from | CDS view entity, association | |
| demo_cds_assoc_spfli_scarr | view_entity | from | CDS view entity, association | |
| demo_cds_association | view | from | CDS DDIC-based view, simple association | |
| DEMO_CDS_ASSOCIATION_VE | view_entity | from | CDS view entity, simple association | |
| DEMO_CDS_CAR_NUMERIC | view_entity | from | CDS view entity, numeric cardinality | |
| DEMO_CDS_FIELDS_ASSOC_VE | view_entity | from | CDS view entity, association | |
| DEMO_CDS_FLIGHT_TREE_SOURCE | view | union | CDS DDIC-based view, self association for flight tree | |
| DEMO_CDS_FLIGHTS | view_entity | from | CDS DDIC-based view, simple join | |
| demo_cds_join1 | view | from | CDS DDIC-based view, association | |
| DEMO_CDS_JOIN1_VE | view_entity | from | CDS view entity, association | |
| demo_cds_join2 | view | from | CDS DDIC-based view, association | |
| DEMO_CDS_JOIN2_VE | view_entity | from | CDS view entity, association | |
| 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 | CDS view entity, input parameters | |
| demo_cds_scarr_spfli | view | from | CDS DDIC-based view, simple join | |
| DEMO_CDS_SCARR_SPFLI_2 | view_entity | from | CDS view entity, simple join | |
| DEMO_CDS_SCARR_SPFLI_VE | view_entity | from | CDS view entity, simple join | |
| demo_cds_searched_case | view | from | CDS DDIC-based view, complex case distinction | |
| demo_cds_searched_case_ve | view_entity | from | CDS view entity, complex case distinction | |
| DEMO_CDS_SELECT_LIST_V1 | view | from | CDS demo for ABAP Documentaiton | |
| demo_cds_spfli | view | from | CDS DDIC-based view, simple select of one database table | |
| demo_cds_spfli_client_0 | view | from | CDS DDIC-based view, without client field | |
| demo_cds_spfli_client_0a | view | from | CDS DDIC-based view, without client field | |
| demo_cds_spfli_client_1 | view | from | CDS DDIC-based view, with client field | |
| demo_cds_spfli_client_1a | view | from | CDS DDIC-based view, with client field | |
| demo_cds_spfli_client_2 | view | from | CDS DDIC-based view, cross-client, no client column | |
| demo_cds_spfli_client_3 | view | from | CDS DDIC-based view, cross-client, with client column | |
| DEMO_CDS_SPFLI_ENTITY | view_entity | from | CDS view entity, simple select of one database table | |
| 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 | CDS view entity with non-unique key | |
| DEMO_CDS_VIEW_KEY | view | from | CDS view with non-unique key | |
| DEMO_RAP_INSTANCE_FILTER | view_entity | from | CDS view, managed instance filter | |
| DEMO_SALES_CDS_SALES_ORDER_VE | view_entity | from | CDS view entity, sales order, example for SELECT, element | |
| 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 | |
| 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 | Flight Model: Schedules | |
| SADL_V_ExpVoc_Connection | view | from | Connection | |
| SADL_V_ExpVoc_Connection_Par | view | from | Connection |
Fields (16)
| Key | Field | Data Element | Description |
|---|---|---|---|
| KEY | mandt | s_mandt | |
| KEY | carrid | s_carr_id | |
| KEY | connid | s_conn_id | |
| countryfr | land1 | ||
| cityfrom | s_from_cit | ||
| airpfrom | s_fromairp | ||
| countryto | land1 | ||
| cityto | s_to_city | ||
| airpto | s_toairp | ||
| fltime | s_fltime | ||
| deptime | s_dep_time | ||
| arrtime | s_arr_time | ||
| distance | s_distance | ||
| distid | s_distid | ||
| fltype | s_fltype | ||
| period | s_period |