SAP WDR_TEST_SPFLI3 Flight Schedule Table
Overview
WDR_TEST_SPFLI3 is a standard SAP S/4HANA table that stores Flight Schedule data. There are total 16 fields in the WDR_TEST_SPFLI3 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WDR_TEST_SPFLI3 belongs to Web Dynpro ABAP (BC-WD-ABA) module and is located in the package Web Dynpro: Tests (SWDP_TEST).
In addition, following links provide an overview of foreign key relationships, if any, that link WDR_TEST_SPFLI3 to other SAP tables and standard CDS views available based on WDR_TEST_SPFLI3 table in S/4HANA 2020.
Techincal Settings of WDR_TEST_SPFLI3
Below are technical details of the table WDR_TEST_SPFLI3
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WDR_TEST_SPFLI3 Fields
The following table gives you an overview of the fields available in WDR_TEST_SPFLI3
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | S_MANDT | T000 | CLNT | 3 |
| CARRID | Airline Code | S_CARR_ID | SCARR | CHAR | 3 |
| CONNID | Flight Connection Number | S_CONN_ID | * | NUMC | 4 |
| COUNTRYFR | Country/Region Key | LAND1 | SGEOCITY | CHAR | 3 |
| CITYFROM | Departure city | S_FROM_CIT | SGEOCITY | CHAR | 20 |
| AIRPFROM | Departure airport | S_FROMAIRP | SAIRPORT | CHAR | 3 |
| COUNTRYTO | Country/Region Key | LAND1 | SGEOCITY | CHAR | 3 |
| CITYTO | Arrival city | S_TO_CITY | SGEOCITY | CHAR | 20 |
| AIRPTO | Destination airport | S_TOAIRP | SAIRPORT | CHAR | 3 |
| FLTIME | Flight time | S_FLTIME | INT4 | 10 | |
| DEPTIME | Departure time | S_DEP_TIME | TIMS | 6 | |
| ARRTIME | Arrival time | S_ARR_TIME | TIMS | 6 | |
| DISTANCE | Distance | S_DISTANCE | QUAN | 9 | |
| DISTID | Mass unit of distance (kms miles) | S_DISTID | * | UNIT | 3 |
| FLTYPE | Flight type | S_FLTYPE | CHAR | 1 | |
| PERIOD | Arrival n day(s) later | S_PERIOD | INT1 | 3 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WDR_TEST_SPFLI3
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WDR_TEST_SPFLI3 | AIRPFROM | 1: CN | SAIRPORT |
| WDR_TEST_SPFLI3 | AIRPTO | 1: CN | SAIRPORT |
| WDR_TEST_SPFLI3 | CARRID | 1: CN | SCARR |
| WDR_TEST_SPFLI3 | CITYFROM | 1: CN | SGEOCITY |
| WDR_TEST_SPFLI3 | CITYTO | 1: CN | SGEOCITY |
| WDR_TEST_SPFLI3 | COUNTRYFR | 1: CN | SGEOCITY |
| WDR_TEST_SPFLI3 | COUNTRYTO | 1: CN | SGEOCITY |
| WDR_TEST_SPFLI3 | MANDT | : | T000 |