SAP Table SBOOK
Single Flight Booking
The table SBOOK (Single Flight Booking) is a standard table in SAP ERP.
It belongs to the package SAPBC_DATAMODEL.
Technical Information
Table |
SBOOK |
Short Text |
Single Flight Booking |
Package |
SAPBC_DATAMODEL
|
Table Type |
Transparent Table
|
Fields for Table SBOOK
Field Name |
Key |
Description |
Data Element |
Type |
Length |
Check Table |
MANDT |
✔ |
Client |
S_MANDT |
CLNT |
3 |
T000 |
CARRID |
✔ |
Airline Code |
S_CARR_ID |
CHAR |
3 |
SCARR |
CONNID |
✔ |
Flight Connection Number |
S_CONN_ID |
NUMC |
4 |
SPFLI |
FLDATE |
✔ |
Flight date |
S_DATE |
DATS |
8 |
SFLIGHT |
BOOKID |
✔ |
Booking number |
S_BOOK_ID |
NUMC |
8 |
|
CUSTOMID |
|
Customer Number |
S_CUSTOMER |
NUMC |
8 |
SCUSTOM |
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 |
T006 |
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 |
CUKY |
5 |
SCURX |
LOCCURAM |
|
Price of booking in local currency of airline |
S_L_CUR_PR |
CURR |
15 |
|
LOCCURKEY |
|
Local currency of airline |
S_CURRCODE |
CUKY |
5 |
SCURX |
ORDER_DATE |
|
Booking Date |
S_BDATE |
DATS |
8 |
|
COUNTER |
|
Number of sales office |
S_COUNTNUM |
NUMC |
8 |
SCOUNTER |
AGENCYNUM |
|
Travel Agency Number |
S_AGNCYNUM |
NUMC |
8 |
STRAVELAG |
CANCELLED |
|
Cancelation flag |
S_CANCEL |
CHAR |
1 |
|
RESERVED |
|
Reservation flag |
S_RESERV |
CHAR |
1 |
|
PASSNAME |
|
Name of the Passenger |
S_PASSNAME |
CHAR |
25 |
|
PASSFORM |
|
Form of address |
S_FORM |
CHAR |
15 |
|
PASSBIRTH |
|
Date of Birth of a Passenger |
S_BIRTHDAT |
DATS |
8 |
* |