SAP ABAP View BW_FI_TV_FLIGHT (View for Table FTPT_FLIGHT)

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ FI-TV (Application Component) Travel Management
     ⤷ FTBW (Package) Data Transfer FI-TV to BW

Basic Data

View Type	D	Database View
Database View	BW_FI_TV_FLIGHT
Short Description	View for Table FTPT_FLIGHT
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	VARIANTE	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	FLIGHT_DATE_DEP	FTPT_FLIGHT	DATE_DEP		☐	FLIGHT_DATE_DEP	☐	Flight departure date
12	FLIGHT_TIME_DEP	FTPT_FLIGHT	TIME_DEP		☐	FLIGHT_TIME_DEP	☐	Flight departure time
13	FLIGHT_LOC_DEP	FTPT_FLIGHT	LOC_DEP		☐	FLIGHT_SLOC_DEP	☐	Departure Location
14	FLIGHT_LOC_ARR	FTPT_FLIGHT	LOC_ARR		☐	FLIGHT_SLOC_ARR	☐	Flight Arrival Location
15	RESTRICT_FARE	FTPT_FLIGHT	RESTRICT_FARE		☐	FARE_RESTRICT	☐	Restricted airfare
16	FLIGHT_CABIN	FTPT_FLIGHT	CABIN		☐	FLIGHT_CABIN	☐	Flight Cabin Class
17	FLIGHT_RBD	FTPT_FLIGHT	RBD		☐	FLIGHT_RBD	☐	Flight Booking Code (RBD)
18	FLIGHT_STATUS	FTPT_FLIGHT	STATUS		☐	FLIGHT_STATUS	☐	Flight Status
19	OP_AIRLINE	FTPT_FLIGHT	OP_AIRLINE		☐	FLIGHT_AIRLINE	☐	Airline

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