SAP Table FTPT_CAR
Travel Request Item - Car Rental 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_CAR (Travel Request Item - Car Rental Service) is a standard table in SAP ERP. It belongs to the package PTRP.
Technical Information
| Table | FTPT_CAR |
| Short Text | Travel Request Item - Car Rental Service |
| Package | PTRP |
| Table Type | Transparent Table |
Fields for Table FTPT_CAR
| 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 |