SAP ABAP Table SFLCONN (Flight connection offered by travel agency)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB (Application Component) ABAP Workbench, Java IDE and Infrastructure
     ⤷ SAPBC_TRAVELAGENCY_CONN (Package) Flight Data Model - Travel Agency - Connection
Basic Data
Table Category TRANSP    Transparent table 
Transparent table SFLCONN   Table Relationship Diagram
Short Description Flight connection offered by travel agency    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT S_MANDT MANDT CLNT 3   0   Client T000
2 AGENCYNUM S_AGNCYNUM S_BUSPANUM NUMC 8   0   Travel Agency Number STRAVELAG
3 FLCONN S_FLCONN S_FLCONN NUMC 4   0   Flight connection number at travel agency  
4 COUNTRYFR LAND1 LAND1 CHAR 3   0   Country Key SGEOCITY
5 CITYFROM S_FROM_CIT S_CITY CHAR 20   0   Departure city SGEOCITY
6 AIRPFROM S_FROMAIRP S_AIRPID CHAR 3   0   Departure airport SAIRPORT
7 COUNTRYTO LAND1 LAND1 CHAR 3   0   Country Key SGEOCITY
8 CITYTO S_TO_CITY S_CITY CHAR 20   0   Arrival city SGEOCITY
9 AIRPTO S_TOAIRP S_AIRPID CHAR 3   0   Destination airport SAIRPORT
10 FLTIME S_FLTIME S_DURA INT4 10   0   Flight time  
11 DEPTIME S_DEP_TIME S_TIME TIMS 6   0   Departure time  
12 ARRTIME S_ARR_TIME S_TIME TIMS 6   0   Arrival time  
13 DISTANCE S_DISTANCE S_DISTANCE QUAN 9   4   Distance  
14 DISTID S_DISTID MEINS UNIT 3   0   Mass unit of distance (kms, miles) *
15 PERIOD S_PERIOD INT1 INT1 3   0   Arrival n day(s) later  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 SFLCONN AGENCYNUM STRAVELAG AGENCYNUM    
2 SFLCONN AIRPFROM SAIRPORT ID REF 1 CN
3 SFLCONN AIRPTO SAIRPORT ID REF 1 CN
4 SFLCONN CITYFROM SGEOCITY CITY REF 1 CN
5 SFLCONN CITYTO SGEOCITY CITY REF 1 CN
6 SFLCONN COUNTRYFR SGEOCITY COUNTRY REF 1 CN
7 SFLCONN COUNTRYTO SGEOCITY COUNTRY REF 1 CN
8 SFLCONN MANDT T000 MANDT    
History
Last changed by/on SAP  20130604 
SAP Release Created in 610