SFLCONN - Flight connection offered by travel agency
Flight connection offered by travel agency information is stored in SAP table SFLCONN.
It is part of development package SAPBC_TRAVELAGENCY_CONN in software component BC-DWB-TND. This development package consists of objects that can be grouped under "Flight Data Model - Travel Agency - Connection".
It is part of development package SAPBC_TRAVELAGENCY_CONN in software component BC-DWB-TND. This development package consists of objects that can be grouped under "Flight Data Model - Travel Agency - Connection".
Fields for table SFLCONN
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | S_MANDT | CLNT | 3 | T000 |
| AGENCYNUM | Travel Agency Number | X | S_AGNCYNUM | NUMC | 8 | STRAVELAG |
| FLCONN | Flight connection number at travel agency | X | S_FLCONN | NUMC | 4 | |
| COUNTRYFR | Country/Region Key | LAND1 | CHAR | 3 | SGEOCITY | |
| CITYFROM | Departure city | S_FROM_CIT | CHAR | 20 | SGEOCITY | |
| AIRPFROM | Departure airport | S_FROMAIRP | CHAR | 3 | SAIRPORT | |
| COUNTRYTO | Country/Region Key | LAND1 | CHAR | 3 | SGEOCITY | |
| CITYTO | Arrival city | S_TO_CITY | CHAR | 20 | SGEOCITY | |
| AIRPTO | Destination airport | S_TOAIRP | CHAR | 3 | SAIRPORT | |
| FLTIME | Flight time | S_FLTIME | INT4 | 4 | ||
| DEPTIME | Departure time | S_DEP_TIME | TIMS | 6 | ||
| ARRTIME | Arrival time | S_ARR_TIME | TIMS | 6 | ||
| DISTANCE | Distance | S_DISTANCE | QUAN | 5 | ||
| DISTID | Mass unit of distance (kms, miles) | S_DISTID | UNIT | 3 | * | |
| PERIOD | Arrival n day(s) later | S_PERIOD | INT1 | 1 |