1. SAP Tutorial
  2. FI Module

FTPT_HOTEL SAP table for – Travel Request Item – Hotel Service

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

SAP FTPT_HOTEL table

Table FTPT_HOTEL technical data

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

SAP FTPT_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_HOTEL 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 : Hotel number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • HOTEL : Hotel Chain
    Its data type is CHAR (Character String) with field length 3
  • PROPERTY : Hotel Code (Key for an Individual Hotel)
    Its data type is CHAR (Character String) with field length 6
  • DATE_ARR : Arrival Date Hotel
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATE_DEP : Departure Date Hotel
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LOC : Hotel Location
    Its data type is CHAR (Character String) with field length 3
  • NAME : Name of Hotel
    Its data type is CHAR (Character String) with field length 40
  • ADDRESS : Hotel Address (address string separated by #)
    Its data type is CHAR (Character String) with field length 132
  • CLASS : Hotel category
    Its data type is CHAR (Character String) with field length 1
  • ROOMTYPE : Hotel Room Type
    Its data type is CHAR (Character String) with field length 1
  • MEALS : Hotel Meals
    Its data type is CHAR (Character String) with field length 1
  • OCCUPANCY : Number of hotel occupants
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • ROOMS : Number of Hotel Rooms
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • 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
  • ROOM_RATE_CODE : Rate Code (Hotel-Specific)
    Its data type is CHAR (Character String) with field length 3
  • RATE_CODE : Hotel Rate Category
    Its data type is CHAR (Character String) with field length 3
  • RATE_CHANGE_IND : Price Change Due To Requested Period of Stay
    Its data type is CHAR (Character String) with field length 1
  • GUARANTEE_NEEDED : Reservation Guarantee Required
    Its data type is CHAR (Character String) with field length 1
  • GUARANTEE : Guarantee for room reservation at booking
    Its data type is CHAR (Character String) with field length 40
  • DEPOSIT_NEEDED : Deposit Required for Reservation
    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
  • HOLD_IND : Guarantee for Room Availability
    Its data type is CHAR (Character String) with field length 1
  • HOLD_TIME : Time limit for guarantee of room availability
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • SELL_RULE_IND : Reservation Rules Exist
    Its data type is CHAR (Character String) with field length 1
  • CORPORATE_ID_IND : Company Identification Required
    Its data type is CHAR (Character String) with field length 1
  • CORPORATE_ID : Company identification for room reservation
    Its data type is CHAR (Character String) with field length 30
  • QUALIFIED_IND : Rate Category Indicator: Authorization Required
    Its data type is CHAR (Character String) with field length 1
  • MIN_STAY_IND : Minimum Stay Required
    Its data type is CHAR (Character String) with field length 1
  • TOTAL_RATE_IND : Total price
    Its data type is CHAR (Character String) with field length 1
  • RATE : Rate/Price Per Night
    Its data type is CURR (Currency Field) with field length 10
  • PRICE : Total Price for Hotel Stay
    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
  • ADD_INFO : Additional hotel information
    Its data type is CHAR (Character String) with field length 132
  • STATUS : Hotel 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
  • AREA_LOC : Hotel Area
    Its data type is CHAR (Character String) with field length 1
  • TRANS_LOC : Transportation Option to Hotel
    Its data type is CHAR (Character String) with field length 1
  • CONF_NUM : Hotel Reservation Number
    Its data type is CHAR (Character String) with field length 17
  • 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 : Line Number of Hotel in PNR (if PNR available)
  • 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
  • SPECHID : 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
  • COMPLETE_ACCESS : Direct Access to Reservation System of Hotel
    Its data type is CHAR (Character String) with field length 1
  • BOOKING_CODE : Reservation Code for a Hotel Room
    Its data type is CHAR (Character String) with field length 10
  • CATALOGUE_ID : Hotel Catalog Item (enterprise-specific)
    Its data type is CHAR (Character String) with field length 8
  • CANCEL_TIME : Hotel Reservation: Cancelation Deadline
    Its data type is CHAR (Character String) with field length 5
  • CANCEL_TYPE : Hotel Reservation: Time Unit for Cancelation Deadline
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : HR Master Record Infotype 0472 (Hotel Preferences)
  • SMOKE : Nonsmoking Room Requested
    Its data type is CHAR (Character String) with field length 1
  • HCATG : Preferred Hotel Category
    Its data type is CHAR (Character String) with field length 1
  • BEDTP : Preferred Bed Type
    Its data type is CHAR (Character String) with field length 1
  • RCATG : Preferred Room Category
    Its data type is CHAR (Character String) with field length 1
  • PREF1 : Hotel Chain – First Preference
    Its data type is CHAR (Character String) with field length 3
  • PREF2 : Hotel Chain – Second Preference
    Its data type is CHAR (Character String) with field length 3
  • PREF3 : Hotel Chain – Third Preference
    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 : Encryptiong of Credit Card Data for Hotels
  • 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_HOTEL
  • .INCLUDE : Append Structure HRS Connection for FTPT_HOTEL
  • LOC_TEXT : Location for Hotel Search
    Its data type is CHAR (Character String) with field length 64
  • COUNTRY : HRS Country Code
    Its data type is CHAR (Character String) with field length 3
  • SINGLE_DOUBLE : Room Occupancy
    Its data type is CHAR (Character String) with field length 12
  • SEARCH_RADIUS : Radius for Hotel Search
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • HOTEL_NUMBER : HRS Hotel Number
    Its data type is CHAR (Character String) with field length 10
  • BOOKING_NR : HRS Booking Number
    Its data type is CHAR (Character String) with field length 32
  • BOOKING_PW : HRS Booking Password
    Its data type is CHAR (Character String) with field length 32
  • RATE_NUMBER : HRS Rate
    Its data type is CHAR (Character String) with field length 10
  • .INCLU–AP : Append Structure – Fields needed for Direct Hotel Providers
  • .INCLUDE : Structure Fields needed for Direct Hotel Providers
  • LOC_CODE : Hotel location code – Provider Specific
    Its data type is CHAR (Character String) with field length 20
  • CORPORATE_RATE : Hotel Rate Type
    Its data type is CHAR (Character String) with field length 1
  • RATE_NAME : Direct Hotel/Room Rate Name
    Its data type is CHAR (Character String) with field length 40

    • FTPT_HOTEL related tables

    • FTPT_PNR_ADDRESS : PNR delivery / billing addresses
    • TA22RSS : START: Train Stations
    • TA20WIZZ : Names
    • TA20PIH : Hotel Trip Rule
    • TA20LBEZ : Tree Structure (Current Settings for Travel Planning)
    • PA0470 : HR master record infotype 0470 (travel profiles)
    • TA20NHC1 : Negotiated Hotel Rates (Language-Dependent)
    • TA20PPZ : Message handling: chosen priority with top priority
    • TA22ST : Amadeus: status flight/car rental/hotel
    • TA20LB1 : Trees (Current Settings for Travel Planning, Lang.-Depend.)
    • FTPT_HOTEL : Travel Request Item – Hotel Service
    • TA21R1 : Regions (Language-Dependent)
    • TA20SUBSCRPT_ASG : Logon to External Reservation System per Sales Office
    • TA20OFFICE_FIND1 : Specify Access Parameters per Group ID
    • TA20PI : Trip Rule
    • TA21CAR1 : Car Rental Rates (Language-Dependent)
    • TA22RSA : START: Train Attributes
    • TA20LB : Trees (Current Settings for Travel Planning)
    • FTPT_QT_CAR : Quicktrip Travel Request Item – Flight Service
    • TA20LT : Current Settings for Travel Planning Control Variants

    Related References

    Related Tutorials

    FTPT_HOTEL_PREF SAP table for – Hotel service preferences of a travel plan

    FTPT_HOTEL_PREF table in SAP FI (Travel Management in FI) module. This table is used for storing data of Hotel service...

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

    FTPT_QT_HOTEL table in SAP FI (Travel Management in FI) module. This table is used for storing data of Quicktrip Travel...

    FTPT_ITEM SAP table for – Travel Service Request Item

    FTPT_ITEM table in SAP FI (Travel Management in FI) module. This table is used for storing data of Travel Service...

    FTPT_QT_ITEM SAP table for – Quicktrip Travel Service Request Item

    FTPT_QT_ITEM table in SAP FI (Travel Management in FI) module. This table is used for storing data of Quicktrip Travel...

    FTPT_TRAIN SAP table for – Travel Request Item – Train Service

    FTPT_TRAIN table in SAP FI (Travel Management in FI) module. This table is used for storing data of Travel Request...

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

    FTPT_QT_CAR table in SAP FI (Travel Management in FI) module. This table is used for storing data of Quicktrip Travel...

    FTPT_OTHER SAP table for – Travel Reservation Request Item – Other Service

    FTPT_OTHER table in SAP FI (Travel Management in FI) module. This table is used for storing data of Travel Reservation...

    «
    »