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.
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 |
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 | T006 | 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 | |||||||||
| 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 |
Possible values
|
||||||||
| RESERVED | Reservation flag | S_RESERV | CHAR | 1 | 0 |
Possible values
|
||||||||
| 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 | MANDT | SCARR | Airline | MANDT |
| SBOOK | CARRID | SBOOK | CARRID | SCARR | Airline | CARRID |
| SBOOK | CONNID | SBOOK | CARRID | SPFLI | Flight schedule | CARRID |
| SBOOK | CONNID | SBOOK | CONNID | SPFLI | Flight schedule | CONNID |
| SBOOK | CONNID | SBOOK | MANDT | SPFLI | Flight schedule | MANDT |
| SBOOK | COUNTER | SBOOK | COUNTER | SCOUNTER | Sales counter | COUNTNUM |
| SBOOK | COUNTER | SBOOK | MANDT | SCOUNTER | Sales counter | MANDT |
| SBOOK | COUNTER | SBOOK | CARRID | SCOUNTER | Sales counter | CARRID |
| SBOOK | CUSTOMID | SBOOK | MANDT | SCUSTOM | Flight customers | MANDT |
| SBOOK | CUSTOMID | SBOOK | CUSTOMID | SCUSTOM | Flight customers | ID |
| SBOOK | FLDATE | SBOOK | MANDT | SFLIGHT | Flight | MANDT |
| SBOOK | FLDATE | SBOOK | CARRID | SFLIGHT | Flight | CARRID |
| SBOOK | FLDATE | SBOOK | CONNID | SFLIGHT | Flight | CONNID |
| SBOOK | FLDATE | SBOOK | FLDATE | SFLIGHT | Flight | FLDATE |
| 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 | WUNIT | T006 | Units of Measurement | MSEHI |
| SBOOK | WUNIT | SBOOK | MANDT | T006 | Units of Measurement | MANDT |
