1. Home
  2. Resources
  3. SAP Tables
  4. SBOOK - Single Flight Booking

SAP Table SBOOK

Single Flight Booking

SBOOK (Single Flight Booking) 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 SBOOK to other SAP tables.

Source: SBOOK (Single Flight Booking)

SBOOK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client S_MANDT T000 CLNT 3 0
CARRID Airline Code S_CARR_ID SCARR CHAR 3 0
CONNID Flight Connection Number S_CONN_ID SPFLI NUMC 4 0
FLDATE Flight date S_DATE SFLIGHT DATS 8 0
BOOKID Booking number S_BOOK_ID NUMC 8 0
CUSTOMID Customer Number S_CUSTOMER SCUSTOM NUMC 8 0
CUSTTYPE Customer type S_CUSTTYPE CHAR 1 0
B Business Customer
P Private Customer
SMOKER Smoker S_SMOKER CHAR 1 0
NULL Non-Smokers
X Smokers
LUGGWEIGHT Weight of Luggage S_LUGWEIGH QUAN 8 4
WUNIT Weight Unit S_WEIUNIT T006 UNIT 3 0
INVOICE Invoice flag S_INVFLAG CHAR 1 0
NULL Not Selected
X Selected
CLASS Flight Class S_CLASS CHAR 1 0
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
LOCCURKEY Local currency of airline S_CURRCODE SCURX CUKY 5 0
ORDER_DATE Booking Date S_BDATE DATS 8 0
COUNTER Number of sales office S_COUNTNUM SCOUNTER NUMC 8 0
AGENCYNUM Travel Agency Number S_AGNCYNUM STRAVELAG NUMC 8 0
CANCELLED Cancelation flag S_CANCEL CHAR 1 0
NULL Flight booked
X Booking canceled
RESERVED Reservation flag S_RESERV CHAR 1 0
NULL Not reserved
X Reserved
PASSNAME Name of the Passenger S_PASSNAME CHAR 25 0
PASSFORM Form of address S_FORM CHAR 15 0
PASSBIRTH Date of Birth of a Passenger S_BIRTHDAT DATS 8 0

SBOOK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SBOOK AGENCYNUM SBOOK MANDT STRAVELAG Travel agency MANDT
SBOOK AGENCYNUM SBOOK AGENCYNUM STRAVELAG Travel agency AGENCYNUM
SBOOK CARRID SBOOK CARRID SCARR Airline CARRID
SBOOK CARRID SBOOK MANDT SCARR Airline MANDT
SBOOK CONNID SBOOK MANDT SPFLI Flight schedule MANDT
SBOOK CONNID SBOOK CARRID SPFLI Flight schedule CARRID
SBOOK CONNID SBOOK CONNID SPFLI Flight schedule CONNID
SBOOK COUNTER SBOOK COUNTER SCOUNTER Sales counter COUNTNUM
SBOOK COUNTER SBOOK CARRID SCOUNTER Sales counter CARRID
SBOOK COUNTER SBOOK MANDT SCOUNTER Sales counter MANDT
SBOOK CUSTOMID SBOOK MANDT SCUSTOM Flight customers MANDT
SBOOK CUSTOMID SBOOK CUSTOMID SCUSTOM Flight customers ID
SBOOK FLDATE SBOOK CARRID SFLIGHT Flight CARRID
SBOOK FLDATE SBOOK FLDATE SFLIGHT Flight FLDATE
SBOOK FLDATE SBOOK CONNID SFLIGHT Flight CONNID
SBOOK FLDATE SBOOK MANDT SFLIGHT Flight MANDT
SBOOK FORCURKEY SBOOK FORCURKEY SCURX Currency for Workbench training data model BC_Travel CURRKEY
SBOOK LOCCURKEY SBOOK LOCCURKEY SCURX Currency for Workbench training data model BC_Travel CURRKEY
SBOOK MANDT SBOOK MANDT T000 Clients MANDT
SBOOK WUNIT SBOOK MANDT T006 Units of Measurement MANDT
SBOOK WUNIT SBOOK WUNIT T006 Units of Measurement MSEHI