FTPT_QT_CAR SAP table for – Quicktrip Travel Request Item – Flight Service

Here we would like to draw your attention to FTPT_QT_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_QT_CAR is a SAP standard transp table used for storing Quicktrip Travel Request Item – Flight Service related data in SAP. It comes under the package PTRP.

SAP FTPT_QT_CAR table

Table FTPT_QT_CAR technical data

TableFTPT_QT_CAR
Data storingQuicktrip Travel Request Item – Flight Service
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP FTPT_QT_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_QT_CAR table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • QTNR : Quicktrip Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • 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
  • ITEM_ALTERN : Alternative Line Item Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • SERVICE : Travel service item number of flight
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • SERVICE_ALTERN : Alternative Flight Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLUDE : Entry Parameter: Car Rental Reservation
  • VENDOR_CODE : Car Rental Provider
    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 11
  • PICKUP_DATE : Start Date for Rental Car
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PICKUP_TIME : Rental Car Starting Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • DROPOFF_LOC : Car rental office for dropoff
    Its data type is CHAR (Character String) with field length 11
  • DROPOFF_DATE : End date for car rental
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DROPOFF_TIME : End time for car rental
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • QUANTITY : Number of cars
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • 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
  • RATE_CODE : Rental Car Rate Key (Provider-Dependent)
    Its data type is CHAR (Character String) with field length 20