SAP ABAP Table FTPT_IMR_HTL (IMR - Hotel)

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_HTL	Table Relationship Diagram
Short Description	IMR - Hotel

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 : Structure to describe Hotel information for Automated
7	HOTEL_SEG_TYPE	☐	API_1A_AIR_SEGMENT_TYPE	FTPD_AIR_SEGMENT_TYPE	NUMC	2	0	AIR : Description of segment type for itinerary portion
8	TATTOO_NUMBER	☐	API_1A_TATTOO_NUMBER		NUMC	4	0	Amadeus unique identifier for each element stored in PNR
9	DISPLAY_NUMBER	☐	API_1A_DISPLAY_NUMBER		NUMC	4	0	Amadeus unique identifier for each element displayed in PNR
10	PROVIDER_CODE	☐			CHAR	4	0
11	STATUS_CODE	☐	API_1A_STATUS_CODE		CHAR	2	0	Real status code from Amadeus
12	NUMBER_OF_ROOMS	☐			NUMC	2	0
13	IN_DATE	☐			DATS	8	0
14	OUT_DATE	☐			DATS	8	0
15	ARPT_CITY_CODE	☐	API_1A_CITY_CODE		CHAR	5	0	5 character code identifying a City Code
16	ARPT_CITY_NAME	☐			CHAR	20	0
17	ROOM_TYPE_CODE	☐	API_1A_HTL_ROOM_TYPE		CHAR	8	0	Room type code for Hotels
18	CURRENCY_CODE	☐	API_1A_CURRENCY_CODE		CHAR	5	0	Currency code
19	RATE_PER_NIGHT	☐			CHAR	10	0
20	RATE_TYPE	☐	API_1A_HTL_RATE_TYPE		CHAR	4	0	Room type code for Hotels
21	RATE_INFO	☐			CHAR	50	0
22	PROPERTY_ID	☐			CHAR	3	0
23	RATE_BOOK_CODE	☐			CHAR	10	0
24	BS_TYPE	☐			CHAR	1	0
25	BS	☐	API_1A_BOOKING_SOURCE		CHAR	10	0	Booking source for reservation identification
26	CONF_NUMBER	☐	API_1A_CONFIRMATION		CHAR	20	0	Confirmation Code returned after Hotel reservation
27	AP_MEALPLAN_RATE	☐			CHAR	20	0
28	CORP_ID_NUMBER	☐	API_1A_CORPORATE_ID		CHAR	25	0	Confirmation Code returned after Hotel reservation
29	CRIB_RATE	☐			CHAR	20	0
30	DEPOSIT_FOP	☐			CHAR	35	0
31	EXTRA_PERS_RATE	☐			CHAR	20	0
32	FA_MEALPLAN_RATE	☐			CHAR	20	0
33	FM_MEALPLAN_RATE	☐			CHAR	20	0
34	GUARANTEE_METHOD	☐			CHAR	35	0
35	MA_MEALPLAN_RATE	☐			CHAR	20	0
36	ADULT_ROLLAWAY	☐			CHAR	20	0
37	CHILD_ROLLAWAY	☐			CHAR	20	0
38	ROOM_OVERRIDE	☐			CHAR	8	0
39	SUPP_INFO	☐			CHAR	50	0
40	HFS_IND	☐			CHAR	1	0
41	ACCOUNT_INFO	☐			CHAR	30	0
42	HOTEL_NAME	☐			CHAR	50	0
43	HOTEL_INFO1	☐			CHAR	60	0
44	HOTEL_INFO2	☐			CHAR	60	0
45	HOTEL_INFO3	☐			CHAR	60	0
46	HOTEL_ADD1	☐			CHAR	60	0
47	HOTEL_ADD2	☐			CHAR	60	0
48	HOTEL_CITY	☐			CHAR	30	0
49	HOTEL_STATECODE	☐			CHAR	3	0
50	HOTEL_COUNTRY	☐			CHAR	30	0
51	HOTEL_ZIP_CODE	☐			CHAR	20	0
52	HOTEL_PHONE	☐			CHAR	30	0
53	HOTEL_FAX	☐			CHAR	30	0
54	HOTEL_TELEX	☐			CHAR	30	0
55	PAST_DATE_IND	☐			CHAR	1	0
56	EXTRA_INFO1	☐			CHAR	30	0
57	EXTRA_INFO2	☐			CHAR	30	0
58	EXTRA_INFO3	☐			CHAR	30	0
59	EXTRA_INFO4	☐			CHAR	30	0

Foreign Keys

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

History

Last changed by/on	SAP	20010720
SAP Release Created in