SAP ABAP Table SMT_TEST_S_SFLIGHT (Flight and bookings)
Hierarchy
☛ SAP_BS_FND (Software Component) SAP Business Suite Foundation
   ⤷ CA-SOA-SMT (Application Component) Service Mapping Tool
     ⤷ GMT_TEST_CONFIGURATION (Package) self tests
Basic Data
Table Category INTTAB    Structure 
Structure SMT_TEST_S_SFLIGHT   Table Relationship Diagram
Short Description Flight and bookings    
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  
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 SPFLI
5 FLDATE S_DATE S_DATE DATS 8   0   Flight date *
6 PRICE S_PRICE S_PRICE CURR 15   2   Airfare  
7 CURRENCY S_CURRCODE S_CURR CUKY 5   0   Local currency of airline SCURX
8 PLANETYPE S_PLANETYE S_PLANE CHAR 10   0   Aircraft Type SAPLANE
9 SEATSMAX S_SEATSMAX S_SEATS INT4 10   0   Maximum capacity in economy class  
10 SEATSOCC S_SEATSOCC S_SEATS INT4 10   0   Occupied seats in economy class  
11 PAYMENTSUM S_SUM S_SUM CURR 17   2   Total of current bookings  
12 SEATSMAX_B S_SMAX_B S_SEATS INT4 10   0   Maximum capacity in business class  
13 SEATSOCC_B S_SOCC_B S_SEATS INT4 10   0   Occupied seats in business class  
14 SEATSMAX_F S_SMAX_F S_SEATS INT4 10   0   Maximum capacity in first class  
15 SEATSOCC_F S_SOCC_F S_SEATS INT4 10   0   Occupied seats in first class  
16 BOOKINGS TY_BOOKINGS   TTYP 0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 SMT_TEST_S_SFLIGHT CARRID SCARR CARRID    
2 SMT_TEST_S_SFLIGHT CONNID SPFLI CONNID KEY 1 CN
3 SMT_TEST_S_SFLIGHT CURRENCY SCURX CURRKEY REF 1 N
4 SMT_TEST_S_SFLIGHT MANDT T000 MANDT KEY 1 CN
5 SMT_TEST_S_SFLIGHT PLANETYPE SAPLANE PLANETYPE REF 1 CN
History
Last changed by/on SAP  20130604 
SAP Release Created in 701