SAP ABAP Table SPFLI (Flight schedule)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB (Application Component) ABAP Workbench, Java IDE and Infrastructure
     ⤷ SAPBC_DATAMODEL (Package) Data Model: BC_TRAVEL for Workbench Training and Docu.
Basic Data
Table Category TRANSP    Transparent table 
Transparent table SPFLI   Table Relationship Diagram
Short Description Flight schedule    
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 CARRID S_CARR_ID S_CARR_ID CHAR 3   0   Airline Code SCARR
3 CONNID S_CONN_ID S_CONN_ID NUMC 4   0   Flight Connection Number  
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 FLTYPE S_FLTYPE S_FLTYPE CHAR 1   0   Flight type  
16 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 SPFLI AIRPFROM SAIRPORT ID REF 1 CN
2 SPFLI AIRPTO SAIRPORT ID REF 1 CN
3 SPFLI CARRID SCARR CARRID KEY 1 CN
4 SPFLI CITYFROM SGEOCITY CITY REF 1 CN
5 SPFLI CITYTO SGEOCITY CITY REF 1 CN
6 SPFLI COUNTRYFR SGEOCITY COUNTRY REF 1 CN
7 SPFLI COUNTRYTO SGEOCITY COUNTRY REF 1 CN
8 SPFLI MANDT T000 MANDT    
History
Last changed by/on SAP  20130604 
SAP Release Created in