The flight model is the basis of all the examples in this documentation. All the tables mentioned in the examples exist in your system, so you can reproduce the examples directly in the system.
The flight model is based on data model BC_TRAVEL, which you can look at in your system using the Data Modeler.
A screen for searching data models appears.
You can find further information about data modeling and using the Data Modeler in the documentation on the Data Modeler .
The flight model gives a simple description of seat bookings in passenger airplanes by flight customers. The booking can be made either at the sales desk of a carrier or at a travel agency.
A flight booking is based on the individual flight connections described in the flight schedule. There are concrete flights for every flight connection.
There is a table in the ABAP Dictionary containing the data of the corresponding entities (versions of the entity type) for each entity type.
The most important tables of the flight model are:
Table SBUSPART contains all the business partners of a carrier. A business partner is identified by a number in this table. The data of the contact person for the business partner is also stored. A business partner can be a travel agency or a customer (for example, a company that frequently books flights directly with the carrier). Different data is required for these two types of business partner. The data for a travel agency is stored in table STRAVELAG and the data for a customer in table SCUSTOM. There is an entry with the same key in either table STRAVELAG or table SCUSTOM for each entry in table SBUSPART.
Table SCARR contains the IDs and names of the carriers. Each carrier has a number of connections. These flight connections are stored in table SPFLI. Table SFLIGHT contains the concrete flight data for each connection. Bookings can be made for each flight in table SFLIGHT. The system enters the bookings made for each flight in table SBOOK.
The carriers have sales counters in the airports. These sales counters lie in table SCOUNTER. The customer number or agency number for which the booking was made is stored in table SBOOK for each booking. If the customer books a flight directly at a counter, the system enters the counter number also in the booking data in table SBOOK.