Menu

SAP Table FTPT_CAR

Travel Request Item - Car Rental Service

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