SAP ABAP Table FTPT_IMR_HTL_DIR (IMR - Hotel (Direct Access))

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_DIR	Table Relationship Diagram
Short Description	IMR - Hotel (Direct Access)

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 Flight 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	11	0
20	RATE_INFO	☐			CHAR	1	0
21	BS_TYPE	☐			CHAR	1	0
22	BS	☐	API_1A_BOOKING_SOURCE		CHAR	10	0	Booking source for reservation identification
23	CONF_NUMBER	☐	API_1A_CONFIRMATION		CHAR	20	0	Confirmation Code returned after Hotel reservation
24	LIST_OF_OPTIONS	☐			CHAR	200	0
25	PAST_DATE_IND	☐			CHAR	1	0

Foreign Keys

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

History

Last changed by/on	SAP	20010720
SAP Release Created in