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.
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
|
||||||||
| SMOKER | Smoker | S_SMOKER | CHAR | 1 | 0 |
Possible values
|
||||||||
| 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
|
||||||||
| CLASS | Flight Class | S_CLASS | CHAR | 1 | 0 |
Possible values
|
||||||||
| 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 | CONNID | ACTFLI | ABAP/4 book: Flights | CONNID |
| BOOKINGS | FLDATE | BOOKINGS | FLDATE | ACTFLI | ABAP/4 book: Flights | FLDATE |
| BOOKINGS | FLDATE | BOOKINGS | MANDT | ACTFLI | ABAP/4 book: Flights | MANDT |
| BOOKINGS | FLDATE | BOOKINGS | CARRID | ACTFLI | ABAP/4 book: Flights | CARRID |
| BOOKINGS | FORCURKEY | BOOKINGS | FORCURKEY | SCURX | Currency for Workbench training data model BC_Travel | CURRKEY |
| BOOKINGS | MANDT | BOOKINGS | MANDT | T000 | Clients | MANDT |
