SAP ABAP Table FTPS_PNR_HOTEL_RES_OUT (PNR Hotel)

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	INTTAB	Structure
Structure	FTPS_PNR_HOTEL_RES_OUT	Table Relationship Diagram
Short Description	PNR Hotel

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	LINE_NUMBER	☐			INT2	5	0
2	.INCLUDE	☐				0	0	PNR Hotel
3	CHAIN_CODE	☐	HOTEL_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	Hotel Chain	*
4	LOCATION	☐	HOTEL_SLOCATION	FTPD_IATA_LOCATION	CHAR	3	0	Hotel Location	*
5	PROPERTY_CODE	☐	HOTEL_PROPERTY	FTPD_HOTEL_PROP	CHAR	6	0	Hotel Code (Key for an Individual Hotel)
6	CHECKIN_DATE	☐	HOTEL_DATE_ARR	FTPD_DATE	DATS	8	0	Arrival Date Hotel
7	CHECKIN_TIME	☐			TIMS	6	0
8	CHECKOUT_DATE	☐	HOTEL_DATE_DEP	FTPD_DATE	DATS	8	0	Departure Date Hotel
9	CHECKOUT_TIME	☐			TIMS	6	0
10	NAME	☐	HOTEL_NAME	TEXT40	CHAR	40	0	Name of Hotel
11	NUMBER_OF_ROOMS	☐	HOTEL_NUMBER_OF_ROOMS	FTPD_INT1	INT1	3	0	Number of Hotel Rooms
12	OCCUPANCY	☐	HOTEL_OCCUPANCY	FTPD_INT1	INT1	3	0	Number of hotel occupants
13	STATUS_CODE	☐	HOTEL_STATUS	FTPD_SERVICE_STATUS	CHAR	2	0	Hotel Status
14	ROOMTYPE	☐	HOTEL_ROOMTYPE	FTPD_HOTEL_ROOMTYPE	CHAR	1	0	Hotel Room Type
15	BEDS	☐	HOTEL_NUMBER_OF_BEDS	CHAR1	CHAR	1	0	Number of Beds
16	BED_TYPE	☐	HOTEL_BEDDING_TYPE	FTPD_BEDDING_TYPE	CHAR	1	0	Bed Type
17	ROOM_RATE_CODE	☐	HOTEL_ROOM_RATE_CODE	CHAR3	CHAR	3	0	Rate Code (Hotel-Specific)
18	RATE_CODE	☐	HOTEL_RATE_PLAN_CODE	FTPD_HOTEL_RATE_CODE	CHAR	3	0	Hotel Rate Category	*
19	BOOKING_CODE	☐	HOTEL_BOOKING_CODE	FTPD_HOTEL_BOOKING_CODE	CHAR	10	0	Reservation Code for a Hotel Room
20	CONFIRMATION_NR	☐	HOTEL_CONFIRMATION_NUMBER	FTPD_HOTEL_CONF_NUMBER	CHAR	17	0	Hotel Reservation Number
21	BOOKING_SOURCE	☐	BOOKING_SOURCE	CHAR40	CHAR	40	0	Identification for booking/reservations
22	CORPORATE_ID	☐	HOTEL_CORPORATE_ID	FTPD_CORPORATION_ID	CHAR	30	0	Company identification for room reservation
23	MEMBERSHIP_ID	☐	PROV_PROGRAM_NR	CHAR20	CHAR	20	0	Customer number
24	SUPPLEMENTAL_INFO	☐	HOTEL_ADD_INFO	FTPD_INFO	CHAR	132	0	Additional hotel information
25	NAME_IN_SEG	☐			CHAR	40	0
26	TOTAL_RATE_IND	☐	HOTEL_TOTAL_RATE_IND	CHAR1_X	CHAR	1	0	Total price
27	RATE_QUOTE_RATE	☐	HOTEL_RATE	FTPD_PRICE	CURR	10	2	Rate/Price Per Night
28	RATE_QUOTE_CURR	☐	HOTEL_CURRENCY	WAERS	CUKY	5	0	Currency	*
29	DEPOSIT_CREDIT_CARD_CODE	☐			CHAR	3	0
30	DEPOSIT_CREDIT_CARD_NUMBER	☐			CHAR	21	0
31	DEPOSIT_CREDIT_CARD_DATE	☐			DATS	8	0
32	DEPOSIT_AMOUNT	☐			CURR	10	2
33	DEPOSIT_CURR	☐			CUKY	5	0
34	GUARANTEE_CREDIT_CARD_VENDOR	☐			CHAR	3	0
35	GUARANTEE_CREDIT_CARD_NUMBER	☐			CHAR	21	0
36	GUARANTEE_CREDIT_CARD_DATE	☐			DATS	8	0
37	GUARANTEE_AMOUNT	☐			CURR	10	2
38	GUARANTEE_CURR	☐			CUKY	5	0
39	COMP_ACC_SELL	☐	COMPLETE_ACCESS_IND	FTPD_BOOLEAN	CHAR	1	0	Direct Access to Reservation System of Hotel
40	PASSENGER_ID	☐			INT2	5	0

History

Last changed by/on	SAP	20040518
SAP Release Created in	46C