The BOOKINGS table in SAP ERP or S/4HANA stores ABAP book: Flight bookings data. There are total 16 fields in BOOKINGS table. The ABAP book: Flight bookings table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of BOOKINGS table. It is in Example Objects for the ABAP Manual (SABB) ABAP package and is part of the Workbench Utilities (BC-DWB-UTL) module.
SAP BOOKINGS Table Fields
Following is the list of fields that are available in SAP BOOKINGS table. The primary key fields of the table are MANDT (Client), CARRID (Airline Code), CONNID (Flight Connection Number), FLDATE (Flight date), BOOKID (Booking number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | S_MANDT | T000 | CLNT (3) |
| CARRID | Airline Code | S_CARR_ID | ACTFLI | CHAR (3) |
| CONNID | Flight Connection Number | S_CONN_ID | ACTFLI | NUMC (4) |
| FLDATE | Flight date | S_DATE | ACTFLI | DATS (8) |
| BOOKID | Booking number | S_BOOK_ID | NUMC (8) | |
| CUSTOMID | Customer Number | S_CUSTOMER | CUSTOMERS | NUMC (8) |
| CUSTTYPE | Customer type | S_CUSTTYPE | CHAR (1) | |
| SMOKER | Smoker | S_SMOKER | CHAR (1) | |
| LUGGWEIGHT | Weight of Luggage | S_LUGWEIGH | QUAN (8) | |
| WUNIT | Weight Unit | S_WEIUNIT | * | UNIT (3) |
| INVOICE | Invoice flag | S_INVFLAG | CHAR (1) | |
| CLASS | Flight Class | S_CLASS | CHAR (1) | |
| FORCURAM | Booking price in foreign currency (dependent on location) | S_F_CUR_PR | CURR (15) | |
| FORCURKEY | Payment currency | S_CURR | SCURX | CUKY (5) |
| LOCCURAM | Price of booking in local currency of airline | S_L_CUR_PR | CURR (15) | |
| ORDER_DATE | Booking Date | S_BDATE | DATS (8) |
