FTPT_A_HOTEL

Travel Request Item - Hotel Service | #masterdata | Component: Travel Expenses
Column Name Description
MANDT Client
PERNR Personnel Number
REINR Trip Number
PLANNR Travel Plan Number (Sequential Number)
VARIANTE Plan variant number (sequential number)
VARIANTVRS Version of travel plan
ITEM 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
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
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
PNR_NR Line Number of Hotel in PNR (if PNR available) FTPD_PNR_NR
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
PREF1 Hotel Chain - First Preference FTPD_PROVIDER_CODE
PREF2 Hotel Chain - Second Preference FTPD_PROVIDER_CODE
PREF3 Hotel Chain - Third Preference FTPD_PROVIDER_CODE
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
Master Data Relations | to Other Relations ↓ Join Conditions
Currency
  • FTPT_A_HOTEL.MANDT == TCURC.MANDT
  • FTPT_A_HOTEL.CURRENCY == TCURC.WAERS
Hotel Location
  • Hotel Location
  • Client
  • FTPT_A_HOTEL.LOC == TA21L.LOCID
  • FTPT_A_HOTEL.MANDT == TA21L.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Hotel Catalog Item (enterprise-specific)
  • FTPT_A_HOTEL.MANDT == TA21PH.MANDT
  • FTPT_A_HOTEL.CATALOGUE_ID == TA21PH.HOTEL_ID
Frequent Flyer Program ID
  • Frequent flyer program: Provider code
  • ?
  • Client
  • Frequent Flyer Program ID
  • FTPT_A_HOTEL.FLIGHT_MEM_PROV == TA21PF.PROVIDER
  • FTPT_A_HOTEL.[column in domain "MEMBSHIP_PROVIDER_CATEGORY"] == TA21PF.PROVCAT
  • FTPT_A_HOTEL.MANDT == TA21PF.MANDT
  • FTPT_A_HOTEL.FLIGHT_MEM_KRZL == TA21PF.KRZL
Hotel Chain
  • ?
  • Hotel Chain
  • Client
  • FTPT_A_HOTEL.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • FTPT_A_HOTEL.HOTEL == TA21P.PROVIDER
  • FTPT_A_HOTEL.MANDT == TA21P.MANDT
Customer Program Code
  • Hotel Chain
  • Customer Program: Provider Category
  • Client
  • Customer Program Code
  • FTPT_A_HOTEL.HOTEL == TA21PF.PROVIDER
  • FTPT_A_HOTEL.MEMBSHIP_PROVCAT == TA21PF.PROVCAT
  • FTPT_A_HOTEL.MANDT == TA21PF.MANDT
  • FTPT_A_HOTEL.MEMBSHIP_KRZL == TA21PF.KRZL