SAP ABAP Table FTPT_HOTEL (Travel Request Item - Hotel Service)

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	TRANSP	Transparent table
Transparent table	FTPT_HOTEL	Table Relationship Diagram
Short Description	Travel Request Item - Hotel Service

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	.INCLUDE	☑				0	0	Key to travel plan table
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	PERNR	☑	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	REINR	☑	REINR	REINR	NUMC	10	0	Trip Number
5	PLANNR	☑	PLAN_NR	FTPD_PLAN_NR	NUMC	2	0	Travel Plan Number (Sequential Number)	*
6	VARIANT	☑	VARIANT_NR	FTPD_VARIANT_NR	NUMC	2	0	Plan variant number (sequential number)
7	VARIANTVRS	☑	VARIANT_VERSION	FTPD_VARIANT_VERSION	NUMC	2	0	Version of travel plan	*
8	ITEM	☑	ITEMPOS_NR	FTPD_ITEM_ID	NUMC	3	0	Travel Request Item Number (Sequential Number)	FTPT_ITEM
9	SERVICE	☑	HOTEL_SERVICE_NR	FTPD_HOTEL_ID	NUMC	3	0	Hotel number
10	HOTEL	☐	HOTEL_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	Hotel Chain	TA21P
11	PROPERTY	☐	HOTEL_PROPERTY	FTPD_HOTEL_PROP	CHAR	6	0	Hotel Code (Key for an Individual Hotel)
12	DATE_ARR	☐	HOTEL_DATE_ARR	FTPD_DATE	DATS	8	0	Arrival Date Hotel
13	DATE_DEP	☐	HOTEL_DATE_DEP	FTPD_DATE	DATS	8	0	Departure Date Hotel
14	LOC	☐	HOTEL_SLOCATION	FTPD_IATA_LOCATION	CHAR	3	0	Hotel Location	TA21L
15	NAME	☐	HOTEL_NAME	TEXT40	CHAR	40	0	Name of Hotel
16	ADDRESS	☐	HOTEL_ADDRESS	TEXT132	CHAR	132	0	Hotel Address (address string separated by #)
17	CLASS	☐	HOTEL_CLASS	FTPD_HOTEL_CLASS	CHAR	1	0	Hotel category
18	ROOMTYPE	☐	HOTEL_ROOMTYPE	FTPD_HOTEL_ROOMTYPE	CHAR	1	0	Hotel Room Type
19	MEALS	☐	HOTEL_MEALS	FTPD_HOTEL_MEALS	CHAR	1	0	Hotel Meals
20	OCCUPANCY	☐	HOTEL_OCCUPANCY	FTPD_INT1	INT1	3	0	Number of hotel occupants
21	ROOMS	☐	HOTEL_NUMBER_OF_ROOMS	FTPD_INT1	INT1	3	0	Number of Hotel Rooms
22	BEDS	☐	HOTEL_NUMBER_OF_BEDS	CHAR1	CHAR	1	0	Number of Beds
23	BED_TYPE	☐	HOTEL_BEDDING_TYPE	FTPD_BEDDING_TYPE	CHAR	1	0	Bed Type
24	ROOM_RATE_CODE	☐	HOTEL_ROOM_RATE_CODE	CHAR3	CHAR	3	0	Rate Code (Hotel-Specific)
25	RATE_CODE	☐	HOTEL_RATE_PLAN_CODE	FTPD_HOTEL_RATE_CODE	CHAR	3	0	Hotel Rate Category	*
26	RATE_CHANGE_IND	☐	HOTEL_RATE_CHANGE	CHAR1_X	CHAR	1	0	Price Change Due To Requested Period of Stay
27	GUARANTEE_NEEDED	☐	HOTEL_GUARANTEE_NEEDED	CHAR1_X	CHAR	1	0	Reservation Guarantee Required
28	GUARANTEE	☐	HOTEL_GUARANTEE	CHAR40	CHAR	40	0	Guarantee for room reservation at booking
29	DEPOSIT_NEEDED	☐	HOTEL_DEPOSIT_NEEDED	CHAR1_X	CHAR	1	0	Deposit Required for Reservation
30	DEPOSIT	☐	HOTEL_DEPOSIT	CHAR40	CHAR	40	0	Deposit payment method for room reservation
31	HOLD_IND	☐	HOTEL_HOLD_IND	CHAR1_X	CHAR	1	0	Guarantee for Room Availability
32	HOLD_TIME	☐	HOTEL_HOLD_TIME	FTPD_TIME	TIMS	6	0	Time limit for guarantee of room availability
33	SELL_RULE_IND	☐	HOTEL_SELL_RULE_IND	CHAR1_X	CHAR	1	0	Reservation Rules Exist
34	CORPORATE_ID_IND	☐	HOTEL_CORPORATE_ID_IND	CHAR1_X	CHAR	1	0	Company Identification Required
35	CORPORATE_ID	☐	HOTEL_CORPORATE_ID	FTPD_CORPORATION_ID	CHAR	30	0	Company identification for room reservation
36	QUALIFIED_IND	☐	HOTEL_QUALIFIED_IND	CHAR1_X	CHAR	1	0	Rate Category Indicator: Authorization Required
37	MIN_STAY_IND	☐	HOTEL_MIN_STAY_IND	CHAR1_X	CHAR	1	0	Minimum Stay Required
38	TOTAL_RATE_IND	☐	HOTEL_TOTAL_RATE_IND	CHAR1_X	CHAR	1	0	Total price
39	RATE	☐	HOTEL_RATE	FTPD_PRICE	CURR	10	2	Rate/Price Per Night
40	PRICE	☐	HOTEL_PRICE	FTPD_PRICE	CURR	10	2	Total Price for Hotel Stay
41	CURRENCY	☐	HOTEL_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
42	ADD_INFO	☐	HOTEL_ADD_INFO	FTPD_INFO	CHAR	132	0	Additional hotel information
43	STATUS	☐	HOTEL_STATUS	FTPD_SERVICE_STATUS	CHAR	2	0	Hotel Status
44	TEMPLATE	☐	VARIANT_TEMPLATE	FTPD_TEMPLATE	CHAR	1	0	Template indicator
45	AREA_LOC	☐	HOTEL_AREA_LOC	FTPD_HOTEL_AREA	CHAR	1	0	Hotel Area
46	TRANS_LOC	☐	HOTEL_TRANS_LOC	FTPD_HOTEL_TRANSPORT	CHAR	1	0	Transportation Option to Hotel
47	CONF_NUM	☐	HOTEL_CONFIRMATION_NUMBER	FTPD_HOTEL_CONF_NUMBER	CHAR	17	0	Hotel Reservation Number
48	MEMBSHIP_PROVCAT	☐	MEMBSHIP_PROVIDER_CATEGORY	FTPD_PROVIDER_CATEGORY	CHAR	1	0	Customer Program: Provider Category
49	MEMBSHIP_PROV	☐	MEMBSHIP_PROVIDER_CODE	FTPD_PROVIDER_CODE	CHAR	3	0	Customer Program: Provider Code	*
50	MEMBSHIP_KRZL	☐	PROV_PROGRAM_SHORTHAND	FTPD_PROV_PROGRAM_SHORTHAND	CHAR	3	0	Customer Program Code	TA21PF
51	MEMBSHIP_ID	☐	PROV_PROGRAM_NR	CHAR20	CHAR	20	0	Customer number
52	FLIGHT_MEM_PROV	☐	FLIGHT_PROGRAM_PROVIDER_CODE	FTPD_PROVIDER_CODE	CHAR	3	0	Frequent flyer program: Provider code	*
53	FLIGHT_MEM_KRZL	☐	FLIGHT_PROGRAM_SHORTHAND	FTPD_PROV_PROGRAM_SHORTHAND	CHAR	3	0	Frequent Flyer Program ID	TA21PF
54	FLIGHT_MEM_ID	☐	FLIGHT_PROGRAM_NR	CHAR20	CHAR	20	0	Frequent flyer number
55	PNR_NR	☐	HOTEL_LINENUMBER	FTPD_PNR_NR	INT2	5	0	Line Number of Hotel in PNR (if PNR available)	FTPT_PNR
56	PROFILE	☐	PROF_ID	FTPD_PROF_ID	CHAR	8	0	Travel Profile	*
57	PROFITEM	☐	PROF_ITEM	FTPD_PROF_ITEM	CHAR	8	0	Trip rule	*
58	KZTKT	☐	PLAN_ACTIVITY	FTPD_PLAN_ACTIVITY	CHAR	1	0	Trip Activity Type	*
59	SPECHID	☐	SSPECID	FTPD_SSPEC_ID	CHAR	8	0	Class rule	*
60	PRIORITY	☐	PROFIL_PRIROITY	FTPD_PROF_PRIORITY	CHAR	1	0	Priority of trip rule
61	HIGHEST_PRIORITY	☐	PROFIL_PRIROITY	FTPD_PROF_PRIORITY	CHAR	1	0	Priority of trip rule
62	COMPLETE_ACCESS	☐	COMPLETE_ACCESS_IND	FTPD_BOOLEAN	CHAR	1	0	Direct Access to Reservation System of Hotel
63	BOOKING_CODE	☐	HOTEL_BOOKING_CODE	FTPD_HOTEL_BOOKING_CODE	CHAR	10	0	Reservation Code for a Hotel Room
64	CATALOGUE_ID	☐	HOTEL_ID	FTPD_HOTEL_INDEX	CHAR	8	0	Hotel Catalog Item (enterprise-specific)	TA21PH
65	CANCEL_TIME	☐	HOTEL_CANCEL_TIME	FTPD_CANCEL_TIME	CHAR	5	0	Hotel Reservation: Cancelation Deadline
66	CANCEL_TYPE	☐	HOTEL_CANCEL_TYPE	FTPD_HOTEL_CANCEL_TYPE	CHAR	1	0	Hotel Reservation: Time Unit for Cancelation Deadline
67	.INCLUDE	☐				0	0	HR Master Record Infotype 0472 (Hotel Preferences)
68	SMOKE	☐	HOTEL_PREF_SMOKE	CHAR1_X	CHAR	1	0	Nonsmoking Room Requested
69	HCATG	☐	HOTEL_PREF_CLASS	FTPD_HOTEL_CLASS	CHAR	1	0	Preferred Hotel Category
70	BEDTP	☐	HOTEL_PREF_BEDTYPE	FTPD_BEDDING_TYPE	CHAR	1	0	Preferred Bed Type
71	RCATG	☐	HOTEL_PREF_ROOMTYPE	FTPD_HOTEL_ROOMTYPE	CHAR	1	0	Preferred Room Category
72	PREF1	☐	HOTEL_PREF_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	Hotel Chain - First Preference	TA21P
73	PREF2	☐	HOTEL_PREF_PROVIDER2	FTPD_PROVIDER_CODE	CHAR	3	0	Hotel Chain - Second Preference	TA21P
74	PREF3	☐	HOTEL_PREF_PROVIDER3	FTPD_PROVIDER_CODE	CHAR	3	0	Hotel Chain - Third Preference	TA21P
75	.INCLUDE	☐				0	0
76	.INCLUDE	☐				0	0	Reason Code
77	REASON_CODE	☐	REASON_CODE	FTPD_REASON_CODE	CHAR	2	0	Reason Code	*
78	REASON_TEXT	☐	REASON_TEXT	TEXT132	CHAR	132	0	Reason Text
79	.INCLUDE	☐				0	0	Encryptiong of Credit Card Data for Hotels
80	GUARANTEE_GUID	☐	CARD_GUID	SYSUUID	RAW	16	0	GUID of a Payment Card
81	DEPOSIT_GUID	☐	CARD_GUID	SYSUUID	RAW	16	0	GUID of a Payment Card
82	.INCLU--AP	☐				0	0	Append Structure for FTPT_HOTEL
83	.INCLUDE	☐				0	0	Append Structure HRS Connection for FTPT_HOTEL
84	LOC_TEXT	☐	HRS_HOTEL_LOCATION	TEXT64	CHAR	64	0	Location for Hotel Search
85	COUNTRY	☐	HRS_HOTEL_COUNTRY	INTCA3	CHAR	3	0	HRS Country Code
86	SINGLE_DOUBLE	☐	HRS_HOTEL_OCCUPANCY	FTPD_HRS_HOTEL_OCCUPANCY	CHAR	12	0	Room Occupancy
87	SEARCH_RADIUS	☐	HRS_HOTEL_SEARCH_RADIUS	FTPD_SEARCH_RADIUS	NUMC	4	0	Radius for Hotel Search
88	HOTEL_NUMBER	☐	HRS_HOTEL_NUMBER	CHAR10	CHAR	10	0	HRS Hotel Number
89	BOOKING_NR	☐	HRS_HOTEL_BOOKING_NR	CHAR32	CHAR	32	0	HRS Booking Number
90	BOOKING_PW	☐	HRS_HOTEL_BOOKING_PW	CHAR32	CHAR	32	0	HRS Booking Password
91	RATE_NUMBER	☐	HRS_HOTEL_RATE_NUMBER	CHAR10	CHAR	10	0	HRS Rate
92	.INCLU--AP	☐				0	0	Append Structure - Fields needed for Direct Hotel Providers
93	.INCLUDE	☐				0	0	Structure Fields needed for Direct Hotel Providers
94	LOC_CODE	☐	HOTEL_LOCATION_CODE	CHAR20	CHAR	20	0	Hotel location code - Provider Specific
95	CORPORATE_RATE	☐	HOTEL_RATE_TYPE	FTPD_HOTEL_RATE_TYPE	CHAR	1	0	Hotel Rate Type
96	RATE_NAME	☐	FTPD_HOTEL_RATE_NAME	CHAR40	CHAR	40	0	Direct Hotel/Room Rate Name

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTPT_HOTEL	CATALOGUE_ID	TA21PH	HOTEL_ID
2	FTPT_HOTEL	CURRENCY	TCURC	WAERS	REF	1	CN
3	FTPT_HOTEL	FLIGHT_MEM_KRZL	TA21PF	KRZL	REF	C	CN
4	FTPT_HOTEL	HOTEL	TA21P	PROVIDER	REF	1	CN
5	FTPT_HOTEL	ITEM	FTPT_ITEM	VARIANTVRS	KEY	1	CN
6	FTPT_HOTEL	LOC	TA21L	LOCID	REF	1	CN
7	FTPT_HOTEL	MEMBSHIP_KRZL	TA21PF	KRZL	REF	C	CN
8	FTPT_HOTEL	PNR_NR	FTPT_PNR	VARIANTVRS	REF	1	CN
9	FTPT_HOTEL	PREF1	TA21P	PROVIDER	REF	C	CN
10	FTPT_HOTEL	PREF2	TA21P	PROVIDER	REF	C	CN
11	FTPT_HOTEL	PREF3	TA21P	PROVIDER	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in