FTPT_A_FLIGHT - Travel Request Item - Flight Service

Travel Request Item - Flight Service information is stored in SAP table FTPT_A_FLIGHT.
It is part of development package PTRA in software component FI-TV-COS. This development package consists of objects that can be grouped under "Travel Expenses Application Dev. (R/3 Enterprise Core)".

Fields for table FTPT_A_FLIGHT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		FTPS_PLAN	0
MANDT	Client	X	MANDT	CLNT	6	*
PERNR	Personnel Number	X	PERNR_D	NUMC	16
REINR	Trip Number	X	REINR	NUMC	20
PLANNR	Travel Plan Number (Sequential Number)	X	PLAN_NR	NUMC	4	*
VARIANTE	Plan variant number (sequential number)	X	VARIANT_NR	NUMC	4
VARIANTVRS	Version of travel plan	X	VARIANT_VERSION	NUMC	4
ITEM	Travel Request Item Number (Sequential Number)	X	ITEMPOS_NR	NUMC	6
SERVICE	Travel service item number of flight	X	FLIGHT_SERVICE_NR	NUMC	6
AIRLINE	Airline		FLIGHT_AIRLINE	CHAR	6	TA21P
FLIGHT_NR	Flight Number		FLIGHT_NR	CHAR	12
DATE_DEP	Flight departure date		FLIGHT_DATE_DEP	DATS	16
TIME_DEP	Flight departure time		FLIGHT_TIME_DEP	TIMS	12
LOC_DEP	Departure Location		FLIGHT_SLOC_DEP	CHAR	6	TA21L
TERM_DEP	Terminal Code (Departure)		FLIGHT_TERM_DEP	CHAR	4
GATE_DEP	Flight departure terminal		FLIGHT_GATE_DEP	CHAR	12
DATE_ARR	Flight arrival date		FLIGHT_DATE_ARR	DATS	16
TIME_ARR	Flight arrival time		FLIGHT_TIME_ARR	TIMS	12
LOC_ARR	Flight Arrival Location		FLIGHT_SLOC_ARR	CHAR	6	TA21L
TERM_ARR	Terminal code (arrival)		FLIGHT_TERM_ARR	CHAR	4
GATE_ARR	Flight arrival terminal		FLIGHT_GATE_ARR	CHAR	12
RESTRICT_FARE	Restricted airfare		FARE_RESTRICT	CHAR	2
CABIN	Flight Cabin Class		FLIGHT_CABIN	CHAR	2
RBD	Flight Booking Code (RBD)		FLIGHT_RBD	CHAR	2
MARRIED	Married Segments		MARRIED_SEGMENT	INT1	1
STATUS	Flight Status		FLIGHT_STATUS	CHAR	4
TEMPLATE	Template indicator		VARIANT_TEMPLATE	CHAR	2
PNR_NR	Line Number of Flight in PNR (if PNR available)		FLIGHT_LINENUMBER	INT2	2
ELEC_TKT	Electronic ticketing for flight is possible		FLIGHT_ELEC_TKT	CHAR	2
PARTICIPATION	Access type code: Airline		FLIGHT_PARTICIPATION	CHAR	10
CHECKIN_TIME	Check-in time		FLIGHT_CHECKIN	TIMS	12
OP_AIRLINE	Airline		FLIGHT_AIRLINE	CHAR	6	TA21P
PROFILE	Travel Profile		PROF_ID	CHAR	16	TA20P
PROFITEM	Trip rule		PROF_ITEM	CHAR	16	TA20PI
KZTKT	Trip Activity Type		PLAN_ACTIVITY	CHAR	2
SPECHID	Class rule		SSPECID	CHAR	16	TA20PS
PRIORITY	Priority of trip rule		PROFIL_PRIROITY	CHAR	2
HIGHEST_PRIORITY	Priority of trip rule		PROFIL_PRIROITY	CHAR	2
BEST_BUY_RC	Indicator: Use 'Best Buy' Reason Codes		BEST_BUY_REASON_CODE	CHAR	2
.INCLUDE				FTPS_REASON_CODE	0
REASON_CODE	Reason Code		REASON_CODE	CHAR	4	*
REASON_TEXT	Reason Text		REASON_TEXT	CHAR	264