FTPT_A_CAR

Travel Request Item - Car Rental Service | #masterdata | Component: Travel Expenses
Column Name Description
MANDT Client
PERNR Personnel Number
REINR Trip Number
PLANNR Travel Plan Number (Sequential Number)
VARIANTE Plan variant number (sequential number)
VARIANTVRS Version of travel plan
ITEM Travel Request Item Number (Sequential Number)
SERVICE Rental car number
Column Name Description
💲 Currency (CURRENCY):
PRICE Car Rental Price Per Day/Week/Etc.
EXTRA_CHARGE Surcharge for Car Rental Excess Usage
DROPOFF_CHARGE Charges for Rental Car Dropoff
EXTRA_MILAGE Surcharge for Exceeding Miles/Kms Limit for Rental Car
💲 Currency (TOT_CURRENCY):
TOT_RATE_AMOUNT Total Price for Car Rental
Column Name Description
Column Name Description
DATE_BEG Start Date for Rental Car
TIME_BEG Rental Car Starting Time
DATE_END End date for car rental
TIME_END End time for car rental
Column Name Description
CLASS Rental Car Vehicle Class Show values
TYPE Rental Car Vehicle Type Show values
TRANSMISSION Car Transmission Show values
AIR_CONDITION Vehicle Air-Conditioning Show values
GUARANTEE_NEEDED Reservation guarantee required Show values
DEPOSIT_NEEDED Rental car: Down payment required Show values
STATUS Car Rental Status Show values
TEMPLATE Template indicator Show values
CAR_AREA City of car rental office (location) Show values
MEMBSHIP_PROVCAT Customer Program: Provider Category Show values
PRIORITY Priority of trip rule Show values
HIGHEST_PRIORITY Priority of trip rule Show values
CANCEL_TYPE Car rental res.: Time unit - latest poss. cancellation time Show values
SMOKE Nonsmoking Car Requested Show values
KLIMA Air Conditioning Requested Show values
Column Name Description Domain name
PICKUP_LOC Car rental branch office for vehicle pickup CHAR6
ADDRESS Address of car rental branch office for pickup TEXT40
DROPOFF_LOC Car rental office for dropoff CHAR6
ADDRESS_DROPOFF Address of car rental office for dropoff TEXT40
QUANTITY Number of cars FTPD_INT1
SEGMENT_INDEX Current line number of PNR FTPD_INT1
CONF_NUM Car Rental Reservation Number FTPD_CAR_CONF_NUMBER
RATE_PLAN Rental Car Rate Rule (by day/weekend/week/month) CHAR8
RATE_CODE Rental Car Rate Key (Provider-Dependent) CHAR12
CORPORATE_ID Company ID for Negotiated Rates FTPD_CORPORATION_ID
GUARANTEE Guarantee for rental care reservation at booking CHAR40
DEPOSIT Deposit payment method for room reservation CHAR40
FREE_MILES Distance Restriction (miles/kilometers) CHAR5
EXTRA_CHARGE_TYP Surcharge time unit for car rental usage exceeding FTPD_CAR_RATE_CODE
TOTAL_RATE_TYPE Car rental rate indicator (total amount) FTPD_CAR_RATE_CODE
MEMBSHIP_PROV Customer Program: Provider Code FTPD_PROVIDER_CODE
MEMBSHIP_ID Customer number CHAR20
FLIGHT_MEM_PROV Frequent flyer program: Provider code FTPD_PROVIDER_CODE
FLIGHT_MEM_ID Frequent flyer number CHAR20
PNR_NR Zeilennummer der CAR in der Itinerary FTPD_LINENUMBER
PROFILE Travel Profile FTPD_PROF_ID
PROFITEM Trip rule FTPD_PROF_ITEM
KZTKT Trip Activity Type FTPD_PLAN_ACTIVITY
SPECCID Class rule FTPD_SSPEC_ID
CANCEL_TIME Car rental reser.: Latest possible cancellation time FTPD_CANCEL_TIME
GEAR Manual Gear Shift Requested CHAR1
AUTOM Automatic Transmission Requested CHAR1
CBRAND Preferred Car Make TEXT12
PREF1 First Preference for Car Rental Company FTPD_PROVIDER_CODE
PREF2 Second Preference for Car Rental Company FTPD_PROVIDER_CODE
PREF3 Third Preference for Car Rental Company FTPD_PROVIDER_CODE
REASON_CODE Reason Code FTPD_REASON_CODE
REASON_TEXT Reason Text TEXT132
GUARANTEE_GUID GUID of a Payment Card SYSUUID
DEPOSIT_GUID GUID of a Payment Card SYSUUID
Master Data Relations | to Other Relations ↓ Join Conditions
Currency
  • FTPT_A_CAR.MANDT == TCURC.MANDT
  • FTPT_A_CAR.CURRENCY == TCURC.WAERS
Rental Car Starting Location
  • Rental Car Starting Location
  • Client
  • FTPT_A_CAR.LOC_BEG == TA21L.LOCID
  • FTPT_A_CAR.MANDT == TA21L.MANDT
Dropoff Location
  • Dropoff Location
  • Client
  • FTPT_A_CAR.LOC_END == TA21L.LOCID
  • FTPT_A_CAR.MANDT == TA21L.MANDT
Currency
  • FTPT_A_CAR.MANDT == TCURC.MANDT
  • FTPT_A_CAR.TOT_CURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Frequent Flyer Program ID
  • Frequent flyer program: Provider code
  • ?
  • Client
  • Frequent Flyer Program ID
  • FTPT_A_CAR.FLIGHT_MEM_PROV == TA21PF.PROVIDER
  • FTPT_A_CAR.[column in domain "MEMBSHIP_PROVIDER_CATEGORY"] == TA21PF.PROVCAT
  • FTPT_A_CAR.MANDT == TA21PF.MANDT
  • FTPT_A_CAR.FLIGHT_MEM_KRZL == TA21PF.KRZL
Customer Program Code
  • Car Rental Provider
  • Customer Program: Provider Category
  • Client
  • Customer Program Code
  • FTPT_A_CAR.PROVIDER == TA21PF.PROVIDER
  • FTPT_A_CAR.MEMBSHIP_PROVCAT == TA21PF.PROVCAT
  • FTPT_A_CAR.MANDT == TA21PF.MANDT
  • FTPT_A_CAR.MEMBSHIP_KRZL == TA21PF.KRZL
Car Rental Provider
  • ?
  • Car Rental Provider
  • Client
  • FTPT_A_CAR.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • FTPT_A_CAR.PROVIDER == TA21P.PROVIDER
  • FTPT_A_CAR.MANDT == TA21P.MANDT