SAP ABAP Table CRMS_UIF_TRAVEL_FLIGHT_DB_2 (Structure to store SPFLI)
Hierarchy
☛ WEBCUIF (Software Component) SAP Web UI Framework
   ⤷ CA-WUI (Application Component) WebClient UI
     ⤷ BSP_DYN_CONFIG_TAG_LIB_APP_IL (Package) CRM UI Framework Test Application GENIL
Basic Data
Table Category INTTAB    Structure 
Structure CRMS_UIF_TRAVEL_FLIGHT_DB_2   Table Relationship Diagram
Short Description Structure to store SPFLI    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 .INCLUDE       0   0   Flight schedule  
2 MANDT S_MANDT MANDT CLNT 3   0   Client T000
3 CARRID S_CARR_ID S_CARR_ID CHAR 3   0   Airline Code SCARR
4 CONNID S_CONN_ID S_CONN_ID NUMC 4   0   Flight Connection Number *
5 COUNTRYFR LAND1 LAND1 CHAR 3   0   Country Key SGEOCITY
6 CITYFROM S_FROM_CIT S_CITY CHAR 20   0   Departure city SGEOCITY
7 AIRPFROM S_FROMAIRP S_AIRPID CHAR 3   0   Departure airport SAIRPORT
8 COUNTRYTO LAND1 LAND1 CHAR 3   0   Country Key SGEOCITY
9 CITYTO S_TO_CITY S_CITY CHAR 20   0   Arrival city SGEOCITY
10 AIRPTO S_TOAIRP S_AIRPID CHAR 3   0   Destination airport SAIRPORT
11 FLTIME S_FLTIME S_DURA INT4 10   0   Flight time  
12 DEPTIME S_DEP_TIME S_TIME TIMS 6   0   Departure time  
13 ARRTIME S_ARR_TIME S_TIME TIMS 6   0   Arrival time  
14 DISTANCE S_DISTANCE S_DISTANCE QUAN 9   4   Distance  
15 DISTID S_DISTID MEINS UNIT 3   0   Mass unit of distance (kms, miles) *
16 FLTYPE S_FLTYPE S_FLTYPE CHAR 1   0   Flight type  
17 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 CRMS_UIF_TRAVEL_FLIGHT_DB_2 AIRPFROM SAIRPORT ID REF 1 CN
2 CRMS_UIF_TRAVEL_FLIGHT_DB_2 AIRPTO SAIRPORT ID REF 1 CN
3 CRMS_UIF_TRAVEL_FLIGHT_DB_2 CARRID SCARR CARRID KEY 1 CN
4 CRMS_UIF_TRAVEL_FLIGHT_DB_2 CITYFROM SGEOCITY CITY REF 1 CN
5 CRMS_UIF_TRAVEL_FLIGHT_DB_2 CITYTO SGEOCITY CITY REF 1 CN
6 CRMS_UIF_TRAVEL_FLIGHT_DB_2 COUNTRYFR SGEOCITY COUNTRY REF 1 CN
7 CRMS_UIF_TRAVEL_FLIGHT_DB_2 COUNTRYTO SGEOCITY COUNTRY REF 1 CN
8 CRMS_UIF_TRAVEL_FLIGHT_DB_2 MANDT T000 MANDT    
History
Last changed by/on SAP  20130604 
SAP Release Created in 700