BOOKINGS SAP (ABAP book: Flight bookings) Table details

Dictionary Type: Table
Description: ABAP book: Flight bookings




ABAP Code to SELECT data from BOOKINGS
Related tables to BOOKINGS
Access table BOOKINGS




Table field list including key, data, relationships and ABAP select examples

BOOKINGS is a standard SAP Table which is used to store ABAP book: Flight bookings data and is available within R/3 SAP systems depending on the version and release level.

The BOOKINGS table consists of various fields, each holding specific information or linking keys about ABAP book: Flight bookings data available in SAP. These include CARRID (Airline Code), CONNID (Flight Connection Number), FLDATE (Flight date), BOOKID (Booking number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP BOOKINGS table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient S_MANDTCLNT3T000MANDT
CARRIDAirline Code S_CARR_IDCHAR3ACTFLIS_CARR_IDCARS_CARRIER_ID
CONNIDFlight Connection Number S_CONN_IDNUMC4ACTFLIS_CONN_IDCON
FLDATEFlight date S_DATEDATS8ACTFLIS_DATEDAY
BOOKIDBooking number S_BOOK_IDNUMC8S_BOOK_IDBOK
CUSTOMIDCustomer Number S_CUSTOMERNUMC8CUSTOMERSS_BUSPANUMCSM
CUSTTYPECustomer type S_CUSTTYPECHAR1S_CUSTTYPE
SMOKERSmoker S_SMOKERCHAR1S_SMOKER
LUGGWEIGHTWeight of Luggage S_LUGWEIGHQUAN8(4) S_LUGWEIGH
WUNITWeight Unit S_WEIUNITUNIT3Assigned to domainCUNITMEINS
INVOICEInvoice flag S_INVFLAGCHAR1S_FLAG
CLASSFlight Class S_CLASSCHAR1S_CLASS
FORCURAMBooking price in foreign currency (dependent on location) S_F_CUR_PRCURR15(2) S_PRICE
FORCURKEYPayment currency S_CURRCUKY5SCURXS_CURR
LOCCURAMPrice of booking in local currency of airline S_L_CUR_PRCURR15(2) S_PRICE
ORDER_DATEBooking Date S_BDATEDATS8S_BDATE

Key field Non-key field



How do I retrieve data from SAP table BOOKINGS using ABAP code

The following ABAP code Example will allow you to do a basic selection on BOOKINGS to SELECT all data from the table
DATA: WA_BOOKINGS TYPE BOOKINGS.

SELECT SINGLE *
FROM BOOKINGS
INTO CORRESPONDING FIELDS OF WA_BOOKINGS
WHERE...

How to access SAP table BOOKINGS

Within an ECC or HANA version of SAP you can also view further information about BOOKINGS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!