SAP Table SFLCONN
Flight connection offered by travel agency
SFLCONN (Flight connection offered by travel agency) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link SFLCONN to other SAP tables.
SFLCONN table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | S_MANDT | T000 | CLNT | 3 | 0 | ||
| AGENCYNUM | Travel Agency Number | S_AGNCYNUM | STRAVELAG | NUMC | 8 | 0 | ||
| FLCONN | Flight connection number at travel agency | S_FLCONN | NUMC | 4 | 0 | |||
| COUNTRYFR | Country Key | LAND1 | SGEOCITY | CHAR | 3 | 0 | ||
| CITYFROM | Departure city | S_FROM_CIT | SGEOCITY | CHAR | 20 | 0 | ||
| AIRPFROM | Departure airport | S_FROMAIRP | SAIRPORT | CHAR | 3 | 0 | ||
| COUNTRYTO | Country Key | LAND1 | SGEOCITY | CHAR | 3 | 0 | ||
| CITYTO | Arrival city | S_TO_CITY | SGEOCITY | CHAR | 20 | 0 | ||
| AIRPTO | Destination airport | S_TOAIRP | SAIRPORT | CHAR | 3 | 0 | ||
| FLTIME | Flight time | S_FLTIME | INT4 | 10 | 0 | |||
| DEPTIME | Departure time | S_DEP_TIME | TIMS | 6 | 0 | |||
| ARRTIME | Arrival time | S_ARR_TIME | TIMS | 6 | 0 | |||
| DISTANCE | Distance | S_DISTANCE | QUAN | 9 | 4 | |||
| DISTID | Mass unit of distance (kms, miles) | S_DISTID | UNIT | 3 | 0 | |||
| PERIOD | Arrival n day(s) later | S_PERIOD | INT1 | 3 | 0 | |||
SFLCONN foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| SFLCONN | AGENCYNUM | SFLCONN | MANDT | STRAVELAG | Travel agency | MANDT |
| SFLCONN | AGENCYNUM | SFLCONN | AGENCYNUM | STRAVELAG | Travel agency | AGENCYNUM |
| SFLCONN | AIRPFROM | SFLCONN | MANDT | SAIRPORT | Airports | MANDT |
| SFLCONN | AIRPFROM | SFLCONN | AIRPFROM | SAIRPORT | Airports | ID |
| SFLCONN | AIRPTO | SFLCONN | AIRPTO | SAIRPORT | Airports | ID |
| SFLCONN | AIRPTO | SFLCONN | MANDT | SAIRPORT | Airports | MANDT |
| SFLCONN | CITYFROM | SFLCONN | MANDT | SGEOCITY | Geographical position of a city | MANDT |
| SFLCONN | CITYFROM | SFLCONN | CITYFROM | SGEOCITY | Geographical position of a city | CITY |
| SFLCONN | CITYFROM | SFLCONN | COUNTRYFR | SGEOCITY | Geographical position of a city | COUNTRY |
| SFLCONN | CITYTO | SFLCONN | CITYTO | SGEOCITY | Geographical position of a city | CITY |
| SFLCONN | CITYTO | SFLCONN | COUNTRYTO | SGEOCITY | Geographical position of a city | COUNTRY |
| SFLCONN | CITYTO | SFLCONN | MANDT | SGEOCITY | Geographical position of a city | MANDT |
| SFLCONN | COUNTRYFR | SFLCONN | MANDT | SGEOCITY | Geographical position of a city | MANDT |
| SFLCONN | COUNTRYFR | SFLCONN | CITYFROM | SGEOCITY | Geographical position of a city | CITY |
| SFLCONN | COUNTRYFR | SFLCONN | COUNTRYFR | SGEOCITY | Geographical position of a city | COUNTRY |
| SFLCONN | COUNTRYTO | SFLCONN | CITYTO | SGEOCITY | Geographical position of a city | CITY |
| SFLCONN | COUNTRYTO | SFLCONN | COUNTRYTO | SGEOCITY | Geographical position of a city | COUNTRY |
| SFLCONN | COUNTRYTO | SFLCONN | MANDT | SGEOCITY | Geographical position of a city | MANDT |
| SFLCONN | MANDT | SFLCONN | MANDT | T000 | Clients | MANDT |
