- Home
- Resources
- SAP Tables
- FTPS_WEB_FLIGHT_PREF_OUTPUT - Initial Structure for Flight Preferences
SAP Table FTPS_WEB_FLIGHT_PREF_OUTPUT
Initial Structure for Flight Preferences
FTPS_WEB_FLIGHT_PREF_OUTPUT (Initial Structure for Flight Preferences) 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 FTPS_WEB_FLIGHT_PREF_OUTPUT to other SAP tables.
Source: FTPS_WEB_FLIGHT_PREF_OUTPUT (Initial Structure for Flight Preferences)
FTPS_WEB_FLIGHT_PREF_OUTPUT table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| SMOKE |
Smoker/Nonsmoker |
PREF_SMOKER |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Not specified |
| N |
Nonsmoker |
| S |
Smokers |
|
| SEATP |
Preferred seating position in airplane |
FLIGHT_PREF_SEATPOS |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Not specified |
| A |
Aisle |
| W |
Window |
|
| BHEAD |
Preference: Seat with Ample Leg Room |
FLIGHT_PREF_BULKHEAD |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Not Selected |
| X |
Selected |
|
| MEALS |
Preferred meal on flight |
FLIGHT_PREF_MEAL |
|
CHAR |
|
4 |
0 |
Possible values
| NULL |
Not specified |
| AVML |
Asian, vegetarian menu |
| BBML |
Baby food |
| BLML |
Unseasoned, mild menu |
| CHML |
Children's menu |
| DBML |
Diabetic menu |
| FPML |
Plate of fruit |
| GFML |
Gluten-free menu |
| HFML |
High-fiber menu |
| HNML |
Hindu menu |
| KSML |
Kosher menu |
| LCML |
Low-calory menu |
| LFML |
Low-cholesterol, low-fat menu |
| LPML |
Low-protein menu |
| LSML |
Low-salt menu |
| MOML |
Moslem menu |
| NLML |
Lactose-free menu |
| ORML |
Oriental menu |
| PRML |
Low-purine menu |
| RVML |
Raw vegetable menu |
| SFML |
Seafood menu |
| SPML |
Special menu |
| VGML |
Vegetarian menu (without dairy products) |
| VLML |
Vegetarian menu (with dairy products) |
| VJML |
Vegetarian menu (Jain) |
| VOML |
Vegetarian menu (oriental) |
|
| MEDIC |
Seating Request: Medical Care |
FLIGHT_PREF_MEDIC |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Not Selected |
| X |
Selected |
|
| FREQ_CARD_CODE |
SSR Frequent Flyer Affiliated Airline Code |
SSR_FREQ_CARD_AIRLINE |
|
CHAR |
|
3 |
0 |
|
| FREQ_CARD_USAGE |
Type of Usage for Frequent Flyer Card |
SSR_FREQ_CARD_USAGE |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Not Selected |
| X |
Selected |
|
| FREQ_CARD_NUMBER |
Frequent Flyer Card Number |
SSR_FREQ_CARD_NUMBER |
|
CHAR |
|
21 |
0 |
|
| FREEFLOW |
OSI additional info |
OSI_FREEFLOW |
|
CHAR |
|
132 |
0 |
|
| SEAT_STATUS |
Flight seat status |
FLIGHT_SEAT_STATUS |
|
CHAR |
|
2 |
0 |
Possible values
| 00 |
Open |
| 01 |
Chosen by query |
| 02 |
Requested |
| 04 |
Confirmed |
| 07 |
Selection canceled |
|
| FLIGHT_STATUS |
Flight Status |
FLIGHT_STATUS |
|
CHAR |
|
2 |
0 |
Possible values
| 00 |
Open |
| 01 |
Prereserved |
| 02 |
Requested |
| 05 |
Waiting List |
| 03 |
Requested and Not Confirmed |
| 04 |
Reserved and Confirmed |
| 06 |
Requested |
| 07 |
Selection Canceled |
| 08 |
External Reservation |
|
| PROGRAM_NAME |
Description of customer program |
PROV_PROGRAM_NAME |
|
CHAR |
|
30 |
0 |
|
| CARD_SHORT_NAME |
Customer Program Code |
PROV_PROGRAM_SHORTHAND |
|
CHAR |
|
3 |
0 |
|
| AIRLINE |
Airline |
FLIGHT_AIRLINE |
|
CHAR |
|
3 |
0 |
|
