FTPT_FLIGHT_PREF

Flight service preferences of a travel plan | #transactional | Component: Travel Planning
Column Name Description
MANDT Client
PERNR Personnel Number
REINR Trip Number
PLANNR Travel Plan Number (Sequential Number)
VARIANT Plan variant number (sequential number)
VARIANTVRS Version of travel plan
ITEM Travel Request Item Number (Sequential Number)
SERVICE FK Travel service item number of flight
Column Name Description
Column Name Description
Column Name Description
Column Name Description
MEAL_CODE Preferred Meal on Flight Show values
HDCAP_CODE Seating Request: Suitable for Challenged Person Show values
MEDIC_CODE Seating Request: Medical Care Show values
MINOR_CODE Seating requisition: unaccompanied minor Show values
INFANT_CODE Seating requisition: child's seat Show values
FREQ_CARD_USAGE Type of Usage for Frequent Flyer Card Show values
BLIND Challenge: Blindness (for OSI information) Show values
DEAF Challenge: Deafness (for OSI information) Show values
Column Name Description Domain name
FREQ_CODE Provider to which the SSR refers FTPD_PROVIDER_CODE
STATUS_CODE SSR status CHAR2
TEXT_INFO Text description for an SSR element FTPD_INFO
LINENUMBER Line number of SSR in the itinerary FTPD_LINENUMBER
FREQ_CARD_CODE SSR Frequent Flyer Affiliated Airline Code FTPD_PROVIDER_CODE
FREQ_CARD_NUMBER Frequent Flyer Card Number FTPD_FLIGHT_PREF_FREQ_FLYER_NR
HDCAP_DESCR Description of challenge TEXT120
MEDIC_DESCR Description of medical care TEXT120
Other Relations Join Conditions
Check Against Airline
  • ?
  • Airline
  • Client
  • FTPT_FLIGHT_PREF.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • FTPT_FLIGHT_PREF.AIRLINE_CODE == TA21P.PROVIDER
  • FTPT_FLIGHT_PREF.MANDT == TA21P.MANDT