Create Data for Flight Data Model

Posted by Christian Weiß on January 18, 2018

Flight Model

The flight model is the base of all ABAP examples and in the most SAP courses and tutorials. All the tables mentioned in the course matirials exists in your system, so you can reproduce the examples directly in the system.

The flight model is based on data model BC_TRAVEL.

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)

Run the following report in SE38 transaction:

SAPBC_DATA_GENERATOR

Run the report F8:

Result

350 entries in the table SFLIGHT is OK, but a little bit more makes more fun.

The large data records can only be created in the background.

Backgroundjob to create Flight Model

Background job is a non-interactive process that runs behind the normal interactive operations. They run in parallel and do not disturb interactive (foreground jobs) processes and operations.

It is scheduled from SM36. You can analyze it from SM37 by viewing its job log.

I used the Job Wizzard:

Run the following transaction SM36: