SAP Table FTPT_HOTEL
Travel Request Item - Hotel Service
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table FTPT_HOTEL (Travel Request Item - Hotel Service) is a standard table in SAP ERP. It belongs to the package PTRP.
Technical Information
| Table | FTPT_HOTEL |
| Short Text | Travel Request Item - Hotel Service |
| Package | PTRP |
| Table Type | Transparent Table |
Fields for Table FTPT_HOTEL
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | * |
| PERNR | ✔ | Personnel Number | PERNR_D | NUMC | 8 | |
| REINR | ✔ | Trip Number | REINR | NUMC | 10 | |
| PLANNR | ✔ | Travel Plan Number (Sequential Number) | PLAN_NR | NUMC | 2 | * |
| VARIANT | ✔ | Plan variant number (sequential number) | VARIANT_NR | NUMC | 2 | |
| VARIANTVRS | ✔ | Version of travel plan | VARIANT_VERSION | NUMC | 2 | * |
| ITEM | ✔ | Travel Request Item Number (Sequential Number) | ITEMPOS_NR | NUMC | 3 | FTPT_ITEM |
| SERVICE | ✔ | Hotel number | HOTEL_SERVICE_NR | NUMC | 3 | |
| HOTEL | Hotel Chain | HOTEL_PROVIDER | CHAR | 3 | TA21P | |
| PROPERTY | Hotel Code (Key for an Individual Hotel) | HOTEL_PROPERTY | CHAR | 6 | ||
| DATE_ARR | Arrival Date Hotel | HOTEL_DATE_ARR | DATS | 8 | ||
| DATE_DEP | Departure Date Hotel | HOTEL_DATE_DEP | DATS | 8 | ||
| LOC | Hotel Location | HOTEL_SLOCATION | CHAR | 3 | TA21L | |
| NAME | Name of Hotel | HOTEL_NAME | CHAR | 40 | ||
| ADDRESS | Hotel Address (address string separated by #) | HOTEL_ADDRESS | CHAR | 132 | ||
| CLASS | Hotel category | HOTEL_CLASS | CHAR | 1 | ||
| ROOMTYPE | Hotel Room Type | HOTEL_ROOMTYPE | CHAR | 1 | ||
| MEALS | Hotel Meals | HOTEL_MEALS | CHAR | 1 | ||
| OCCUPANCY | Number of hotel occupants | HOTEL_OCCUPANCY | INT1 | 3 | ||
| ROOMS | Number of Hotel Rooms | HOTEL_NUMBER_OF_ROOMS | INT1 | 3 | ||
| BEDS | Number of Beds | HOTEL_NUMBER_OF_BEDS | CHAR | 1 | ||
| BED_TYPE | Bed Type | HOTEL_BEDDING_TYPE | CHAR | 1 | ||
| ROOM_RATE_CODE | Rate Code (Hotel-Specific) | HOTEL_ROOM_RATE_CODE | CHAR | 3 | ||
| RATE_CODE | Hotel Rate Category | HOTEL_RATE_PLAN_CODE | CHAR | 3 | * | |
| RATE_CHANGE_IND | Price Change Due To Requested Period of Stay | HOTEL_RATE_CHANGE | CHAR | 1 | ||
| GUARANTEE_NEEDED | Reservation Guarantee Required | HOTEL_GUARANTEE_NEEDED | CHAR | 1 | ||
| GUARANTEE | Guarantee for room reservation at booking | HOTEL_GUARANTEE | CHAR | 40 | ||
| DEPOSIT_NEEDED | Deposit Required for Reservation | HOTEL_DEPOSIT_NEEDED | CHAR | 1 | ||
| DEPOSIT | Deposit payment method for room reservation | HOTEL_DEPOSIT | CHAR | 40 | ||
| HOLD_IND | Guarantee for Room Availability | HOTEL_HOLD_IND | CHAR | 1 | ||
| HOLD_TIME | Time limit for guarantee of room availability | HOTEL_HOLD_TIME | TIMS | 6 | ||
| SELL_RULE_IND | Reservation Rules Exist | HOTEL_SELL_RULE_IND | CHAR | 1 | ||
| CORPORATE_ID_IND | Company Identification Required | HOTEL_CORPORATE_ID_IND | CHAR | 1 | ||
| CORPORATE_ID | Company identification for room reservation | HOTEL_CORPORATE_ID | CHAR | 30 | ||
| QUALIFIED_IND | Rate Category Indicator: Authorization Required | HOTEL_QUALIFIED_IND | CHAR | 1 | ||
| MIN_STAY_IND | Minimum Stay Required | HOTEL_MIN_STAY_IND | CHAR | 1 | ||
| TOTAL_RATE_IND | Total price | HOTEL_TOTAL_RATE_IND | CHAR | 1 | ||
| RATE | Rate/Price Per Night | HOTEL_RATE | CURR | 10 | ||
| PRICE | Total Price for Hotel Stay | HOTEL_PRICE | CURR | 10 | ||
| CURRENCY | Currency | HOTEL_CURRENCY | CUKY | 5 | TCURC | |
| ADD_INFO | Additional hotel information | HOTEL_ADD_INFO | CHAR | 132 | ||
| STATUS | Hotel Status | HOTEL_STATUS | CHAR | 2 | ||
| TEMPLATE | Template indicator | VARIANT_TEMPLATE | CHAR | 1 | ||
| AREA_LOC | Hotel Area | HOTEL_AREA_LOC | CHAR | 1 | ||
| TRANS_LOC | Transportation Option to Hotel | HOTEL_TRANS_LOC | CHAR | 1 | ||
| CONF_NUM | Hotel Reservation Number | HOTEL_CONFIRMATION_NUMBER | CHAR | 17 | ||
| MEMBSHIP_PROVCAT | Customer Program: Provider Category | MEMBSHIP_PROVIDER_CATEGORY | CHAR | 1 | ||
| MEMBSHIP_PROV | Customer Program: Provider Code | MEMBSHIP_PROVIDER_CODE | CHAR | 3 | * | |
| MEMBSHIP_KRZL | Customer Program Code | PROV_PROGRAM_SHORTHAND | CHAR | 3 | TA21PF | |
| MEMBSHIP_ID | Customer number | PROV_PROGRAM_NR | CHAR | 20 | ||
| FLIGHT_MEM_PROV | Frequent flyer program: Provider code | FLIGHT_PROGRAM_PROVIDER_CODE | CHAR | 3 | * | |
| FLIGHT_MEM_KRZL | Frequent Flyer Program ID | FLIGHT_PROGRAM_SHORTHAND | CHAR | 3 | TA21PF | |
| FLIGHT_MEM_ID | Frequent flyer number | FLIGHT_PROGRAM_NR | CHAR | 20 | ||
| PNR_NR | Line Number of Hotel in PNR (if PNR available) | HOTEL_LINENUMBER | INT2 | 5 | FTPT_PNR | |
| PROFILE | Travel Profile | PROF_ID | CHAR | 8 | * | |
| PROFITEM | Trip rule | PROF_ITEM | CHAR | 8 | * | |
| KZTKT | Trip Activity Type | PLAN_ACTIVITY | CHAR | 1 | * | |
| SPECHID | Class rule | SSPECID | CHAR | 8 | * | |
| PRIORITY | Priority of trip rule | PROFIL_PRIROITY | CHAR | 1 | ||
| HIGHEST_PRIORITY | Priority of trip rule | PROFIL_PRIROITY | CHAR | 1 | ||
| COMPLETE_ACCESS | Direct Access to Reservation System of Hotel | COMPLETE_ACCESS_IND | CHAR | 1 | ||
| BOOKING_CODE | Reservation Code for a Hotel Room | HOTEL_BOOKING_CODE | CHAR | 10 | ||
| CATALOGUE_ID | Hotel Catalog Item (enterprise-specific) | HOTEL_ID | CHAR | 8 | TA21PH | |
| CANCEL_TIME | Hotel Reservation: Cancelation Deadline | HOTEL_CANCEL_TIME | CHAR | 5 | ||
| CANCEL_TYPE | Hotel Reservation: Time Unit for Cancelation Deadline | HOTEL_CANCEL_TYPE | CHAR | 1 | ||
| SMOKE | Nonsmoking Room Requested | HOTEL_PREF_SMOKE | CHAR | 1 | ||
| HCATG | Preferred Hotel Category | HOTEL_PREF_CLASS | CHAR | 1 | ||
| BEDTP | Preferred Bed Type | HOTEL_PREF_BEDTYPE | CHAR | 1 | ||
| RCATG | Preferred Room Category | HOTEL_PREF_ROOMTYPE | CHAR | 1 | ||
| PREF1 | Hotel Chain - First Preference | HOTEL_PREF_PROVIDER | CHAR | 3 | TA21P | |
| PREF2 | Hotel Chain - Second Preference | HOTEL_PREF_PROVIDER2 | CHAR | 3 | TA21P | |
| PREF3 | Hotel Chain - Third Preference | HOTEL_PREF_PROVIDER3 | CHAR | 3 | TA21P | |
| REASON_CODE | Reason Code | REASON_CODE | CHAR | 2 | * | |
| REASON_TEXT | Reason Text | REASON_TEXT | CHAR | 132 | ||
| GUARANTEE_GUID | GUID of a Payment Card | CARD_GUID | RAW | 16 | ||
| DEPOSIT_GUID | GUID of a Payment Card | CARD_GUID | RAW | 16 | ||
| LOC_TEXT | Location for Hotel Search | HRS_HOTEL_LOCATION | CHAR | 64 | ||
| COUNTRY | HRS Country Code | HRS_HOTEL_COUNTRY | CHAR | 3 | ||
| SINGLE_DOUBLE | Room Occupancy | HRS_HOTEL_OCCUPANCY | CHAR | 12 | ||
| SEARCH_RADIUS | Radius for Hotel Search | HRS_HOTEL_SEARCH_RADIUS | NUMC | 4 | ||
| HOTEL_NUMBER | HRS Hotel Number | HRS_HOTEL_NUMBER | CHAR | 10 | ||
| BOOKING_NR | HRS Booking Number | HRS_HOTEL_BOOKING_NR | CHAR | 32 | ||
| BOOKING_PW | HRS Booking Password | HRS_HOTEL_BOOKING_PW | CHAR | 32 | ||
| RATE_NUMBER | HRS Rate | HRS_HOTEL_RATE_NUMBER | CHAR | 10 | ||
| LOC_CODE | Hotel location code - Provider Specific | HOTEL_LOCATION_CODE | CHAR | 20 | ||
| CORPORATE_RATE | Hotel Rate Type | HOTEL_RATE_TYPE | CHAR | 1 | ||
| RATE_NAME | Direct Hotel/Room Rate Name | FTPD_HOTEL_RATE_NAME | CHAR | 40 | ||
| EXCEEDING_FARE | Excess Amount over Lowest Offer | EXCEEDING_FARE | CURR | 10 | ||
| EXCEEDING_FARE_C | Currency of Excess Amount over Lowest Offer | EXCEEDING_FARE_CURR | CUKY | 5 | * |