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.
Table | FTPT_HOTEL |
Short Text | Travel Request Item - Hotel Service |
Package | PTRP |
Table Type | Transparent Table |
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 | * |