- Home
- Resources
- SAP Tables
- BOOKINGS - ABAP book: Flight bookings
SAP Table BOOKINGS
ABAP book: Flight bookings
BOOKINGS (ABAP book: Flight bookings) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link BOOKINGS to other SAP tables.
Source: BOOKINGS (ABAP book: Flight bookings)
BOOKINGS table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
S_MANDT |
T000
|
CLNT |
|
3 |
0 |
|
| CARRID |
Airline Code |
S_CARR_ID |
ACTFLI
|
CHAR |
|
3 |
0 |
|
| CONNID |
Flight Connection Number |
S_CONN_ID |
ACTFLI
|
NUMC |
|
4 |
0 |
|
| FLDATE |
Flight date |
S_DATE |
ACTFLI
|
DATS |
|
8 |
0 |
|
| BOOKID |
Booking number |
S_BOOK_ID |
|
NUMC |
|
8 |
0 |
|
| CUSTOMID |
Customer Number |
S_CUSTOMER |
CUSTOMERS
|
NUMC |
|
8 |
0 |
|
| CUSTTYPE |
Customer type |
S_CUSTTYPE |
|
CHAR |
|
1 |
0 |
Possible values
| B |
Business Customer |
| P |
Private Customer |
|
| SMOKER |
Smoker |
S_SMOKER |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Non-Smokers |
| X |
Smokers |
|
| LUGGWEIGHT |
Weight of Luggage |
S_LUGWEIGH |
|
QUAN |
|
8 |
4 |
|
| WUNIT |
Weight Unit |
S_WEIUNIT |
|
UNIT |
|
3 |
0 |
|
| INVOICE |
Invoice flag |
S_INVFLAG |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Not Selected |
| X |
Selected |
|
| CLASS |
Flight Class |
S_CLASS |
|
CHAR |
|
1 |
0 |
Possible values
| C |
Business Class |
| Y |
Economy Class |
| F |
First Class |
|
| FORCURAM |
Booking price in foreign currency (dependent on location) |
S_F_CUR_PR |
|
CURR |
|
15 |
2 |
|
| FORCURKEY |
Payment currency |
S_CURR |
SCURX
|
CUKY |
|
5 |
0 |
|
| LOCCURAM |
Price of booking in local currency of airline |
S_L_CUR_PR |
|
CURR |
|
15 |
2 |
|
| ORDER_DATE |
Booking Date |
S_BDATE |
|
DATS |
|
8 |
0 |
|
BOOKINGS foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| BOOKINGS |
CARRID |
BOOKINGS |
MANDT |
ACTFLI |
ABAP/4 book: Flights |
MANDT |
| BOOKINGS |
CARRID |
BOOKINGS |
CARRID |
ACTFLI |
ABAP/4 book: Flights |
CARRID |
| BOOKINGS |
CARRID |
BOOKINGS |
CONNID |
ACTFLI |
ABAP/4 book: Flights |
CONNID |
| BOOKINGS |
CARRID |
BOOKINGS |
FLDATE |
ACTFLI |
ABAP/4 book: Flights |
FLDATE |
| BOOKINGS |
CONNID |
BOOKINGS |
MANDT |
ACTFLI |
ABAP/4 book: Flights |
MANDT |
| BOOKINGS |
CONNID |
BOOKINGS |
CARRID |
ACTFLI |
ABAP/4 book: Flights |
CARRID |
| BOOKINGS |
CONNID |
BOOKINGS |
CONNID |
ACTFLI |
ABAP/4 book: Flights |
CONNID |
| BOOKINGS |
CONNID |
BOOKINGS |
FLDATE |
ACTFLI |
ABAP/4 book: Flights |
FLDATE |
| BOOKINGS |
CUSTOMID |
BOOKINGS |
MANDT |
CUSTOMERS |
ABAP Book: Customers |
MANDT |
| BOOKINGS |
CUSTOMID |
BOOKINGS |
CUSTOMID |
CUSTOMERS |
ABAP Book: Customers |
ID |
| BOOKINGS |
FLDATE |
BOOKINGS |
MANDT |
ACTFLI |
ABAP/4 book: Flights |
MANDT |
| BOOKINGS |
FLDATE |
BOOKINGS |
CARRID |
ACTFLI |
ABAP/4 book: Flights |
CARRID |
| BOOKINGS |
FLDATE |
BOOKINGS |
CONNID |
ACTFLI |
ABAP/4 book: Flights |
CONNID |
| BOOKINGS |
FLDATE |
BOOKINGS |
FLDATE |
ACTFLI |
ABAP/4 book: Flights |
FLDATE |
| BOOKINGS |
FORCURKEY |
BOOKINGS |
FORCURKEY |
SCURX |
Currency for Workbench training data model BC_Travel |
CURRKEY |
| BOOKINGS |
MANDT |
BOOKINGS |
MANDT |
T000 |
Clients |
MANDT |
