SAP table BOOKINGS (ABAP book: Flight bookings)

SAP table BOOKINGS has 5 primary key fields being MANDT,CARRID,CONNID,FLDATE,BOOKID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 S_MANDT
CARRID Airline Code CHAR 3 0 ACTFLI S_CARR_ID
CONNID Flight Connection Number NUMC 4 0 ACTFLI S_CONN_ID
FLDATE Flight date DATS 8 0 ACTFLI S_DATE
BOOKID Booking number NUMC 8 0 S_BOOK_ID
CUSTOMID Customer Number NUMC 8 0 CUSTOMERS S_CUSTOMER
CUSTTYPE Customer type CHAR 1 0 S_CUSTTYPE
B Business Customer
P Private Customer
SMOKER Smoker CHAR 1 0 S_SMOKER
Non-Smokers
X Smokers
LUGGWEIGHT Weight of Luggage QUAN 8 4 S_LUGWEIGH
WUNIT Weight Unit UNIT 3 0 * S_WEIUNIT
INVOICE Invoice flag CHAR 1 0 S_INVFLAG
CLASS Flight Class CHAR 1 0 S_CLASS
C Business Class
F First Class
Y Economy Class
FORCURAM Booking price in foreign currency (dependent on location) CURR 15 2 S_F_CUR_PR
FORCURKEY Payment currency CUKY 5 0 SCURX S_CURR
LOCCURAM Price of booking in local currency of airline CURR 15 2 S_L_CUR_PR
ORDER_DATE Booking Date DATS 8 0 S_BDATE

BOOKINGS foreign key relationships

Table Field Check Table Check Field
0 BOOKINGS CARRID ACTFLI ABAP/4 book: Flights MANDT
0 BOOKINGS CARRID ACTFLI ABAP/4 book: Flights CARRID
0 BOOKINGS CARRID ACTFLI ABAP/4 book: Flights CONNID
0 BOOKINGS CARRID ACTFLI ABAP/4 book: Flights FLDATE
1 BOOKINGS CONNID ACTFLI ABAP/4 book: Flights MANDT
1 BOOKINGS CONNID ACTFLI ABAP/4 book: Flights CARRID
1 BOOKINGS CONNID ACTFLI ABAP/4 book: Flights CONNID
1 BOOKINGS CONNID ACTFLI ABAP/4 book: Flights FLDATE
0 BOOKINGS CUSTOMID CUSTOMERS ABAP Book: Customers MANDT
0 BOOKINGS CUSTOMID CUSTOMERS ABAP Book: Customers ID
1 BOOKINGS FLDATE ACTFLI ABAP/4 book: Flights MANDT
1 BOOKINGS FLDATE ACTFLI ABAP/4 book: Flights CARRID
1 BOOKINGS FLDATE ACTFLI ABAP/4 book: Flights CONNID
1 BOOKINGS FLDATE ACTFLI ABAP/4 book: Flights FLDATE
0 BOOKINGS MANDT T000 Clients MANDT