SBOOK - Single Flight Booking

Single Flight Booking information is stored in SAP table SBOOK.
It is part of development package SAPBC_DATAMODEL in software component BC-DWB-TND. This development package consists of objects that can be grouped under "Data Model: BC_TRAVEL for Workbench Training and Docu.".

Fields for table SBOOK

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	S_MANDT	CLNT	6	T000
CARRID	Airline Code	X	S_CARR_ID	CHAR	6	SCARR
CONNID	Flight Connection Number	X	S_CONN_ID	NUMC	8	SPFLI
FLDATE	Flight date	X	S_DATE	DATS	16	SFLIGHT
BOOKID	Booking number	X	S_BOOK_ID	NUMC	16
CUSTOMID	Customer Number		S_CUSTOMER	NUMC	16	SCUSTOM
CUSTTYPE	Customer type		S_CUSTTYPE	CHAR	2
SMOKER	Smoker		S_SMOKER	CHAR	2
LUGGWEIGHT	Weight of Luggage		S_LUGWEIGH	QUAN	5
WUNIT	Weight Unit		S_WEIUNIT	UNIT	6	T006
INVOICE	Invoice flag		S_INVFLAG	CHAR	2
CLASS	Flight Class		S_CLASS	CHAR	2
FORCURAM	Booking price in foreign currency (dependent on location)		S_F_CUR_PR	CURR	8
FORCURKEY	Payment currency		S_CURR	CUKY	10	SCURX
LOCCURAM	Price of booking in local currency of airline		S_L_CUR_PR	CURR	8
LOCCURKEY	Local currency of airline		S_CURRCODE	CUKY	10	SCURX
ORDER_DATE	Booking Date		S_BDATE	DATS	16
COUNTER	Number of sales office		S_COUNTNUM	NUMC	16	SCOUNTER
AGENCYNUM	Travel Agency Number		S_AGNCYNUM	NUMC	16	STRAVELAG
CANCELLED	Cancelation flag		S_CANCEL	CHAR	2
RESERVED	Reservation flag		S_RESERV	CHAR	2
PASSNAME	Name of the Passenger		S_PASSNAME	CHAR	50
PASSFORM	Form of address		S_FORM	CHAR	30
PASSBIRTH	Date of Birth of a Passenger		S_BIRTHDAT	DATS	16	*