- Home
- Resources
- SAP Tables
- SCOL_REF_BOOKING_CACHE - <cool> Reference Flight Example: Booking Cache
SAP Table SCOL_REF_BOOKING_CACHE
<cool> Reference Flight Example: Booking Cache
SCOL_REF_BOOKING_CACHE (<cool> Reference Flight Example: Booking Cache) 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 SCOL_REF_BOOKING_CACHE to other SAP tables.
Source: SCOL_REF_BOOKING_CACHE (<cool> Reference Flight Example: Booking Cache)
SCOL_REF_BOOKING_CACHE table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| CARRID |
Airline Code |
S_CARR_ID |
|
CHAR |
|
3 |
0 |
|
| CONNID |
Flight Connection Number |
S_CONN_ID |
|
NUMC |
|
4 |
0 |
|
| FLDATE |
Flight date |
S_DATE |
|
DATS |
|
8 |
0 |
|
| SCOL_BOOKID |
Persistent Booking ID for Flight Example |
SCOL_BOOKID |
|
NUMC |
|
10 |
0 |
|
| CUSTOMID |
Customer Number |
S_CUSTOMER |
|
NUMC |
|
8 |
0 |
|
| CUSTTYPE |
Customer type |
S_CUSTTYPE |
|
CHAR |
|
1 |
0 |
Possible values
| B |
Business Customer |
| P |
Private Customer |
|
| SMOKER |
Smoker |
S_SMOKER |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Non-Smokers |
| X |
Smokers |
|
| LUGGWEIGHT |
Weight of Luggage |
S_LUGWEIGH |
|
QUAN |
|
8 |
4 |
|
| WUNIT |
Weight Unit |
S_WEIUNIT |
|
UNIT |
|
3 |
0 |
|
| INVOICE |
Invoice flag |
S_INVFLAG |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Not Selected |
| X |
Selected |
|
| CLASS |
Flight Class |
S_CLASS |
|
CHAR |
|
1 |
0 |
Possible values
| 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 |
|
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 |
|
CUKY |
|
5 |
0 |
|
| ORDER_DATE |
Booking Date |
S_BDATE |
|
DATS |
|
8 |
0 |
|
| COUNTER |
Number of sales office |
S_COUNTNUM |
|
NUMC |
|
8 |
0 |
|
| AGENCYNUM |
Travel Agency Number |
S_AGNCYNUM |
|
NUMC |
|
8 |
0 |
|
| CANCELLED |
Cancelation flag |
S_CANCEL |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Flight booked |
| X |
Booking canceled |
|
| RESERVED |
Reservation flag |
S_RESERV |
|
CHAR |
|
1 |
0 |
Possible values
| 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 |
|
| BOOKID |
Booking number |
S_BOOK_ID |
|
NUMC |
|
8 |
0 |
|
| UPDATE_FLAG |
Character Field Length 1 |
CHAR01 |
|
CHAR |
|
1 |
0 |
|
| ENQUEUE_STATE |
ESF Lock Mode |
SCOL_LOCKMODE |
|
CHAR |
|
2 |
0 |
Possible values
| X |
Exclusive Lock |
| NULL |
No Lock |
| S |
"Shared" Lock |
| SP |
"Shared-Promotable" Lock |
| PR |
Promotion to Exclusive |
|
