- Home
- Resources
- SAP Tables
- FTPT_FLIGHT - Travel Request Item - Flight Service
SAP Table FTPT_FLIGHT
Travel Request Item - Flight Service
FTPT_FLIGHT (Travel Request Item - Flight Service) 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 FTPT_FLIGHT to other SAP tables.
Source: FTPT_FLIGHT (Travel Request Item - Flight Service)
FTPT_FLIGHT table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
MANDT |
|
CLNT |
|
3 |
0 |
|
| PERNR |
Personnel Number |
PERNR_D |
|
NUMC |
|
8 |
0 |
|
| REINR |
Trip Number |
REINR |
|
NUMC |
|
10 |
0 |
|
| PLANNR |
Travel Plan Number (Sequential Number) |
PLAN_NR |
|
NUMC |
|
2 |
0 |
|
| VARIANT |
Plan variant number (sequential number) |
VARIANT_NR |
|
NUMC |
|
2 |
0 |
|
| VARIANTVRS |
Version of travel plan |
VARIANT_VERSION |
|
NUMC |
|
2 |
0 |
|
| ITEM |
Travel Request Item Number (Sequential Number) |
ITEMPOS_NR |
FTPT_ITEM
|
NUMC |
|
3 |
0 |
|
| SERVICE |
Travel service item number of flight |
FLIGHT_SERVICE_NR |
|
NUMC |
|
3 |
0 |
|
| AIRLINE |
Airline |
FLIGHT_AIRLINE |
TA21P
|
CHAR |
|
3 |
0 |
|
| FLIGHT_NR |
Flight Number |
FLIGHT_NR |
|
CHAR |
|
6 |
0 |
|
| DATE_DEP |
Flight departure date |
FLIGHT_DATE_DEP |
|
DATS |
|
8 |
0 |
|
| TIME_DEP |
Flight departure time |
FLIGHT_TIME_DEP |
|
TIMS |
|
6 |
0 |
|
| LOC_DEP |
Departure Location |
FLIGHT_SLOC_DEP |
TA21L
|
CHAR |
|
3 |
0 |
|
| TERM_DEP |
Terminal Code (Departure) |
FLIGHT_TERM_DEP |
|
CHAR |
|
2 |
0 |
|
| GATE_DEP |
Flight departure terminal |
FLIGHT_GATE_DEP |
|
CHAR |
|
6 |
0 |
|
| DATE_ARR |
Flight arrival date |
FLIGHT_DATE_ARR |
|
DATS |
|
8 |
0 |
|
| TIME_ARR |
Flight arrival time |
FLIGHT_TIME_ARR |
|
TIMS |
|
6 |
0 |
|
| LOC_ARR |
Flight Arrival Location |
FLIGHT_SLOC_ARR |
TA21L
|
CHAR |
|
3 |
0 |
|
| TERM_ARR |
Terminal code (arrival) |
FLIGHT_TERM_ARR |
|
CHAR |
|
2 |
0 |
|
| GATE_ARR |
Flight arrival terminal |
FLIGHT_GATE_ARR |
|
CHAR |
|
6 |
0 |
|
| RESTRICT_FARE |
Restricted airfare |
FARE_RESTRICT |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Not Selected |
| X |
Selected |
|
| CABIN |
Flight Cabin Class |
FLIGHT_CABIN |
|
CHAR |
|
1 |
0 |
Possible values
| S |
Supersonic |
| F |
First |
| B |
Business |
| E |
Economy |
|
| RBD |
Flight Booking Code (RBD) |
FLIGHT_RBD |
|
CHAR |
|
1 |
0 |
|
| MARRIED |
Married Segments |
MARRIED_SEGMENT |
|
INT1 |
|
3 |
0 |
|
| 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 |
|
| TEMPLATE |
Template indicator |
VARIANT_TEMPLATE |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
No Template |
| X |
Template |
| B |
With BahnCard |
| G |
With Major Customer Ticket |
|
| PNR_NR |
Line Number of Flight in PNR (if PNR available) |
FLIGHT_LINENUMBER |
FTPT_PNR
|
INT2 |
|
5 |
0 |
|
| ELEC_TKT |
Electronic ticketing for flight is possible |
FLIGHT_ELEC_TKT |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Not Selected |
| X |
Selected |
|
| PARTICIPATION |
Access type code: Airline |
FLIGHT_PARTICIPATION |
|
CHAR |
|
5 |
0 |
|
| CHECKIN_TIME |
Check-in time |
FLIGHT_CHECKIN |
|
TIMS |
|
6 |
0 |
|
| OP_AIRLINE |
Airline |
FLIGHT_AIRLINE |
TA21P
|
CHAR |
|
3 |
0 |
|
| PROFILE |
Travel Profile |
PROF_ID |
TA20P
|
CHAR |
|
8 |
0 |
|
| PROFITEM |
Trip rule |
PROF_ITEM |
TA20PI
|
CHAR |
|
8 |
0 |
|
| KZTKT |
Trip Activity Type |
PLAN_ACTIVITY |
|
CHAR |
|
1 |
0 |
|
| SPECHID |
Class rule |
SSPECID |
TA20PS
|
CHAR |
|
8 |
0 |
|
| PRIORITY |
Priority of trip rule |
PROFIL_PRIROITY |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
No priority |
| 1 |
1st priority |
| 2 |
2nd priority |
| 3 |
3rd priority |
| 4 |
4th priority |
| 5 |
5th priority |
| 6 |
6th priority |
| 7 |
7th priority |
| 8 |
8th priority |
| 9 |
9th priority |
| F |
Not allowed |
|
| HIGHEST_PRIORITY |
Priority of trip rule |
PROFIL_PRIROITY |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
No priority |
| 1 |
1st priority |
| 2 |
2nd priority |
| 3 |
3rd priority |
| 4 |
4th priority |
| 5 |
5th priority |
| 6 |
6th priority |
| 7 |
7th priority |
| 8 |
8th priority |
| 9 |
9th priority |
| F |
Not allowed |
|
| BEST_BUY_RC |
Indicator: Use 'Best Buy' Reason Codes |
BEST_BUY_REASON_CODE |
|
CHAR |
|
1 |
0 |
Possible values
| B |
Best Buy |
| F |
Flight |
| NULL |
No Information |
|
| REASON_CODE |
Reason Code |
REASON_CODE |
|
CHAR |
|
2 |
0 |
|
| REASON_TEXT |
Reason Text |
REASON_TEXT |
|
CHAR |
|
132 |
0 |
|
| CONNECTION_TAG |
Connection Indicator |
FTPD_CONNECTION_INDICATOR |
|
CHAR |
|
1 |
0 |
Possible values
| O |
Departure |
| I |
Arrival |
| C |
Connection |
|
FTPT_FLIGHT foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| FTPT_FLIGHT |
AIRLINE |
FTPT_FLIGHT |
AIRLINE |
TA21P |
Travel Service Providers |
PROVIDER |
| FTPT_FLIGHT |
AIRLINE |
'F' |
|
TA21P |
Travel Service Providers |
CATEGORY |
| FTPT_FLIGHT |
AIRLINE |
FTPT_FLIGHT |
MANDT |
TA21P |
Travel Service Providers |
MANDT |
| FTPT_FLIGHT |
ITEM |
FTPT_FLIGHT |
ITEM |
FTPT_ITEM |
Travel Service Request Item |
VARIANTVRS |
| FTPT_FLIGHT |
ITEM |
FTPT_FLIGHT |
VARIANTVRS |
FTPT_ITEM |
Travel Service Request Item |
VARIANT |
| FTPT_FLIGHT |
ITEM |
FTPT_FLIGHT |
VARIANT |
FTPT_ITEM |
Travel Service Request Item |
PLANNR |
| FTPT_FLIGHT |
ITEM |
FTPT_FLIGHT |
PLANNR |
FTPT_ITEM |
Travel Service Request Item |
REINR |
| FTPT_FLIGHT |
ITEM |
FTPT_FLIGHT |
REINR |
FTPT_ITEM |
Travel Service Request Item |
PERNR |
| FTPT_FLIGHT |
ITEM |
FTPT_FLIGHT |
PERNR |
FTPT_ITEM |
Travel Service Request Item |
MANDT |
| FTPT_FLIGHT |
ITEM |
FTPT_FLIGHT |
MANDT |
FTPT_ITEM |
Travel Service Request Item |
.INCLUDE |
| FTPT_FLIGHT |
LOC_ARR |
FTPT_FLIGHT |
LOC_ARR |
TA21L |
IATA Locations |
LOCID |
| FTPT_FLIGHT |
LOC_ARR |
FTPT_FLIGHT |
MANDT |
TA21L |
IATA Locations |
MANDT |
| FTPT_FLIGHT |
LOC_DEP |
FTPT_FLIGHT |
LOC_DEP |
TA21L |
IATA Locations |
LOCID |
| FTPT_FLIGHT |
LOC_DEP |
FTPT_FLIGHT |
MANDT |
TA21L |
IATA Locations |
MANDT |
| FTPT_FLIGHT |
OP_AIRLINE |
FTPT_FLIGHT |
OP_AIRLINE |
TA21P |
Travel Service Providers |
PROVIDER |
| FTPT_FLIGHT |
OP_AIRLINE |
FTPT_FLIGHT |
MANDT |
TA21P |
Travel Service Providers |
MANDT |
| FTPT_FLIGHT |
OP_AIRLINE |
'F' |
|
TA21P |
Travel Service Providers |
CATEGORY |
| FTPT_FLIGHT |
PNR_NR |
FTPT_FLIGHT |
PNR_NR |
FTPT_PNR |
Elements of passenger name records of travel plan variant |
VARIANTVRS |
| FTPT_FLIGHT |
PNR_NR |
FTPT_FLIGHT |
VARIANTVRS |
FTPT_PNR |
Elements of passenger name records of travel plan variant |
VARIANT |
| FTPT_FLIGHT |
PNR_NR |
FTPT_FLIGHT |
VARIANT |
FTPT_PNR |
Elements of passenger name records of travel plan variant |
PLANNR |
| FTPT_FLIGHT |
PNR_NR |
FTPT_FLIGHT |
PLANNR |
FTPT_PNR |
Elements of passenger name records of travel plan variant |
REINR |
| FTPT_FLIGHT |
PNR_NR |
FTPT_FLIGHT |
REINR |
FTPT_PNR |
Elements of passenger name records of travel plan variant |
PERNR |
| FTPT_FLIGHT |
PNR_NR |
FTPT_FLIGHT |
PERNR |
FTPT_PNR |
Elements of passenger name records of travel plan variant |
MANDT |
| FTPT_FLIGHT |
PNR_NR |
FTPT_FLIGHT |
MANDT |
FTPT_PNR |
Elements of passenger name records of travel plan variant |
.INCLUDE |
| FTPT_FLIGHT |
PROFILE |
FTPT_FLIGHT |
MANDT |
TA20P |
Travel profiles |
MANDT |
| FTPT_FLIGHT |
PROFILE |
FTPT_FLIGHT |
PROFILE |
TA20P |
Travel profiles |
PROFILE |
| FTPT_FLIGHT |
PROFITEM |
FTPT_FLIGHT |
PROFITEM |
TA20PI |
Trip Rule |
PROFITEM |
| FTPT_FLIGHT |
PROFITEM |
'F' |
|
TA20PI |
Trip Rule |
CATEGORY |
| FTPT_FLIGHT |
PROFITEM |
FTPT_FLIGHT |
MANDT |
TA20PI |
Trip Rule |
MANDT |
| FTPT_FLIGHT |
SPECHID |
FTPT_FLIGHT |
MANDT |
TA20PS |
Class Rule |
MANDT |
| FTPT_FLIGHT |
SPECHID |
FTPT_FLIGHT |
SPECHID |
TA20PS |
Class Rule |
SPECID |
| FTPT_FLIGHT |
SPECHID |
'F' |
|
TA20PS |
Class Rule |
CATEGORY |
