FTPT_HOTEL

Travel Request Item - Hotel Service | #transactional | Component: Travel Planning
Column Name Description
MANDT Client
PERNR Personnel Number
REINR Trip Number
PLANNR Travel Plan Number (Sequential Number)
VARIANT Plan variant number (sequential number)
VARIANTVRS Version of travel plan
ITEM FK Travel Request Item Number (Sequential Number)
SERVICE Hotel number
Column Name Description
💲 Currency (CURRENCY):
RATE Rate/Price Per Night
PRICE Total Price for Hotel Stay
💲 Currency of Excess Amount over Lowest Offer (EXCEEDING_FARE_C):
EXCEEDING_FARE Excess Amount over Lowest Offer
Column Name Description
Column Name Description
DATE_ARR Arrival Date Hotel
DATE_DEP Departure Date Hotel
HOLD_TIME Time limit for guarantee of room availability
Column Name Description
CLASS Hotel category Show values
ROOMTYPE Hotel Room Type Show values
MEALS Hotel Meals Show values
BED_TYPE Bed Type Show values
RATE_CHANGE_IND Price Change Due To Requested Period of Stay Show values
GUARANTEE_NEEDED Reservation Guarantee Required Show values
DEPOSIT_NEEDED Deposit Required for Reservation Show values
HOLD_IND Guarantee for Room Availability Show values
SELL_RULE_IND Reservation Rules Exist Show values
CORPORATE_ID_IND Company Identification Required Show values
QUALIFIED_IND Rate Category Indicator: Authorization Required Show values
MIN_STAY_IND Minimum Stay Required Show values
TOTAL_RATE_IND Total price Show values
STATUS Hotel Status Show values
TEMPLATE Template indicator Show values
AREA_LOC Hotel Area Show values
TRANS_LOC Transportation Option to Hotel 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
COMPLETE_ACCESS Direct Access to Reservation System of Hotel Show values
CANCEL_TYPE Hotel Reservation: Time Unit for Cancelation Deadline Show values
SMOKE Nonsmoking Room Requested Show values
HCATG Preferred Hotel Category Show values
BEDTP Preferred Bed Type Show values
RCATG Preferred Room Category Show values
SINGLE_DOUBLE Room Occupancy Show values
SEARCH_RADIUS Radius for Hotel Search Show values
CORPORATE_RATE Hotel Rate Type Show values
Column Name Description Domain name
PROPERTY Hotel Code (Key for an Individual Hotel) FTPD_HOTEL_PROP
NAME Name of Hotel TEXT40
ADDRESS Hotel Address (address string separated by #) TEXT132
OCCUPANCY Number of hotel occupants FTPD_INT1
ROOMS Number of Hotel Rooms FTPD_INT1
BEDS Number of Beds CHAR1
ROOM_RATE_CODE Rate Code (Hotel-Specific) CHAR3
RATE_CODE Hotel Rate Category FTPD_HOTEL_RATE_CODE
GUARANTEE Guarantee for room reservation at booking CHAR40
DEPOSIT Deposit payment method for room reservation CHAR40
CORPORATE_ID Company identification for room reservation FTPD_CORPORATION_ID
ADD_INFO Additional hotel information FTPD_INFO
CONF_NUM Hotel Reservation Number FTPD_HOTEL_CONF_NUMBER
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
PROFILE Travel Profile FTPD_PROF_ID
PROFITEM Trip rule FTPD_PROF_ITEM
KZTKT Trip Activity Type FTPD_PLAN_ACTIVITY
SPECHID Class rule FTPD_SSPEC_ID
BOOKING_CODE Reservation Code for a Hotel Room FTPD_HOTEL_BOOKING_CODE
CANCEL_TIME Hotel Reservation: Cancelation Deadline FTPD_CANCEL_TIME
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
LOC_TEXT Location for Hotel Search TEXT64
COUNTRY HRS Country Code INTCA3
HOTEL_NUMBER HRS Hotel Number CHAR10
BOOKING_NR HRS Booking Number CHAR32
BOOKING_PW HRS Booking Password CHAR32
RATE_NUMBER HRS Rate CHAR10
LOC_CODE Hotel location code - Provider Specific CHAR20
RATE_NAME Direct Hotel/Room Rate Name CHAR40
Master Data Relations | to Other Relations ↓ Join Conditions
Check Against Currency
  • FTPT_HOTEL.MANDT == TCURC.MANDT
  • FTPT_HOTEL.CURRENCY == TCURC.WAERS
Check Against Request
  • Travel Plan Number (Sequential Number)
  • Plan variant number (sequential number)
  • Personnel Number
  • Travel Request Item Number (Sequential Number)
  • Trip Number
  • Version of travel plan
Check Against IATA Location
  • Hotel Location
  • Client
  • FTPT_HOTEL.LOC == TA21L.LOCID
  • FTPT_HOTEL.MANDT == TA21L.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Check Against Hotel Catalog
  • FTPT_HOTEL.MANDT == TA21PH.MANDT
  • FTPT_HOTEL.CATALOGUE_ID == TA21PH.HOTEL_ID
Check Against Frequent Flyer Program
  • Frequent flyer program: Provider code
  • ?
  • Client
  • Frequent Flyer Program ID
  • FTPT_HOTEL.FLIGHT_MEM_PROV == TA21PF.PROVIDER
  • FTPT_HOTEL.[column in domain "MEMBSHIP_PROVIDER_CATEGORY"] == TA21PF.PROVCAT
  • FTPT_HOTEL.MANDT == TA21PF.MANDT
  • FTPT_HOTEL.FLIGHT_MEM_KRZL == TA21PF.KRZL
Check Against Hotel Chain
  • ?
  • Hotel Chain
  • Client
  • FTPT_HOTEL.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • FTPT_HOTEL.HOTEL == TA21P.PROVIDER
  • FTPT_HOTEL.MANDT == TA21P.MANDT
Check Against Customer Program
  • Hotel Chain
  • Customer Program: Provider Category
  • Client
  • Customer Program Code
  • FTPT_HOTEL.HOTEL == TA21PF.PROVIDER
  • FTPT_HOTEL.MEMBSHIP_PROVCAT == TA21PF.PROVCAT
  • FTPT_HOTEL.MANDT == TA21PF.MANDT
  • FTPT_HOTEL.MEMBSHIP_KRZL == TA21PF.KRZL
Check Against Hotel
  • ?
  • Hotel Chain - First Preference
  • Client
  • FTPT_HOTEL.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • FTPT_HOTEL.PREF1 == TA21P.PROVIDER
  • FTPT_HOTEL.MANDT == TA21P.MANDT
Check Against Hotel Chain
  • ?
  • Hotel Chain - Second Preference
  • Client
  • FTPT_HOTEL.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • FTPT_HOTEL.PREF2 == TA21P.PROVIDER
  • FTPT_HOTEL.MANDT == TA21P.MANDT
Check Against Hotel Chain
  • ?
  • Hotel Chain - Third Preference
  • Client
  • FTPT_HOTEL.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • FTPT_HOTEL.PREF3 == TA21P.PROVIDER
  • FTPT_HOTEL.MANDT == TA21P.MANDT