SAP ABAP View V_FTPT_FLIGHT (View of DB Table FTPT_FLIGHT (Flight Segments))

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ FI-TV-PL (Application Component) Travel Planning
     ⤷ PTRP_ADDON (Package) Travel Planning Add-On

Basic Data

View Type	D	Database View
Database View	V_FTPT_FLIGHT
Short Description	View of DB Table FTPT_FLIGHT (Flight Segments)
Root table	FTPT_FLIGHT	Travel Request Item - Flight Service

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	FTPT_FLIGHT	FTPT_FLIGHT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	FTPT_FLIGHT	MANDT		☐	MANDT	☐	Client
2	PERNR	FTPT_FLIGHT	PERNR		☐	PERNR_D	☐	Personnel Number
3	REINR	FTPT_FLIGHT	REINR		☐	REINR	☐	Trip Number
4	PLANNR	FTPT_FLIGHT	PLANNR		☐	PLAN_NR	☐	Travel Plan Number (Sequential Number)
5	VARIANT	FTPT_FLIGHT	VARIANT		☐	VARIANT_NR	☐	Plan variant number (sequential number)
6	VARIANTVRS	FTPT_FLIGHT	VARIANTVRS		☐	VARIANT_VERSION	☐	Version of travel plan
7	ITEM	FTPT_FLIGHT	ITEM		☐	ITEMPOS_NR	☐	Travel Request Item Number (Sequential Number)
8	SERVICE	FTPT_FLIGHT	SERVICE		☐	FLIGHT_SERVICE_NR	☐	Travel service item number of flight
9	AIRLINE	FTPT_FLIGHT	AIRLINE		☐	FLIGHT_AIRLINE	☐	Airline
10	FLIGHT_NR	FTPT_FLIGHT	FLIGHT_NR		☐	FLIGHT_NR	☐	Flight Number
11	DATE_DEP	FTPT_FLIGHT	DATE_DEP		☐	FLIGHT_DATE_DEP	☐	Flight departure date
12	TIME_DEP	FTPT_FLIGHT	TIME_DEP		☐	FLIGHT_TIME_DEP	☐	Flight departure time
13	LOC_DEP	FTPT_FLIGHT	LOC_DEP		☐	FLIGHT_SLOC_DEP	☐	Departure Location
14	TERM_DEP	FTPT_FLIGHT	TERM_DEP		☐	FLIGHT_TERM_DEP	☐	Terminal Code (Departure)
15	GATE_DEP	FTPT_FLIGHT	GATE_DEP		☐	FLIGHT_GATE_DEP	☐	Flight departure terminal
16	DATE_ARR	FTPT_FLIGHT	DATE_ARR		☐	FLIGHT_DATE_ARR	☐	Flight arrival date
17	TIME_ARR	FTPT_FLIGHT	TIME_ARR		☐	FLIGHT_TIME_ARR	☐	Flight arrival time
18	LOC_ARR	FTPT_FLIGHT	LOC_ARR		☐	FLIGHT_SLOC_ARR	☐	Flight Arrival Location
19	TERM_ARR	FTPT_FLIGHT	TERM_ARR		☐	FLIGHT_TERM_ARR	☐	Terminal code (arrival)
20	GATE_ARR	FTPT_FLIGHT	GATE_ARR		☐	FLIGHT_GATE_ARR	☐	Flight arrival terminal
21	RESTRICT_FARE	FTPT_FLIGHT	RESTRICT_FARE		☐	FARE_RESTRICT	☐	Restricted airfare
22	CABIN	FTPT_FLIGHT	CABIN		☐	FLIGHT_CABIN	☐	Flight Cabin Class
23	RBD	FTPT_FLIGHT	RBD		☐	FLIGHT_RBD	☐	Flight Booking Code (RBD)
24	MARRIED	FTPT_FLIGHT	MARRIED		☐	MARRIED_SEGMENT	☐	Married Segments
25	STATUS	FTPT_FLIGHT	STATUS		☐	FLIGHT_STATUS	☐	Flight Status
26	TEMPLATE	FTPT_FLIGHT	TEMPLATE		☐	VARIANT_TEMPLATE	☐	Template indicator
27	PNR_NR	FTPT_FLIGHT	PNR_NR		☐	FLIGHT_LINENUMBER	☐	Line Number of Flight in PNR (if PNR available)
28	ELEC_TKT	FTPT_FLIGHT	ELEC_TKT		☐	FLIGHT_ELEC_TKT	☐	Electronic ticketing for flight is possible
29	PARTICIPATION	FTPT_FLIGHT	PARTICIPATION		☐	FLIGHT_PARTICIPATION	☐	Access type code: Airline
30	CHECKIN_TIME	FTPT_FLIGHT	CHECKIN_TIME		☐	FLIGHT_CHECKIN	☐	Check-in time
31	OP_AIRLINE	FTPT_FLIGHT	OP_AIRLINE		☐	FLIGHT_AIRLINE	☐	Airline
32	PROFILE	FTPT_FLIGHT	PROFILE		☐	PROF_ID	☐	Travel Profile
33	PROFITEM	FTPT_FLIGHT	PROFITEM		☐	PROF_ITEM	☐	Trip rule
34	KZTKT	FTPT_FLIGHT	KZTKT		☐	PLAN_ACTIVITY	☐	Trip Activity Type
35	SPECHID	FTPT_FLIGHT	SPECHID		☐	SSPECID	☐	Class rule
36	PRIORITY	FTPT_FLIGHT	PRIORITY		☐	PROFIL_PRIROITY	☐	Priority of trip rule
37	HIGHEST_PRIORITY	FTPT_FLIGHT	HIGHEST_PRIORITY		☐	PROFIL_PRIROITY	☐	Priority of trip rule
38	BEST_BUY_RC	FTPT_FLIGHT	BEST_BUY_RC		☐	BEST_BUY_REASON_CODE	☐	Indicator: Use 'Best Buy' Reason Codes
39	REASON_CODE	FTPT_FLIGHT	REASON_CODE		☐	REASON_CODE	☐	Reason Code
40	REASON_TEXT	FTPT_FLIGHT	REASON_TEXT		☐	REASON_TEXT	☐	Reason Text

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20050520
SAP Release Created in	600