1. Home
  2. Resources
  3. SAP Tables
  4. FTPT_VARIANT - Table of Travel Plan Variants

SAP Table FTPT_VARIANT

Table of Travel Plan Variants

FTPT_VARIANT (Table of Travel Plan Variants) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FTPT_VARIANT to other SAP tables.

FTPT_VARIANT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
PERNR Personnel Number PERNR_D NUMC 8 0
REINR Trip Number REINR NUMC 10 0
PLANNR Travel Plan Number (Sequential Number) PLAN_NR FTPT_PLAN NUMC 2 0
VARIANT Plan variant number (sequential number) VARIANT_NR NUMC 2 0
VARIANTVRS Version of travel plan VARIANT_VERSION NUMC 2 0
NAME Variant description VARIANT_NAME CHAR 30 0
PRICE Variant price VARIANT_PRICE CURR 10 2
CURRENCY Currency of variant price VARIANT_CURR TCURC CUKY 5 0
STATUS Variant status VARIANT_STAT CHAR 1 0
0 Open
1 Inactive
2 Active
3 Rejected
R Request
PRICING_STATUS Status of variant price request VARIANT_PRICING_STATUS CHAR 1 0
NULL Open
P Price without ticket element (TST)
T Price with ticket element (TST)
INFO_TXT Information text for variant status VARIANT_STINF CHAR 132 0
TEMPLATE Template indicator VARIANT_TEMPLATE CHAR 1 0
NULL No Template
X Template
B With BahnCard
G With Major Customer Ticket
BOOK_REQUEST Booking flag was started BOOK_REQUEST CHAR 1 0
X Yes
NULL No
REC_LOCATOR Passenger Name Record Locator PNR_RECORD_LOCATOR CHAR 20 0
DB_ORDER_NR Passenger Name Record Locator PNR_RECORD_LOCATOR CHAR 20 0
FLIGHT_CANCELED Indicator: Flight Cancelation Exists FLIGHT_CANCELED CHAR 1 0
X TRUE
NULL FALSE
AGENCYSTATUS Travel Agency Status AGENCY_STATUS CHAR 1 0
RES_SYSTEM Reservation System RESERVATION_SYSTEM CHAR 3 0
LAST_UPDATE UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0

FTPT_VARIANT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FTPT_VARIANT CURRENCY FTPT_VARIANT MANDT TCURC Currency Codes MANDT
FTPT_VARIANT CURRENCY FTPT_VARIANT CURRENCY TCURC Currency Codes WAERS
FTPT_VARIANT PLANNR FTPT_VARIANT PLANNR FTPT_PLAN General Plan Data REINR
FTPT_VARIANT PLANNR FTPT_VARIANT MANDT FTPT_PLAN General Plan Data .INCLUDE
FTPT_VARIANT PLANNR FTPT_VARIANT PERNR FTPT_PLAN General Plan Data MANDT
FTPT_VARIANT PLANNR FTPT_VARIANT REINR FTPT_PLAN General Plan Data PERNR