SAP ABAP Table V_FTPT_FLIGHT (Generated Table for View V_FTPT_FLIGHT)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_FTPT_FLIGHT	Table Relationship Diagram
Short Description	Generated Table for View V_FTPT_FLIGHT

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

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

History

Last changed by/on	SAP	20050520
SAP Release Created in