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_CAR (Travel Request Item - Car Rental Service) is a standard table in SAP ERP. It belongs to the package PTRP.
Table | FTPT_CAR |
Short Text | Travel Request Item - Car Rental 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 | ✔ | Rental car number | CAR_SERVICE_NR | NUMC | 3 | |
PROVIDER | Car Rental Provider | CAR_PROVIDER | CHAR | 3 | TA21P | |
DATE_BEG | Start Date for Rental Car | CAR_DATE_BEG | DATS | 8 | ||
TIME_BEG | Rental Car Starting Time | CAR_TIME_BEG | TIMS | 6 | ||
LOC_BEG | Rental Car Starting Location | CAR_LOC_BEG | CHAR | 3 | TA21L | |
DATE_END | End date for car rental | CAR_DATE_END | DATS | 8 | ||
TIME_END | End time for car rental | CAR_TIME_END | TIMS | 6 | ||
LOC_END | Dropoff Location | CAR_LOC_END | CHAR | 3 | TA21L | |
PICKUP_LOC | Car rental branch office for vehicle pickup | CAR_PICKUP_LOC | CHAR | 6 | ||
ADDRESS | Address of car rental branch office for pickup | CAR_ADDRESS | CHAR | 40 | ||
DROPOFF_LOC | Car rental office for dropoff | CAR_DROPOFF_LOC | CHAR | 6 | ||
ADDRESS_DROPOFF | Address of car rental office for dropoff | CAR_ADDRESS_DROPOFF | CHAR | 40 | ||
CLASS | Rental Car Vehicle Class | CAR_CLASS | CHAR | 1 | ||
TYPE | Rental Car Vehicle Type | CAR_TYPE | CHAR | 1 | ||
TRANSMISSION | Car Transmission | CAR_TRANSMISSION | CHAR | 1 | ||
AIR_CONDITION | Vehicle Air-Conditioning | CAR_AIR_CONDITION | CHAR | 1 | ||
QUANTITY | Number of cars | CAR_QUANTITY | INT1 | 3 | ||
SEGMENT_INDEX | Current line number of PNR | CAR_SEGMENT_INDEX | INT1 | 3 | ||
CONF_NUM | Car Rental Reservation Number | CAR_CONFIRMATION_NUMBER | CHAR | 17 | ||
PRICE | Car Rental Price Per Day/Week/Etc. | CAR_PRICE | CURR | 10 | ||
RATE_PLAN | Rental Car Rate Rule (by day/weekend/week/month) | CAR_RATE_PLAN | CHAR | 8 | ||
RATE_CODE | Rental Car Rate Key (Provider-Dependent) | CAR_RATECODE | CHAR | 12 | ||
CORPORATE_ID | Company ID for Negotiated Rates | CAR_CORPORATE_ID | CHAR | 30 | ||
GUARANTEE_NEEDED | Reservation guarantee required | CAR_GUARANTEE_NEEDED | CHAR | 1 | ||
GUARANTEE | Guarantee for rental care reservation at booking | CAR_GUARANTEE | CHAR | 40 | ||
DEPOSIT_NEEDED | Rental car: Down payment required | CAR_DEPOSIT_NEEDED | CHAR | 1 | ||
DEPOSIT | Deposit payment method for room reservation | CAR_DEPOSIT | CHAR | 40 | ||
FREE_MILES | Distance Restriction (miles/kilometers) | CAR_FREE_MILES | CHAR | 5 | ||
EXTRA_CHARGE | Surcharge for Car Rental Excess Usage | CAR_EXTRA_CHARGE | CURR | 10 | ||
DROPOFF_CHARGE | Charges for Rental Car Dropoff | CAR_DROPOFF_CHARGE | CURR | 10 | ||
EXTRA_CHARGE_TYP | Surcharge time unit for car rental usage exceeding | CAR_EXTRA_CHARGE_TYPE | CHAR | 3 | ||
TOTAL_RATE_TYPE | Car rental rate indicator (total amount) | CAR_TOTAL_RATE_TYPE | CHAR | 3 | ||
TOT_RATE_AMOUNT | Total Price for Car Rental | CAR_TOTAL_RATE_AMOUNT | CURR | 10 | ||
TOT_CURRENCY | Currency | CAR_CURRENCY | CUKY | 5 | TCURC | |
EXTRA_MILAGE | Surcharge for Exceeding Miles/Kms Limit for Rental Car | CAR_EXTRA_MILAGE | CURR | 10 | ||
CURRENCY | Currency | CAR_CURRENCY | CUKY | 5 | TCURC | |
STATUS | Car Rental Status | CAR_STATUS | CHAR | 2 | ||
TEMPLATE | Template indicator | VARIANT_TEMPLATE | CHAR | 1 | ||
CAR_AREA | City of car rental office (location) | CAR_AREA | CHAR | 1 | ||
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 | Zeilennummer der CAR in der Itinerary | CAR_LINENUMBER | INT2 | 5 | ||
PROFILE | Travel Profile | PROF_ID | CHAR | 8 | * | |
PROFITEM | Trip rule | PROF_ITEM | CHAR | 8 | * | |
KZTKT | Trip Activity Type | PLAN_ACTIVITY | CHAR | 1 | * | |
SPECCID | Class rule | SSPECID | CHAR | 8 | * | |
PRIORITY | Priority of trip rule | PROFIL_PRIROITY | CHAR | 1 | ||
HIGHEST_PRIORITY | Priority of trip rule | PROFIL_PRIROITY | CHAR | 1 | ||
CANCEL_TIME | Car rental reser.: Latest possible cancellation time | CAR_CANCEL_TIME | CHAR | 5 | ||
CANCEL_TYPE | Car rental res.: Time unit - latest poss. cancellation time | CAR_CANCEL_TYPE | CHAR | 1 | ||
SMOKE | Nonsmoking Car Requested | CAR_PREF_SMOKER | CHAR | 1 | ||
KLIMA | Air Conditioning Requested | CAR_PREF_KLIMA | CHAR | 1 | ||
GEAR | Manual Gear Shift Requested | CAR_PREF_GEAR | CHAR | 1 | ||
AUTOM | Automatic Transmission Requested | CAR_PREF_AUTOM | CHAR | 1 | ||
CBRAND | Preferred Car Make | CAR_PREF_BRAND | CHAR | 12 | ||
PREF1 | First Preference for Car Rental Company | CAR_PREF_PROVIDER | CHAR | 3 | TA21P | |
PREF2 | Second Preference for Car Rental Company | CAR_PREF_PROVIDER2 | CHAR | 3 | TA21P | |
PREF3 | Third Preference for Car Rental Company | CAR_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 | ||
NON_GDS_PUP_LOC | Car Rental Branch Office for Pickup (Provider-Specific) | CAR_PICKUP_LOC_NONGDS | CHAR | 11 | ||
NON_GDS_DO_LOC | Car Rental Branch Office for Dropoff (Provider-Specific) | CAR_DROPOFF_LOC_NONGDS | CHAR | 11 | ||
ADDITIONAL_INFO | Additional Information on Vehicle from Provider | CAR_ADDITIONAL_INFO | CHAR | 128 | ||
EST_PRICE | Total Price for Car Rental | CAR_TOTAL_RATE_AMOUNT | CURR | 10 | ||
EST_CURRENCY | Currency | CAR_CURRENCY | CUKY | 5 | * | |
CHECK_POLICY | Indicates Whether Policy Check Necessary | CAR_CHECK_POLICY | CHAR | 1 | ||
ADVANCE_PAYMENT | Payment in Advance Required | CAR_ADVANCE_PAYMENT | CHAR | 1 | ||
DELIVERY_ADDR | Address to Which Car Is Delivered | CAR_DELIVERY_ADDRESS | CHAR | 60 | ||
COLLECTION_ADDR | Address at Which Car Is Collected | CAR_COLLECTION_ADDRESS | CHAR | 60 | ||
FARE_TYPE | Rental Car: Rate Type | CAR_FARE_TYPE | CHAR | 6 | ||
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 | * | |
LOC_BEG_NAME | Name of Location | STATION_LOCATION_NAME | CHAR | 100 | ||
LOC_END_NAME | Name of Location | STATION_LOCATION_NAME | CHAR | 100 |