1. SAP Tutorial
  2. FI Module

FTPT_IMR_CAR SAP table for – IMR – Car Rental

Here we would like to draw your attention to FTPT_IMR_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_IMR_CAR is a SAP standard transp table used for storing IMR – Car Rental related data in SAP. It comes under the package PTRI.

SAP FTPT_IMR_CAR table

Table FTPT_IMR_CAR technical data

TableFTPT_IMR_CAR
Data storingIMR – Car Rental
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRI
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP FTPT_IMR_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_IMR_CAR table.

  • .INCLUDE : Key for Information Management record
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RECORD_LOCATOR : Passenger Name Record Locator
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • AIR_NUMBER : Air record unique identifier
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 12
  • RUNNING_NUMBER : Index
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : AIR : Structure to describe CAR information for Automated
  • CAR_SEG_TYPE : AIR : Description of segment type for itinerary portion
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • TATTOO_NUMBER : Amadeus unique identifier for each element stored in PNR
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • DISPLAY_NUMBER : Amadeus unique identifier for each element displayed in PNR
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • PROVIDER_CODE : Airline Code definition
    Its data type is CHAR (Character String) with field length 4
  • STATUS_CODE : Real status code from Amadeus
    Its data type is CHAR (Character String) with field length 2
  • NUMBER_OF_CARS
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • IN_DATE : Date of Last Change
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OUT_DATE : Date of Last Change
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ARPT_CITY_CODE : 5 character code identifying a City Code
    Its data type is CHAR (Character String) with field length 5
  • ARPT_CITY_NAME
    Its data type is CHAR (Character String) with field length 20
  • CAR_TYPE_CODE : Car Type Code
    Its data type is CHAR (Character String) with field length 5
  • CAR_TYPE_DECODE
    Its data type is CHAR (Character String) with field length 25
  • ARRIVAL_INFO
    Its data type is CHAR (Character String) with field length 40
  • BOOKING_AGENCY
    Its data type is CHAR (Character String) with field length 15
  • BILLING_NUMBER
    Its data type is CHAR (Character String) with field length 15
  • BILLING_REF
    Its data type is CHAR (Character String) with field length 15
  • BS_TYPE
    Its data type is CHAR (Character String) with field length 1
  • BS : Booking source for reservation identification
    Its data type is CHAR (Character String) with field length 10
  • CORP_ID : Confirmation Code returned after Hotel reservation
    Its data type is CHAR (Character String) with field length 25
  • CONF_NUMBER : Confirmation Code returned after Hotel reservation
    Its data type is CHAR (Character String) with field length 20
  • VOUCHER_CODE : Voucher Code
    Its data type is CHAR (Character String) with field length 25
  • DROPOFF_CHARGE : Charges for Rental Car Dropoff
    Its data type is CHAR (Character String) with field length 20
  • DROPOFF_INFO
    Its data type is CHAR (Character String) with field length 70
  • FOP : Frequency of Payment
    Its data type is CHAR (Character String) with field length 50
  • FQTV_NUMBER
    Its data type is CHAR (Character String) with field length 30
  • GUARANTEE_INFO
    Its data type is CHAR (Character String) with field length 45
  • CUSTOMER_ID : Business Partner Number
    Its data type is CHAR (Character String) with field length 25
  • INCLUSE_TOUR
    Its data type is CHAR (Character String) with field length 20
  • LOCATION_CODE
    Its data type is CHAR (Character String) with field length 10
  • CITY_DISTANCE
    Its data type is CHAR (Character String) with field length 10
  • RESA_NAME
    Its data type is CHAR (Character String) with field length 30
  • PICKUP_INFO
    Its data type is CHAR (Character String) with field length 70
  • BASE_RATE_INFO
    Its data type is CHAR (Character String) with field length 30
  • CAR_RATE_CODE : Car Rate Code
    Its data type is CHAR (Character String) with field length 10
  • RATE_GUARANTEE
    Its data type is CHAR (Character String) with field length 60
  • RATE_QUOTED
    Its data type is CHAR (Character String) with field length 60
  • SUPP_INFO
    Its data type is CHAR (Character String) with field length 90
  • SPECIAL_REQ
    Its data type is CHAR (Character String) with field length 20
  • TRACKING_INFO
    Its data type is CHAR (Character String) with field length 30
  • VOUCHER_VALUE
    Its data type is CHAR (Character String) with field length 20
  • ACCOUNT_INFO
    Its data type is CHAR (Character String) with field length 30
  • PAST_DATED_IND
    Its data type is CHAR (Character String) with field length 1

    • FTPT_IMR_CAR related tables

    • FTPT_IMR_FAREELM : IMR: Passenger Information for Price Determination
    • FTPT_IMR_RECLOC : IMR – Booking Rate
    • FTPT_IMR_SSRSEG : IMR: Assignment Table Special Serv.Request to Flight Segment
    • FTPT_IMR_FQTV : IMR: Customer Programs
    • FTPT_IMR_MANUAL : IMR – Manually Created Segments
    • FTPT_IMR_SSRS : IMR: Information on Special Service Requirements
    • FTPT_IMR_TKT : IMR : Ticket Information
    • FTPT_IMR_FOP : IMR : Information on Payment Method
    • FTPT_IMR_TRAIN : IMR – Train
    • FTPT_IMR_HTL_DIR : IMR – Hotel (Direct Access)
    • FTPT_IMR_FSP : IMR: Assignment Table Passengers-Segments-TST
    • FTPT_IMR_NAMES : IMR : Name
    • FTPT_IMR_FOPSEG : IMR: Assignment Table Payment Method to Flight Segments
    • FTPT_IMR_SEATSEG : IMR: Table for Assignment of Seats to Flight Segments
    • FTPT_IMR_TKTSEG : IMR: Table for Assignment of Ticket to Flight Segment
    • FTPT_IMR_CAR : IMR – Car Rental
    • FTPT_IMR_FQTVSEG : IMR: Assignment Table Customer Programs to Flight Segments
    • FTPT_IMR_FAREDAT : IMR – Price Data Description
    • FTPT_IMR : IMR – General Information
    • FTPT_IMR_FELMSEG : IMR: Table for Assignment of Ticket to Flight Segment

    Related References

    Related Tutorials

    FTPT_IMR_DETAIL SAP table for – IMR – Detail Information

    FTPT_IMR_DETAIL table in SAP FI (Travel Management in FI) module. This table is used for storing data of IMR -...

    FTPT_IMR_FSP SAP table for – IMR: Assignment Table Passengers-Segments-TST

    FTPT_IMR_FSP table in SAP FI (Travel Management in FI) module. This table is used for storing data of IMR: Assignment...

    FTPT_IMR_NAMES SAP table for – IMR : Name

    FTPT_IMR_NAMES table in SAP FI (Travel Management in FI) module. This table is used for storing data of IMR :...

    FTPT_IMR_RECLOC SAP table for – IMR – Booking Rate

    FTPT_IMR_RECLOC table in SAP FI (Travel Management in FI) module. This table is used for storing data of IMR -...

    FTPT_IMR_TKTSEG SAP table for – IMR: Table for Assignment of Ticket to Flight Segment

    FTPT_IMR_TKTSEG table in SAP FI (Travel Management in FI) module. This table is used for storing data of IMR: Table...

    FTPT_IMR_TRAIN SAP table for – IMR – Train

    FTPT_IMR_TRAIN table in SAP FI (Travel Management in FI) module. This table is used for storing data of IMR -...

    FTPT_IMR_FLIGHT SAP table for – IMR – Flight

    FTPT_IMR_FLIGHT table in SAP FI (Travel Management in FI) module. This table is used for storing data of IMR -...

    «
    »