SAP ABAP Table BW_FI_TV_FLIGHT (Generated Table for View BW_FI_TV_FLIGHT)

Basic Data

Table Category	VIEW	General view structure
General view structure	BW_FI_TV_FLIGHT	Table Relationship Diagram
Short Description	Generated Table for View BW_FI_TV_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	VARIANTE	☑	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	FLIGHT_DATE_DEP	☐	FLIGHT_DATE_DEP	FTPD_DATE	DATS	8	0	Flight departure date
12	FLIGHT_TIME_DEP	☐	FLIGHT_TIME_DEP	FTPD_TIME	TIMS	6	0	Flight departure time
13	FLIGHT_LOC_DEP	☐	FLIGHT_SLOC_DEP	FTPD_IATA_LOCATION	CHAR	3	0	Departure Location	TA21L
14	FLIGHT_LOC_ARR	☐	FLIGHT_SLOC_ARR	FTPD_IATA_LOCATION	CHAR	3	0	Flight Arrival Location	TA21L
15	RESTRICT_FARE	☐	FARE_RESTRICT	CHAR1_X	CHAR	1	0	Restricted airfare
16	FLIGHT_CABIN	☐	FLIGHT_CABIN	FTPD_FLIGHT_CABIN	CHAR	1	0	Flight Cabin Class
17	FLIGHT_RBD	☐	FLIGHT_RBD	FTPD_FLIGHT_RBD	CHAR	1	0	Flight Booking Code (RBD)
18	FLIGHT_STATUS	☐	FLIGHT_STATUS	FTPD_SERVICE_STATUS	CHAR	2	0	Flight Status
19	OP_AIRLINE	☐	FLIGHT_AIRLINE	FTPD_PROVIDER_CODE	CHAR	3	0	Airline	TA21P

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BW_FI_TV_FLIGHT	AIRLINE	TA21P	PROVIDER	REF	1	CN
2	BW_FI_TV_FLIGHT	FLIGHT_LOC_ARR	TA21L	LOCID	REF	1	CN
3	BW_FI_TV_FLIGHT	FLIGHT_LOC_DEP	TA21L	LOCID	REF	1	CN
4	BW_FI_TV_FLIGHT	ITEM	FTPT_ITEM	VARIANTVRS	KEY	1	CN
5	BW_FI_TV_FLIGHT	OP_AIRLINE	TA21P	PROVIDER	REF	1	CN

History

Last changed by/on	SAP	20020108
SAP Release Created in