ABAP Dictionary

The most important tables of the flight model are:

•        T000: Client table

•        SCURX: Currencies (key: currency key)

•        SBUSPART: Business partner (key: client, partner number)

•        STRAVELAG: Travel agencies (key: client, travel agency number)

•        SCUSTOM: Customers (key: client, customer number)

•        SCARR: Carriers (key: client, carrier ID)

•        SCOUNTER: Sales counters (key: client, carrier ID, sales counter number)

•        SPFLI: Flight schedule (key: client, carrier ID, connection number)

•        SFLIGHT: Flights (key: client, carrier ID, connection number, date of flight)

•        SBOOK: Flight bookings (key: client, carrier ID, connection number, date of flight, booking number, customer number)

Relationships between the Tables

Table SBUSPART contains all the business partners of a carrier. A business partner is identified by his 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 (e.g. 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 therefore 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 bookings made for each flight are entered in table SBOOK.

The carriers have sales counters in the airports. These sales counters are entered 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 his flight directly at a counter, the counter number is also entered in the booking data in table SBOOK.