SAP ABAP View V_FLIGHT_A (Display Flight Segments)

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

View Type	D	Database View
Database View	V_FLIGHT_A
Short Description	Display Flight Segments
Root table	PTRV_HEAD	General Trip Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	PTRV_HEAD	PTRV_HEAD
2	FTPT_PLAN
3	FTPT_VARIANT
4	FTPT_ITEM
5	FTPT_FLIGHT
6	FTPT_FLIGHT_LEG

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	PTRV_HEAD	MANDT	JL	EQ				0	0
2	FTPT_PLAN	MANDT	JR	EQ			AND	0	0
3	PTRV_HEAD	PERNR	JL	EQ				0	0
4	FTPT_PLAN	PERNR	JR	EQ			AND	0	0
5	PTRV_HEAD	REINR	JL	EQ				0	0
6	FTPT_PLAN	REINR	JR	EQ			AND	0	0
7	FTPT_PLAN	MANDT	JL	EQ				0	0
8	FTPT_VARIANT	MANDT	JR	EQ			AND	0	0
9	FTPT_PLAN	PERNR	JL	EQ				0	0
10	FTPT_VARIANT	PERNR	JR	EQ			AND	0	0
11	FTPT_PLAN	REINR	JL	EQ				0	0
12	FTPT_VARIANT	REINR	JR	EQ			AND	0	0
13	FTPT_PLAN	PLANNR	JL	EQ				0	0
14	FTPT_VARIANT	PLANNR	JR	EQ			AND	0	0
15	FTPT_VARIANT	MANDT	JL	EQ				0	0
16	FTPT_ITEM	MANDT	JR	EQ			AND	0	0
17	FTPT_VARIANT	PERNR	JL	EQ				0	0
18	FTPT_ITEM	PERNR	JR	EQ			AND	0	0
19	FTPT_VARIANT	REINR	JL	EQ				0	0
20	FTPT_ITEM	REINR	JR	EQ			AND	0	0
21	FTPT_VARIANT	PLANNR	JL	EQ				0	0
22	FTPT_ITEM	PLANNR	JR	EQ			AND	0	0
23	FTPT_VARIANT	VARIANT	JL	EQ				0	0
24	FTPT_ITEM	VARIANT	JR	EQ			AND	0	0
25	FTPT_VARIANT	VARIANTVRS	JL	EQ				0	0
26	FTPT_ITEM	VARIANTVRS	JR	EQ			AND	0	0
27	FTPT_ITEM	MANDT	JL	EQ				0	0
28	FTPT_FLIGHT	MANDT	JR	EQ			AND	0	0
29	FTPT_ITEM	PERNR	JL	EQ				0	0
30	FTPT_FLIGHT	PERNR	JR	EQ			AND	0	0
31	FTPT_ITEM	REINR	JL	EQ				0	0
32	FTPT_FLIGHT	REINR	JR	EQ			AND	0	0
33	FTPT_ITEM	PLANNR	JL	EQ				0	0
34	FTPT_FLIGHT	PLANNR	JR	EQ			AND	0	0
35	FTPT_ITEM	VARIANT	JL	EQ				0	0
36	FTPT_FLIGHT	VARIANT	JR	EQ			AND	0	0
37	FTPT_ITEM	VARIANTVRS	JL	EQ				0	0
38	FTPT_FLIGHT	VARIANTVRS	JR	EQ			AND	0	0
39	FTPT_ITEM	ITEM	JL	EQ				0	0
40	FTPT_FLIGHT	ITEM	JR	EQ			AND	0	0
41	FTPT_FLIGHT	MANDT	JL	EQ				0	0
42	FTPT_FLIGHT_LEG	MANDT	JR	EQ			AND	0	0
43	FTPT_FLIGHT	PERNR	JL	EQ				0	0
44	FTPT_FLIGHT_LEG	PERNR	JR	EQ			AND	0	0
45	FTPT_FLIGHT	REINR	JL	EQ				0	0
46	FTPT_FLIGHT_LEG	REINR	JR	EQ			AND	0	0
47	FTPT_FLIGHT	PLANNR	JL	EQ				0	0
48	FTPT_FLIGHT_LEG	PLANNR	JR	EQ			AND	0	0
49	FTPT_FLIGHT	VARIANT	JL	EQ				0	0
50	FTPT_FLIGHT_LEG	VARIANT	JR	EQ			AND	0	0
51	FTPT_FLIGHT	VARIANTVRS	JL	EQ				0	0
52	FTPT_FLIGHT_LEG	VARIANTVRS	JR	EQ			AND	0	0
53	FTPT_FLIGHT	ITEM	JL	EQ				0	0
54	FTPT_FLIGHT_LEG	ITEM	JR	EQ			AND	0	0
55	FTPT_FLIGHT	SERVICE	JL	EQ				0	0
56	FTPT_FLIGHT_LEG	SERVICE	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	PERNR	PTRV_HEAD	PERNR		☐	PERNR_D	☐	Personnel Number
2	REINR	PTRV_HEAD	REINR		☐	REINR	☐	Trip Number
3	PLANNR	FTPT_PLAN	PLANNR		☐	PLAN_NR	☐	Travel Plan Number (Sequential Number)
4	DESTINATION	FTPT_PLAN	DESTINATION		☐	PLAN_ZIEL	☐	Destination of travel plan
5	REASON	FTPT_PLAN	REASON		☐	RKUNDE	☐	Reason for Trip (for example, customer/requisitioner)
6	STATUS	FTPT_PLAN	STATUS		☐	PLAN_STATUS	☐	Travel Plan Status
7	VARIANT	FTPT_VARIANT	VARIANT		☐	VARIANT_NR	☐	Plan variant number (sequential number)
8	VARIANTVRS	FTPT_VARIANT	VARIANTVRS		☐	VARIANT_VERSION	☐	Version of travel plan
9	NAME	FTPT_VARIANT	NAME		☐	VARIANT_NAME	☐	Variant description
10	VAR_STATUS	FTPT_VARIANT	STATUS		☐	VARIANT_STAT	☐	Variant status
11	BOOK_REQUEST	FTPT_VARIANT	BOOK_REQUEST		☐	BOOK_REQUEST	☐	Booking flag was started
12	AIRLINE	FTPT_FLIGHT	AIRLINE		☐	FLIGHT_AIRLINE	☐	Airline
13	FLIGHT_NR	FTPT_FLIGHT	FLIGHT_NR		☐	FLIGHT_NR	☐	Flight Number
14	DATE_DEP	FTPT_FLIGHT	DATE_DEP		☐	FLIGHT_DATE_DEP	☐	Flight departure date
15	TIME_DEP	FTPT_FLIGHT	TIME_DEP		☐	FLIGHT_TIME_DEP	☐	Flight departure time
16	LOC_DEP	FTPT_FLIGHT	LOC_DEP		☐	FLIGHT_SLOC_DEP	☐	Departure Location
17	DATE_ARR	FTPT_FLIGHT	DATE_ARR		☐	FLIGHT_DATE_ARR	☐	Flight arrival date
18	TIME_ARR	FTPT_FLIGHT	TIME_ARR		☐	FLIGHT_TIME_ARR	☐	Flight arrival time
19	LOC_ARR	FTPT_FLIGHT	LOC_ARR		☐	FLIGHT_SLOC_ARR	☐	Flight Arrival Location
20	FLI_STATUS	FTPT_FLIGHT	STATUS		☐	FLIGHT_STATUS	☐	Flight Status
21	STOP_OVER	FTPT_FLIGHT_LEG	STOP_OVER		☐	FLIGHT_STOP_OVER	☐	Stopover airport
22	L_TIME_ARR	FTPT_FLIGHT_LEG	TIME_ARR		☐	FLIGHT_TIME_ARR	☐	Flight arrival time
23	L_TIME_DEP	FTPT_FLIGHT_LEG	TIME_DEP		☐	FLIGHT_TIME_DEP	☐	Flight departure time
24	STOP_OVER_TIME	FTPT_FLIGHT_LEG	STOP_OVER_TIME		☐	FLIGHT_STOP_OVER_TIME	☐	Time of stopover
25	ITEM	FTPT_FLIGHT	ITEM		☐	ITEMPOS_NR	☐	Travel Request Item Number (Sequential Number)
26	SERVICE	FTPT_FLIGHT	SERVICE		☐	FLIGHT_SERVICE_NR	☐	Travel service item number of flight

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	20130529
SAP Release Created in