FTPT_CAR SAP table for – Travel Request Item – Car Rental Service

Here we would like to draw your attention to FTPT_CAR table in SAP. As we know it is being mainly used with the SAP FI-TV (Travel Management in FI) component which is coming under FI module (Financial Accounting). FTPT_CAR is a SAP standard transp table used for storing Travel Request Item – Car Rental Service related data in SAP. It comes under the package PTRP.

SAP FTPT_CAR table

Table FTPT_CAR technical data

TableFTPT_CAR
Data storingTravel Request Item – Car Rental Service
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP FTPT_CAR Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FTPT_CAR table.

  • .INCLUDE : Key to travel plan table
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PERNR : Personnel Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • REINR : Trip Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • PLANNR : Travel Plan Number (Sequential Number)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • VARIANT : Plan variant number (sequential number)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • VARIANTVRS : Version of travel plan
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • ITEM : Travel Request Item Number (Sequential Number)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • SERVICE : Rental car number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • PROVIDER : Car Rental Provider
    Its data type is CHAR (Character String) with field length 3
  • DATE_BEG : Start Date for Rental Car
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TIME_BEG : Rental Car Starting Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • LOC_BEG : Rental Car Starting Location
    Its data type is CHAR (Character String) with field length 3
  • DATE_END : End date for car rental
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TIME_END : End time for car rental
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • LOC_END : Dropoff Location
    Its data type is CHAR (Character String) with field length 3
  • PICKUP_LOC : Car rental branch office for vehicle pickup
    Its data type is CHAR (Character String) with field length 6
  • ADDRESS : Address of car rental branch office for pickup
    Its data type is CHAR (Character String) with field length 40
  • DROPOFF_LOC : Car rental office for dropoff
    Its data type is CHAR (Character String) with field length 6
  • ADDRESS_DROPOFF : Address of car rental office for dropoff
    Its data type is CHAR (Character String) with field length 40
  • CLASS : Rental Car Vehicle Class
    Its data type is CHAR (Character String) with field length 1
  • TYPE : Rental Car Vehicle Type
    Its data type is CHAR (Character String) with field length 1
  • TRANSMISSION : Car Transmission
    Its data type is CHAR (Character String) with field length 1
  • AIR_CONDITION : Vehicle Air-Conditioning
    Its data type is CHAR (Character String) with field length 1
  • QUANTITY : Number of cars
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • SEGMENT_INDEX : Current line number of PNR
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • CONF_NUM : Car Rental Reservation Number
    Its data type is CHAR (Character String) with field length 17
  • PRICE : Car Rental Price Per Day/Week/Etc.
    Its data type is CURR (Currency Field) with field length 10
  • RATE_PLAN : Rental Car Rate Rule (by day/weekend/week/month)
    Its data type is CHAR (Character String) with field length 8
  • RATE_CODE : Rental Car Rate Key (Provider-Dependent)
    Its data type is CHAR (Character String) with field length 12
  • CORPORATE_ID : Company ID for Negotiated Rates
    Its data type is CHAR (Character String) with field length 30
  • GUARANTEE_NEEDED : Reservation guarantee required
    Its data type is CHAR (Character String) with field length 1
  • GUARANTEE : Guarantee for rental care reservation at booking
    Its data type is CHAR (Character String) with field length 40
  • DEPOSIT_NEEDED : Rental car: Down payment required
    Its data type is CHAR (Character String) with field length 1
  • DEPOSIT : Deposit payment method for room reservation
    Its data type is CHAR (Character String) with field length 40
  • FREE_MILES : Distance Restriction (miles/kilometers)
    Its data type is CHAR (Character String) with field length 5
  • EXTRA_CHARGE : Surcharge for Car Rental Excess Usage
    Its data type is CURR (Currency Field) with field length 10
  • DROPOFF_CHARGE : Charges for Rental Car Dropoff
    Its data type is CURR (Currency Field) with field length 10
  • EXTRA_CHARGE_TYP : Surcharge time unit for car rental usage exceeding
    Its data type is CHAR (Character String) with field length 3
  • TOTAL_RATE_TYPE : Car rental rate indicator (total amount)
    Its data type is CHAR (Character String) with field length 3
  • TOT_RATE_AMOUNT : Total Price for Car Rental
    Its data type is CURR (Currency Field) with field length 10
  • TOT_CURRENCY : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • EXTRA_MILAGE : Surcharge for Exceeding Miles/Kms Limit for Rental Car
    Its data type is CURR (Currency Field) with field length 10
  • CURRENCY : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • STATUS : Car Rental Status
    Its data type is CHAR (Character String) with field length 2
  • TEMPLATE : Template indicator
    Its data type is CHAR (Character String) with field length 1
  • CAR_AREA : City of car rental office (location)
    Its data type is CHAR (Character String) with field length 1
  • MEMBSHIP_PROVCAT : Customer Program: Provider Category
    Its data type is CHAR (Character String) with field length 1
  • MEMBSHIP_PROV : Customer Program: Provider Code
    Its data type is CHAR (Character String) with field length 3
  • MEMBSHIP_KRZL : Customer Program Code
    Its data type is CHAR (Character String) with field length 3
  • MEMBSHIP_ID : Customer number
    Its data type is CHAR (Character String) with field length 20
  • FLIGHT_MEM_PROV : Frequent flyer program: Provider code
    Its data type is CHAR (Character String) with field length 3
  • FLIGHT_MEM_KRZL : Frequent Flyer Program ID
    Its data type is CHAR (Character String) with field length 3
  • FLIGHT_MEM_ID : Frequent flyer number
    Its data type is CHAR (Character String) with field length 20
  • PNR_NR : Zeilennummer der CAR in der Itinerary
  • PROFILE : Travel Profile
    Its data type is CHAR (Character String) with field length 8
  • PROFITEM : Trip rule
    Its data type is CHAR (Character String) with field length 8
  • KZTKT : Trip Activity Type
    Its data type is CHAR (Character String) with field length 1
  • SPECCID : Class rule
    Its data type is CHAR (Character String) with field length 8
  • PRIORITY : Priority of trip rule
    Its data type is CHAR (Character String) with field length 1
  • HIGHEST_PRIORITY : Priority of trip rule
    Its data type is CHAR (Character String) with field length 1
  • CANCEL_TIME : Car rental reser.: Latest possible cancellation time
    Its data type is CHAR (Character String) with field length 5
  • CANCEL_TYPE : Car rental res.: Time unit – latest poss. cancellation time
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : HR Master Record Infotype 0473 (Rental Car Preferences)
  • SMOKE : Nonsmoking Car Requested
    Its data type is CHAR (Character String) with field length 1
  • KLIMA : Air Conditioning Requested
    Its data type is CHAR (Character String) with field length 1
  • GEAR : Manual Gear Shift Requested
    Its data type is CHAR (Character String) with field length 1
  • AUTOM : Automatic Transmission Requested
    Its data type is CHAR (Character String) with field length 1
  • CBRAND : Preferred Car Make
    Its data type is CHAR (Character String) with field length 12
  • PREF1 : First Preference for Car Rental Company
    Its data type is CHAR (Character String) with field length 3
  • PREF2 : Second Preference for Car Rental Company
    Its data type is CHAR (Character String) with field length 3
  • PREF3 : Third Preference for Car Rental Company
    Its data type is CHAR (Character String) with field length 3
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Reason Code
  • REASON_CODE : Reason Code
    Its data type is CHAR (Character String) with field length 2
  • REASON_TEXT : Reason Text
    Its data type is CHAR (Character String) with field length 132
  • .INCLUDE : Encryption of Credit Card Data for Rental Cars
  • GUARANTEE_GUID : GUID of a Payment Card
    Its data type is RAW (Byte string) with field length 16
  • DEPOSIT_GUID : GUID of a Payment Card
    Its data type is RAW (Byte string) with field length 16
  • .INCLU–AP : Append Structure for FTPT_CAR
  • NON_GDS_PUP_LOC : Car Rental Branch Office for Pickup (Provider-Specific)
    Its data type is CHAR (Character String) with field length 11
  • NON_GDS_DO_LOC : Car Rental Branch Office for Dropoff (Provider-Specific)
    Its data type is CHAR (Character String) with field length 11
  • ADDITIONAL_INFO : Additional Information on Vehicle from Provider
    Its data type is CHAR (Character String) with field length 128
  • EST_PRICE : Total Price for Car Rental
    Its data type is CURR (Currency Field) with field length 10
  • EST_CURRENCY : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • CHECK_POLICY : Indicates Whether Policy Check Necessary
    Its data type is CHAR (Character String) with field length 1
  • ADVANCE_PAYMENT : Payment in Advance Required
    Its data type is CHAR (Character String) with field length 1
  • DELIVERY_ADDR : Address to Which Car Is Delivered
    Its data type is CHAR (Character String) with field length 60
  • COLLECTION_ADDR : Address at Which Car Is Collected
    Its data type is CHAR (Character String) with field length 60
  • FARE_TYPE : Rental Car: Rate Type
    Its data type is CHAR (Character String) with field length 6