FTPT_VARIANT

Table of Travel Plan Variants | #transactional | Component: Travel Planning
Column Name Description
MANDT Client
PERNR Personnel Number
REINR Trip Number
PLANNR FK Travel Plan Number (Sequential Number)
VARIANT Plan variant number (sequential number)
VARIANTVRS Version of travel plan
Column Name Description
💲 Currency of variant price (CURRENCY):
PRICE Variant price
Column Name Description
Column Name Description
Column Name Description
STATUS Variant status Show values
PRICING_STATUS Status of variant price request Show values
TEMPLATE Template indicator Show values
BOOK_REQUEST Booking flag was started Show values
FLIGHT_CANCELED Indicator: Flight Cancelation Exists Show values
Column Name Description Domain name
NAME Variant description FTPD_VARNAME
INFO_TXT Information text for variant status FTPD_INFO
REC_LOCATOR Passenger Name Record Locator FTPD_PNR_RECORD_LOCATOR
DB_ORDER_NR Passenger Name Record Locator FTPD_PNR_RECORD_LOCATOR
AGENCYSTATUS Travel Agency Status PTPD_AGENCY_STATUS
RES_SYSTEM Reservation System FTPD_PROVIDER_CODE
LAST_UPDATE UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Check Against Currency
  • FTPT_VARIANT.MANDT == TCURC.MANDT
  • FTPT_VARIANT.CURRENCY == TCURC.WAERS
Check Against Plans
  • Personnel Number
  • Trip Number
  • Travel Plan Number (Sequential Number)