SAP ABAP Table V_FLIGHT_B (Generated Table for View)

Basic Data

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

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	DESTINATION	☑	PLAN_ZIEL	RZIELORT	CHAR	59	0	Destination of travel plan
6	REASON	☑	RKUNDE	RKUNDE	CHAR	59	0	Reason for Trip (for example, customer/requisitioner)
7	STATUS	☑	PLAN_STATUS	FTPD_PSTAT	CHAR	1	0	Travel Plan Status
8	VARIANT	☑	VARIANT_NR	FTPD_VARIANT_NR	NUMC	2	0	Plan variant number (sequential number)
9	VARIANTVRS	☑	VARIANT_VERSION	FTPD_VARIANT_VERSION	NUMC	2	0	Version of travel plan
10	NAME	☑	VARIANT_NAME	FTPD_VARNAME	CHAR	30	0	Variant description
11	VAR_STATUS	☑	VARIANT_STAT	FTPD_VARSTAT	CHAR	1	0	Variant status
12	BOOK_REQUEST	☑	BOOK_REQUEST	XFELD	CHAR	1	0	Booking flag was started
13	AIRLINE	☑	FLIGHT_AIRLINE	FTPD_PROVIDER_CODE	CHAR	3	0	Airline	TA21P
14	FLIGHT_NR	☑	FLIGHT_NR	FTPD_FLIGHT_NR	CHAR	6	0	Flight Number
15	DATE_DEP	☑	FLIGHT_DATE_DEP	FTPD_DATE	DATS	8	0	Flight departure date
16	TIME_DEP	☑	FLIGHT_TIME_DEP	FTPD_TIME	TIMS	6	0	Flight departure time
17	LOC_DEP	☑	FLIGHT_SLOC_DEP	FTPD_IATA_LOCATION	CHAR	3	0	Departure Location	TA21L
18	DATE_ARR	☑	FLIGHT_DATE_ARR	FTPD_DATE	DATS	8	0	Flight arrival date
19	TIME_ARR	☑	FLIGHT_TIME_ARR	FTPD_TIME	TIMS	6	0	Flight arrival time
20	LOC_ARR	☑	FLIGHT_SLOC_ARR	FTPD_IATA_LOCATION	CHAR	3	0	Flight Arrival Location	TA21L
21	FLI_STATUS	☑	FLIGHT_STATUS	FTPD_SERVICE_STATUS	CHAR	2	0	Flight Status
22	STOP_OVER	☑	FLIGHT_STOP_OVER	FTPD_GEO_ID	CHAR	3	0	Stopover airport
23	L_TIME_ARR	☑	FLIGHT_TIME_ARR	FTPD_TIME	TIMS	6	0	Flight arrival time
24	L_TIME_DEP	☑	FLIGHT_TIME_DEP	FTPD_TIME	TIMS	6	0	Flight departure time
25	STOP_OVER_TIME	☑	FLIGHT_STOP_OVER_TIME	FTPD_TIME	TIMS	6	0	Time of stopover
26	ITEM	☑	ITEMPOS_NR	FTPD_ITEM_ID	NUMC	3	0	Travel Request Item Number (Sequential Number)	FTPT_ITEM
27	SERVICE	☑	FLIGHT_SERVICE_NR	FTPD_FLIGHT_ID	NUMC	3	0	Travel service item number of flight

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_FLIGHT_B	AIRLINE	TA21P	PROVIDER	REF	1	CN
2	V_FLIGHT_B	ITEM	FTPT_ITEM	VARIANTVRS	KEY	1	CN
3	V_FLIGHT_B	LOC_ARR	TA21L	LOCID	REF	1	CN
4	V_FLIGHT_B	LOC_DEP	TA21L	LOCID	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in