SAP ABAP Table FTPT_IMR_FLIGHT (IMR - Flight)

Hierarchy

☛ SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   ⤷ FI-TV-PL (Application Component) Travel Planning
     ⤷ PTRI (Package) Interfaces for Travel Planning

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FTPT_IMR_FLIGHT	Table Relationship Diagram
Short Description	IMR - Flight

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	Key for Information Management record
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	RECORD_LOCATOR	☑	PNR_RECORD_LOCATOR	FTPD_PNR_RECORD_LOCATOR	CHAR	20	0	Passenger Name Record Locator
4	AIR_NUMBER	☑	AIR_RECORD_NUMBER		NUMC	12	0	Air record unique identifier	FTPT_IMR
5	RUNNING_NUMBER	☑	RUNNING_NUMBER	FTPD_RUNNING_NUMBER	NUMC	4	0	Index
6	.INCLUDE	☐				0	0	AIR : Flight Information
7	TKT_SEG_IND	☐			CHAR	1	0
8	FLIGHT_SEG_TYPE	☐	API_1A_AIR_SEGMENT_TYPE	FTPD_AIR_SEGMENT_TYPE	NUMC	2	0	AIR : Description of segment type for itinerary portion
9	TATTOO_NB	☐	API_1A_TATTOO_NUMBER		NUMC	4	0	Amadeus unique identifier for each element stored in PNR
10	DISPLAY_NB	☐	API_1A_DISPLAY_NUMBER		NUMC	4	0	Amadeus unique identifier for each element displayed in PNR
11	OPEN_SEG_IND	☐			CHAR	1	0
12	STOPOVER_IND	☐			CHAR	1	0
13	DEPARTURE_ARPT	☐	API_1A_AIRPORT_CODE		CHAR	5	0	Airport code definition
14	ARRIVAL_ARPT	☐	API_1A_AIRPORT_CODE		CHAR	5	0	Airport code definition
15	AIRLINE_CODE	☐	API_1A_AIRLINE_CODE		CHAR	5	0	Airline Code definition
16	FLIGHT_NB	☐	API_1A_FLIGHT_NUMBER		CHAR	5	0	Flight number definition
17	CLASS_OF_SERVICE	☐	API_1A_CLASS_TYPE		CHAR	2	0	Class type definition
18	CLASS_OF_BOOKING	☐	API_1A_CLASS_TYPE		CHAR	2	0	Class type definition
19	DEPARTURE_DATE	☐			DATS	8	0
20	DEPARTURE_TIME	☐			TIMS	6	0
21	ARRIVAL_DATE	☐			DATS	8	0
22	ARRIVAL_TIME	☐			TIMS	6	0
23	RAW_STATUS_CODE	☐	API_1A_RAW_STATUS_CODE		CHAR	5	0	Raw descrition of amadeus Status Code with Number in Party
24	MEAL_CODE	☐	API_1A_MEAL_CODE		CHAR	3	0	Amadeus Meal Code
25	NB_OF_STOPS	☐			NUMC	1	0
26	EQUIPMENT_TYPE	☐	API_1A_EQUIPMENT_TYPE	FTPD_EQUIPMENT_TYPE	CHAR	3	0	Amadeus equipment type code
27	ENTERTAIN_CODE	☐			CHAR	1	0
28	BAG_ALLOWANCE	☐	API_1A_BAGGAGE_ALLOWANCE		CHAR	3	0	Baggage allowance description
29	CHECK_IN_TERM	☐	API_1A_TERMINAL_CODE		CHAR	2	0	Terminal Code
30	CHECK_IN_TIME	☐			TIMS	6	0
31	E_TKT_IND	☐			CHAR	1	0
32	FLIGHT_DURATION	☐	API_1A_FLIGHT_DURATION		CHAR	5	0	Flight duration in Format : HH:MM
33	NON_SMOKING_IND	☐			CHAR	1	0
34	SHARED_COMM_CXR	☐			CHAR	50	0
35	TOUR_SEGMENT_TAG	☐			CHAR	6	0
36	FLOWN_IND	☐			CHAR	1	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTPT_IMR_FLIGHT	AIR_NUMBER	FTPT_IMR	RECORD_LOCATOR	KEY	1	CN

History

Last changed by/on	SAP	20010720
SAP Release Created in