FTPT_A_FLIGHT

Travel Request Item - Flight Service | #masterdata | Component: Travel Expenses
Column Name Description
MANDT Client
PERNR Personnel Number
REINR Trip Number
PLANNR Travel Plan Number (Sequential Number)
VARIANTE Plan variant number (sequential number)
VARIANTVRS Version of travel plan
ITEM Travel Request Item Number (Sequential Number)
SERVICE Travel service item number of flight
Column Name Description
Column Name Description
Column Name Description
DATE_DEP Flight departure date
TIME_DEP Flight departure time
DATE_ARR Flight arrival date
TIME_ARR Flight arrival time
CHECKIN_TIME Check-in time
Column Name Description
RESTRICT_FARE Restricted airfare Show values
CABIN Flight Cabin Class Show values
STATUS Flight Status Show values
TEMPLATE Template indicator Show values
ELEC_TKT Electronic ticketing for flight is possible Show values
PRIORITY Priority of trip rule Show values
HIGHEST_PRIORITY Priority of trip rule Show values
BEST_BUY_RC Indicator: Use 'Best Buy' Reason Codes Show values
Column Name Description Domain name
FLIGHT_NR Flight Number FTPD_FLIGHT_NR
TERM_DEP Terminal Code (Departure) FTPD_TERMINAL
GATE_DEP Flight departure terminal FTPD_FLIGHT_GATE
TERM_ARR Terminal code (arrival) FTPD_TERMINAL
GATE_ARR Flight arrival terminal FTPD_FLIGHT_GATE
RBD Flight Booking Code (RBD) FTPD_FLIGHT_RBD
MARRIED Married Segments FTPD_MARRIED_SEG
PNR_NR Line Number of Flight in PNR (if PNR available) FTPD_PNR_NR
PARTICIPATION Access type code: Airline FTPD_PARTICIPATION
KZTKT Trip Activity Type FTPD_PLAN_ACTIVITY
REASON_CODE Reason Code FTPD_REASON_CODE
REASON_TEXT Reason Text TEXT132
Master Data Relations | to Other Relations ↓ Join Conditions
Flight Arrival Location
  • Flight Arrival Location
  • Client
  • FTPT_A_FLIGHT.LOC_ARR == TA21L.LOCID
  • FTPT_A_FLIGHT.MANDT == TA21L.MANDT
Departure Location
  • Departure Location
  • Client
  • FTPT_A_FLIGHT.LOC_DEP == TA21L.LOCID
  • FTPT_A_FLIGHT.MANDT == TA21L.MANDT
Travel Profile
  • Travel Profile
  • Client
  • FTPT_A_FLIGHT.PROFILE == TA20P.PROFILE
  • FTPT_A_FLIGHT.MANDT == TA20P.MANDT
Trip rule
  • ?
  • Trip rule
  • FTPT_A_FLIGHT.MANDT == TA20PI.MANDT
  • FTPT_A_FLIGHT.[column in domain "CATEGORY"] == TA20PI.CATEGORY
  • FTPT_A_FLIGHT.PROFITEM == TA20PI.PROFITEM
Class rule
  • ?
  • Class rule
  • Client
  • FTPT_A_FLIGHT.[column in domain "CATEGORY"] == TA20PS.CATEGORY
  • FTPT_A_FLIGHT.SPECHID == TA20PS.SPECID
  • FTPT_A_FLIGHT.MANDT == TA20PS.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Airline
  • ?
  • Airline
  • Client
  • FTPT_A_FLIGHT.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • FTPT_A_FLIGHT.AIRLINE == TA21P.PROVIDER
  • FTPT_A_FLIGHT.MANDT == TA21P.MANDT
Airline
  • ?
  • Airline
  • Client
  • FTPT_A_FLIGHT.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • FTPT_A_FLIGHT.OP_AIRLINE == TA21P.PROVIDER
  • FTPT_A_FLIGHT.MANDT == TA21P.MANDT