1. Home
  2. Resources
  3. SAP Tables
  4. FTPT_FLIGHT_FARE - Assignment table: flights <-> rate components

SAP Table FTPT_FLIGHT_FARE

Assignment table: flights <-> rate components

FTPT_FLIGHT_FARE (Assignment table: flights <-> rate components) 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_FLIGHT_FARE to other SAP tables.

Source: FTPT_FLIGHT_FARE (Assignment table: flights <-> rate components)

FTPT_FLIGHT_FARE 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 NUMC 2 0
VARIANT Plan variant number (sequential number) VARIANT_NR NUMC 2 0
VARIANTVRS Version of travel plan VARIANT_VERSION NUMC 2 0
FARE_COMP Rate component FARE_COMP FTPT_FARE_COMP NUMC 3 0
ITEM Travel Request Item Number (Sequential Number) ITEMPOS_NR NUMC 3 0
SERVICE Travel service item number of flight FLIGHT_SERVICE_NR FTPT_FLIGHT NUMC 3 0

FTPT_FLIGHT_FARE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FTPT_FLIGHT_FARE FARE_COMP FTPT_FLIGHT_FARE MANDT FTPT_FARE_COMP Rate components .INCLUDE
FTPT_FLIGHT_FARE FARE_COMP FTPT_FLIGHT_FARE PERNR FTPT_FARE_COMP Rate components MANDT
FTPT_FLIGHT_FARE FARE_COMP FTPT_FLIGHT_FARE REINR FTPT_FARE_COMP Rate components PERNR
FTPT_FLIGHT_FARE FARE_COMP FTPT_FLIGHT_FARE PLANNR FTPT_FARE_COMP Rate components REINR
FTPT_FLIGHT_FARE FARE_COMP FTPT_FLIGHT_FARE VARIANT FTPT_FARE_COMP Rate components PLANNR
FTPT_FLIGHT_FARE FARE_COMP FTPT_FLIGHT_FARE VARIANTVRS FTPT_FARE_COMP Rate components VARIANT
FTPT_FLIGHT_FARE FARE_COMP FTPT_FLIGHT_FARE FARE_COMP FTPT_FARE_COMP Rate components VARIANTVRS
FTPT_FLIGHT_FARE SERVICE FTPT_FLIGHT_FARE MANDT FTPT_FLIGHT Travel Request Item - Flight Service .INCLUDE
FTPT_FLIGHT_FARE SERVICE FTPT_FLIGHT_FARE PERNR FTPT_FLIGHT Travel Request Item - Flight Service MANDT
FTPT_FLIGHT_FARE SERVICE FTPT_FLIGHT_FARE REINR FTPT_FLIGHT Travel Request Item - Flight Service PERNR
FTPT_FLIGHT_FARE SERVICE FTPT_FLIGHT_FARE PLANNR FTPT_FLIGHT Travel Request Item - Flight Service REINR
FTPT_FLIGHT_FARE SERVICE FTPT_FLIGHT_FARE VARIANT FTPT_FLIGHT Travel Request Item - Flight Service PLANNR
FTPT_FLIGHT_FARE SERVICE FTPT_FLIGHT_FARE VARIANTVRS FTPT_FLIGHT Travel Request Item - Flight Service VARIANT
FTPT_FLIGHT_FARE SERVICE FTPT_FLIGHT_FARE ITEM FTPT_FLIGHT Travel Request Item - Flight Service VARIANTVRS
FTPT_FLIGHT_FARE SERVICE FTPT_FLIGHT_FARE SERVICE FTPT_FLIGHT Travel Request Item - Flight Service ITEM