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

Here we would like to draw your attention to FTPT_QT_HOTEL 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_HOTEL 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_HOTEL table

Table FTPT_QT_HOTEL technical data

TableFTPT_QT_HOTEL
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_HOTEL 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_HOTEL 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 : Hotel number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • SERVICE_ALTERN : Alternative Hotel Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLUDE : Entry Parameter: Hotel/Room Reservation
  • CHAIN_CODE : Hotel Chain
    Its data type is CHAR (Character String) with field length 3
  • CITY_CODE : Hotel Location
    Its data type is CHAR (Character String) with field length 3
  • PROPERTY_CODE : Hotel Code (Key for an Individual Hotel)
    Its data type is CHAR (Character String) with field length 6
  • CHECKIN_DATE : Arrival Date Hotel
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CHECKOUT_DATE : Departure Date Hotel
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OCCUPANCY : Number of hotel occupants
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • ROOMTYPE : Hotel Room Type
    Its data type is CHAR (Character String) with field length 1
  • BEDS : Number of Beds
    Its data type is CHAR (Character String) with field length 1
  • BED_TYPE : Bed Type
    Its data type is CHAR (Character String) with field length 1
  • RATE_CODE : Hotel Rate Category
    Its data type is CHAR (Character String) with field length 3
  • COMPLETE_ACCESS : Direct Access to Reservation System of Hotel
    Its data type is CHAR (Character String) with field length 1