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

History

Last changed by/on	SAP	20110901
SAP Release Created in	461