FTPT_A_FL_TSTK

Ticket information | #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
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
Column Name Description
Column Name Description
LAST_DATE Last Ticketing Date
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
Column Name Description Domain name
TICKETNUMBER Ticket Number FTPD_TICKET_NUMBER
TICKETTYPE Ticket Type FTPD_TICKET_TYPE
INFO Ticket Information FTPD_TICKET_INFO
Master Data Relations Join Conditions
Currency
  • FTPT_A_FL_TSTK.MANDT == TCURC.MANDT
  • FTPT_A_FL_TSTK.FARE_CURR == TCURC.WAERS
Currency
  • FTPT_A_FL_TSTK.MANDT == TCURC.MANDT
  • FTPT_A_FL_TSTK.FULL_FARE_CURR == TCURC.WAERS
Currency
  • FTPT_A_FL_TSTK.MANDT == TCURC.MANDT
  • FTPT_A_FL_TSTK.REBATE_FARE_CURR == TCURC.WAERS
Currency
  • FTPT_A_FL_TSTK.MANDT == TCURC.MANDT
  • FTPT_A_FL_TSTK.TOTAL_FARE_CURR == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Plating Carrier
  • ?
  • Plating Carrier
  • Client
  • FTPT_A_FL_TSTK.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • FTPT_A_FL_TSTK.PLATING_CARRIER == TA21P.PROVIDER
  • FTPT_A_FL_TSTK.MANDT == TA21P.MANDT