SAP ABAP Table FTPT_FLIGHT (Travel Request Item - Flight Service)

Hierarchy

☛ SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   ⤷ FI-TV-PL (Application Component) Travel Planning
     ⤷ PTRP (Package) Travel Planning

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FTPT_FLIGHT	Table Relationship Diagram
Short Description	Travel Request Item - Flight Service

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	Key to travel plan table
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	PERNR	☑	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	REINR	☑	REINR	REINR	NUMC	10	0	Trip Number
5	PLANNR	☑	PLAN_NR	FTPD_PLAN_NR	NUMC	2	0	Travel Plan Number (Sequential Number)	*
6	VARIANT	☑	VARIANT_NR	FTPD_VARIANT_NR	NUMC	2	0	Plan variant number (sequential number)
7	VARIANTVRS	☑	VARIANT_VERSION	FTPD_VARIANT_VERSION	NUMC	2	0	Version of travel plan	*
8	ITEM	☑	ITEMPOS_NR	FTPD_ITEM_ID	NUMC	3	0	Travel Request Item Number (Sequential Number)	FTPT_ITEM
9	SERVICE	☑	FLIGHT_SERVICE_NR	FTPD_FLIGHT_ID	NUMC	3	0	Travel service item number of flight
10	AIRLINE	☐	FLIGHT_AIRLINE	FTPD_PROVIDER_CODE	CHAR	3	0	Airline	TA21P
11	FLIGHT_NR	☐	FLIGHT_NR	FTPD_FLIGHT_NR	CHAR	6	0	Flight Number
12	DATE_DEP	☐	FLIGHT_DATE_DEP	FTPD_DATE	DATS	8	0	Flight departure date
13	TIME_DEP	☐	FLIGHT_TIME_DEP	FTPD_TIME	TIMS	6	0	Flight departure time
14	LOC_DEP	☐	FLIGHT_SLOC_DEP	FTPD_IATA_LOCATION	CHAR	3	0	Departure Location	TA21L
15	TERM_DEP	☐	FLIGHT_TERM_DEP	FTPD_TERMINAL	CHAR	2	0	Terminal Code (Departure)
16	GATE_DEP	☐	FLIGHT_GATE_DEP	FTPD_FLIGHT_GATE	CHAR	6	0	Flight departure terminal
17	DATE_ARR	☐	FLIGHT_DATE_ARR	FTPD_DATE	DATS	8	0	Flight arrival date
18	TIME_ARR	☐	FLIGHT_TIME_ARR	FTPD_TIME	TIMS	6	0	Flight arrival time
19	LOC_ARR	☐	FLIGHT_SLOC_ARR	FTPD_IATA_LOCATION	CHAR	3	0	Flight Arrival Location	TA21L
20	TERM_ARR	☐	FLIGHT_TERM_ARR	FTPD_TERMINAL	CHAR	2	0	Terminal code (arrival)
21	GATE_ARR	☐	FLIGHT_GATE_ARR	FTPD_FLIGHT_GATE	CHAR	6	0	Flight arrival terminal
22	RESTRICT_FARE	☐	FARE_RESTRICT	CHAR1_X	CHAR	1	0	Restricted airfare
23	CABIN	☐	FLIGHT_CABIN	FTPD_FLIGHT_CABIN	CHAR	1	0	Flight Cabin Class
24	RBD	☐	FLIGHT_RBD	FTPD_FLIGHT_RBD	CHAR	1	0	Flight Booking Code (RBD)
25	MARRIED	☐	MARRIED_SEGMENT	FTPD_MARRIED_SEG	INT1	3	0	Married Segments
26	STATUS	☐	FLIGHT_STATUS	FTPD_SERVICE_STATUS	CHAR	2	0	Flight Status
27	TEMPLATE	☐	VARIANT_TEMPLATE	FTPD_TEMPLATE	CHAR	1	0	Template indicator
28	PNR_NR	☐	FLIGHT_LINENUMBER	FTPD_PNR_NR	INT2	5	0	Line Number of Flight in PNR (if PNR available)	FTPT_PNR
29	ELEC_TKT	☐	FLIGHT_ELEC_TKT	CHAR1_X	CHAR	1	0	Electronic ticketing for flight is possible
30	PARTICIPATION	☐	FLIGHT_PARTICIPATION	FTPD_PARTICIPATION	CHAR	5	0	Access type code: Airline
31	CHECKIN_TIME	☐	FLIGHT_CHECKIN	FTPD_TIME	TIMS	6	0	Check-in time
32	OP_AIRLINE	☐	FLIGHT_AIRLINE	FTPD_PROVIDER_CODE	CHAR	3	0	Airline	TA21P
33	PROFILE	☐	PROF_ID	FTPD_PROF_ID	CHAR	8	0	Travel Profile	TA20P
34	PROFITEM	☐	PROF_ITEM	FTPD_PROF_ITEM	CHAR	8	0	Trip rule	TA20PI
35	KZTKT	☐	PLAN_ACTIVITY	FTPD_PLAN_ACTIVITY	CHAR	1	0	Trip Activity Type	*
36	SPECHID	☐	SSPECID	FTPD_SSPEC_ID	CHAR	8	0	Class rule	TA20PS
37	PRIORITY	☐	PROFIL_PRIROITY	FTPD_PROF_PRIORITY	CHAR	1	0	Priority of trip rule
38	HIGHEST_PRIORITY	☐	PROFIL_PRIROITY	FTPD_PROF_PRIORITY	CHAR	1	0	Priority of trip rule
39	BEST_BUY_RC	☐	BEST_BUY_REASON_CODE	FTPD_BEST_BUY_REASON_CODE	CHAR	1	0	Indicator: Use 'Best Buy' Reason Codes
40	.INCLUDE	☐				0	0	Reason Code
41	REASON_CODE	☐	REASON_CODE	FTPD_REASON_CODE	CHAR	2	0	Reason Code	*
42	REASON_TEXT	☐	REASON_TEXT	TEXT132	CHAR	132	0	Reason Text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTPT_FLIGHT	AIRLINE	TA21P	PROVIDER	REF	1	CN
2	FTPT_FLIGHT	ITEM	FTPT_ITEM	VARIANTVRS	KEY	1	CN
3	FTPT_FLIGHT	LOC_ARR	TA21L	LOCID	REF	1	CN
4	FTPT_FLIGHT	LOC_DEP	TA21L	LOCID	REF	1	CN
5	FTPT_FLIGHT	OP_AIRLINE	TA21P	PROVIDER	REF	1	CN
6	FTPT_FLIGHT	PNR_NR	FTPT_PNR	VARIANTVRS	REF	1	CN
7	FTPT_FLIGHT	PROFILE	TA20P	PROFILE	REF	C	CN
8	FTPT_FLIGHT	PROFITEM	TA20PI	PROFITEM	REF	C	CN
9	FTPT_FLIGHT	SPECHID	TA20PS	SPECID	REF	C	CN

History

Last changed by/on	SAP	20020219
SAP Release Created in