FTPT_FLIGHT_TSTK

Ticket Information | #transactional | Component: Travel Planning
Column Name Description
MANDT Client
PERNR Personnel Number
REINR Trip Number
PLANNR Travel Plan Number (Sequential Number)
VARIANTE Plan variant number (sequential number)
VARIANTVRS FK Version of travel plan
TICKET Ticket
Column Name Description
💲 Currency (FARE_CURR):
FARE Basic rate for flight ticket without tax
💲 Currency (TOTAL_FARE_CURR):
TOTAL_FARE_PAID Total price of flight ticket
💲 Currency (REBATE_FARE_CURR):
REBATE_FARE Discount price of flight ticket
💲 Currency (FULL_FARE_CURR):
FULL_FARE Unrestricted Rate in the same Cabin Class
💲 Currency of Lowest-Cost Alternative Airfare Rate (CHEAPEST_FARE_C):
CHEAPEST_FARE Lowest-Cost Alternative Airfare Rate
💲 Currency of Excess Amount over Lowest Offer (EXCEEDING_FARE_C):
EXCEEDING_FARE Excess Amount over Lowest Offer
💲 Currency (TAXES_CURR):
TAXES Taxes
Column Name Description
Column Name Description
LAST_DATE Last Ticketing Date
LAST_TIME Latest Ticketing Time
LAST_APPROVAL_DATE Last Ticketing Date
LAST_APPROVAL_TIME Latest Ticketing Time
Column Name Description
LOCAL_TST Ticket element is local (not in booking system) Show values
TICKET_MODE Ticketing Mode of Airline Ticket Show values
SALES_IND Sales Type of Airline Ticket Rate Show values
ISSUE_TYPE Airline Ticket Issue Show values
TST_FARE_TYPE Fare Type (Normal, Negotiated, Etc.) Show values
LCC Low-Cost Carrier Show values
Column Name Description Domain name
TICKETNUMBER Ticket Number FTPD_TICKET_NUMBER
TICKETTYPE Ticket Type FTPD_TICKET_TYPE
INFO Ticket Information FTPD_TICKET_INFO
URL_LCC Low-Cost Carrier: URL for Web Page TEXT255
Master Data Relations Join Conditions
Check Against Currency
  • FTPT_FLIGHT_TSTK.MANDT == TCURC.MANDT
  • FTPT_FLIGHT_TSTK.FARE_CURR == TCURC.WAERS
Check Against Currency
  • FTPT_FLIGHT_TSTK.MANDT == TCURC.MANDT
  • FTPT_FLIGHT_TSTK.FULL_FARE_CURR == TCURC.WAERS
Check Against Currency
  • FTPT_FLIGHT_TSTK.MANDT == TCURC.MANDT
  • FTPT_FLIGHT_TSTK.REBATE_FARE_CURR == TCURC.WAERS
Check Against Currency
  • FTPT_FLIGHT_TSTK.MANDT == TCURC.MANDT
  • FTPT_FLIGHT_TSTK.TOTAL_FARE_CURR == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Check Against Airline
  • ?
  • Plating Carrier
  • Client
  • FTPT_FLIGHT_TSTK.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • FTPT_FLIGHT_TSTK.PLATING_CARRIER == TA21P.PROVIDER
  • FTPT_FLIGHT_TSTK.MANDT == TA21P.MANDT