ABAP TRAINING IN NOIDA
SAP’s flight and booking data model is present in every ABAP system. It is used in ABAP documentation and training provided by SAP. This blog post explains tables related to specific training exercises you can do while learning ABAP.
In the ERD shown below, you can see how the flight data tables provided by SAP are set up. This post will not cover every table or every field, but you can open SAPBC_DATAMODEL package in transaction SE80 and find all tables related to flight.
Showing ERD Standard SAP Table
Standard tables can be described as follows:
skustom
This table stores information about customers.
promenade
This table stores airport ID and information about airports.
Mark
This table stores all the carriers (airlines).
spfli
This table stores the flight schedule for each airline — for example, Flight 17 for American Airlines takes off from New York City to San Francisco and departs at 11 a.m.
flight
This table stores the actual flight schedule for the flight schedule — for example, Flight 17 for American Airlines will fly on January 12 and cost $500.
subbook
This table stores bookings for single flights.
You can see that the tables are normalized because the master data tables (such as airports and customers) are all separate from the tables in which they are referenced multiple times. This means that changes to customer information will be in table SCUSTOM and will not affect bookings in table SBOOK.
Note that the MANDT field is listed as the first key in each table. This field stores the SAP client number. Here client is the SAP concept which allows the system to segregate the data within the same database. This client-server architecture differs from the client in concept.
Now that you know what the SAP Flight and Booking Data Model is, you will have a better understanding of what you see during ABAP training. To learn more about this programming language, see our free overview on ABAP here.
Editor’s note: This post has been adapted from an excerpt from the book ABAP: An Introduction by Brian O’Neill and Jelena Perfiljeva.