SAP ABAP Table FTPT_QT_FLIGHT (Quicktrip Travel Request Item - Flight Service)

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

Table Category	TRANSP	Transparent table
Transparent table	FTPT_QT_FLIGHT	Table Relationship Diagram
Short Description	Quicktrip Travel Request Item - Flight Service

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	QTNR	☑	QTNR	FTPD_QTNR	NUMC	5	0	Quicktrip Number
3	ITEM	☑	ITEMPOS_NR	FTPD_ITEM_ID	NUMC	3	0	Travel Request Item Number (Sequential Number)	*
4	ITEM_ALTERN	☑	ALTERNPOS_NR	FTPD_ITEM_ID	NUMC	3	0	Alternative Line Item Number	*
5	SERVICE	☑	FLIGHT_SERVICE_NR	FTPD_FLIGHT_ID	NUMC	3	0	Travel service item number of flight	*
6	SERVICE_ALTERN	☑	FLIGHT_ALTERN_NR	FTPD_FLIGHT_ID	NUMC	3	0	Alternative Flight Number	*
7	AIRLINE	☐	FLIGHT_AIRLINE	FTPD_PROVIDER_CODE	CHAR	3	0	Airline	TA21P
8	FLIGHT_NR	☐	FLIGHT_NR	FTPD_FLIGHT_NR	CHAR	6	0	Flight Number
9	DATE_DEP	☐	FLIGHT_DATE_DEP	FTPD_DATE	DATS	8	0	Flight departure date
10	TIME_DEP	☐	FLIGHT_TIME_DEP	FTPD_TIME	TIMS	6	0	Flight departure time
11	LOC_DEP	☐	FLIGHT_SLOC_DEP	FTPD_IATA_LOCATION	CHAR	3	0	Departure Location	TA21L
12	DATE_ARR	☐	FLIGHT_DATE_ARR	FTPD_DATE	DATS	8	0	Flight arrival date
13	TIME_ARR	☐	FLIGHT_TIME_ARR	FTPD_TIME	TIMS	6	0	Flight arrival time
14	LOC_ARR	☐	FLIGHT_SLOC_ARR	FTPD_IATA_LOCATION	CHAR	3	0	Flight Arrival Location	TA21L
15	CABIN	☐	FLIGHT_CABIN	FTPD_FLIGHT_CABIN	CHAR	1	0	Flight Cabin Class
16	RBD	☐	FLIGHT_RBD	FTPD_FLIGHT_RBD	CHAR	1	0	Flight Booking Code (RBD)
17	NEGO	☐	QTRIP_NEGO	FTPD_NEGO	CHAR	1	0	Quicktrip Nego Data Element

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTPT_QT_FLIGHT	AIRLINE	TA21P	PROVIDER	REF	1	CN
2	FTPT_QT_FLIGHT	LOC_ARR	TA21L	LOCID
3	FTPT_QT_FLIGHT	LOC_DEP	TA21L	LOCID	REF	1	CN

History

Last changed by/on	SAP	20010720
SAP Release Created in	46B