FTPT_HOTEL SAP (Travel Request Item - Hotel Service) Table details

Dictionary Type: Table
Description: Travel Request Item - Hotel Service




ABAP Code to SELECT data from FTPT_HOTEL
Related tables to FTPT_HOTEL
Access table FTPT_HOTEL




Table field list including key, data, relationships and ABAP select examples

FTPT_HOTEL is a standard SAP Table which is used to store Travel Request Item - Hotel Service data and is available within R/3 SAP systems depending on the version and release level.

The FTPT_HOTEL table consists of various fields, each holding specific information or linking keys about Travel Request Item - Hotel Service data available in SAP. These include MANDT (Client), PERNR (Personnel Number), REINR (Trip Number), PLANNR (Travel Plan Number (Sequential Number)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP FTPT_HOTEL table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
REINRTrip Number REINRNUMC10REINR
PLANNRTravel Plan Number (Sequential Number) PLAN_NRNUMC2Assigned to domainFTPD_PLAN_NR
VARIANTPlan variant number (sequential number) VARIANT_NRNUMC2FTPD_VARIANT_NR
VARIANTVRSVersion of travel plan VARIANT_VERSIONNUMC2Assigned to domainFTPD_VARIANT_VERSION
ITEMTravel Request Item Number (Sequential Number) ITEMPOS_NRNUMC3FTPT_ITEMFTPD_ITEM_ID
SERVICEHotel number HOTEL_SERVICE_NRNUMC3FTPD_HOTEL_ID
HOTELHotel Chain HOTEL_PROVIDERCHAR3TA21PFTPD_PROVIDER_CODE
PROPERTYHotel Code (Key for an Individual Hotel) HOTEL_PROPERTYCHAR6FTPD_HOTEL_PROP
DATE_ARRArrival Date Hotel HOTEL_DATE_ARRDATS8FTPD_DATE
DATE_DEPDeparture Date Hotel HOTEL_DATE_DEPDATS8FTPD_DATE
LOCHotel Location HOTEL_SLOCATIONCHAR3TA21LFTPD_IATA_LOCATION
NAMEName of Hotel HOTEL_NAMECHAR40TEXT40
ADDRESSHotel Address (address string separated by #) HOTEL_ADDRESSCHAR132TEXT132
CLASSHotel category HOTEL_CLASSCHAR1FTPD_HOTEL_CLASS
ROOMTYPEHotel Room Type HOTEL_ROOMTYPECHAR1FTPD_HOTEL_ROOMTYPE
MEALSHotel Meals HOTEL_MEALSCHAR1FTPD_HOTEL_MEALS
OCCUPANCYNumber of hotel occupants HOTEL_OCCUPANCYINT13FTPD_INT1
ROOMSNumber of Hotel Rooms HOTEL_NUMBER_OF_ROOMSINT13FTPD_INT1
BEDSNumber of Beds HOTEL_NUMBER_OF_BEDSCHAR1CHAR1
BED_TYPEBed Type HOTEL_BEDDING_TYPECHAR1FTPD_BEDDING_TYPE
ROOM_RATE_CODERate Code (Hotel-Specific) HOTEL_ROOM_RATE_CODECHAR3CHAR3
RATE_CODEHotel Rate Category HOTEL_RATE_PLAN_CODECHAR3Assigned to domainFTPD_HOTEL_RATE_CODE
RATE_CHANGE_INDPrice Change Due To Requested Period of Stay HOTEL_RATE_CHANGECHAR1CHAR1_X
GUARANTEE_NEEDEDReservation Guarantee Required HOTEL_GUARANTEE_NEEDEDCHAR1CHAR1_X
GUARANTEEGuarantee for room reservation at booking HOTEL_GUARANTEECHAR40CHAR40
DEPOSIT_NEEDEDDeposit Required for Reservation HOTEL_DEPOSIT_NEEDEDCHAR1CHAR1_X
DEPOSITDeposit payment method for room reservation HOTEL_DEPOSITCHAR40CHAR40
HOLD_INDGuarantee for Room Availability HOTEL_HOLD_INDCHAR1CHAR1_X
HOLD_TIMETime limit for guarantee of room availability HOTEL_HOLD_TIMETIMS6FTPD_TIME
SELL_RULE_INDReservation Rules Exist HOTEL_SELL_RULE_INDCHAR1CHAR1_X
CORPORATE_ID_INDCompany Identification Required HOTEL_CORPORATE_ID_INDCHAR1CHAR1_X
CORPORATE_IDCompany identification for room reservation HOTEL_CORPORATE_IDCHAR30FTPD_CORPORATION_ID
QUALIFIED_INDRate Category Indicator: Authorization Required HOTEL_QUALIFIED_INDCHAR1CHAR1_X
MIN_STAY_INDMinimum Stay Required HOTEL_MIN_STAY_INDCHAR1CHAR1_X
TOTAL_RATE_INDTotal price HOTEL_TOTAL_RATE_INDCHAR1CHAR1_X
RATERate/Price Per Night HOTEL_RATECURR10(2) FTPD_PRICE
PRICETotal Price for Hotel Stay HOTEL_PRICECURR10(2) FTPD_PRICE
CURRENCYCurrency HOTEL_CURRENCYCUKY5TCURCWAERS
ADD_INFOAdditional hotel information HOTEL_ADD_INFOCHAR132FTPD_INFO
STATUSHotel Status HOTEL_STATUSCHAR2FTPD_SERVICE_STATUS
TEMPLATETemplate indicator VARIANT_TEMPLATECHAR1FTPD_TEMPLATE
AREA_LOCHotel Area HOTEL_AREA_LOCCHAR1FTPD_HOTEL_AREA
TRANS_LOCTransportation Option to Hotel HOTEL_TRANS_LOCCHAR1FTPD_HOTEL_TRANSPORT
CONF_NUMHotel Reservation Number HOTEL_CONFIRMATION_NUMBERCHAR17FTPD_HOTEL_CONF_NUMBER
MEMBSHIP_PROVCATCustomer Program: Provider Category MEMBSHIP_PROVIDER_CATEGORYCHAR1FTPD_PROVIDER_CATEGORY
MEMBSHIP_PROVCustomer Program: Provider Code MEMBSHIP_PROVIDER_CODECHAR3Assigned to domainFTPD_PROVIDER_CODE
MEMBSHIP_KRZLCustomer Program Code PROV_PROGRAM_SHORTHANDCHAR3TA21PFFTPD_PROV_PROGRAM_SHORTHAND
MEMBSHIP_IDCustomer number PROV_PROGRAM_NRCHAR20CHAR20
FLIGHT_MEM_PROVFrequent flyer program: Provider code FLIGHT_PROGRAM_PROVIDER_CODECHAR3Assigned to domainFTPD_PROVIDER_CODE
FLIGHT_MEM_KRZLFrequent Flyer Program ID FLIGHT_PROGRAM_SHORTHANDCHAR3TA21PFFTPD_PROV_PROGRAM_SHORTHAND
FLIGHT_MEM_IDFrequent flyer number FLIGHT_PROGRAM_NRCHAR20CHAR20
PNR_NRLine Number of Hotel in PNR (if PNR available) HOTEL_LINENUMBERINT25FTPT_PNRFTPD_PNR_NR
PROFILETravel Profile PROF_IDCHAR8Assigned to domainFTPD_PROF_IDPROFILE
PROFITEMTrip rule PROF_ITEMCHAR8Assigned to domainFTPD_PROF_ITEMPITEM
KZTKTTrip Activity Type PLAN_ACTIVITYCHAR1Assigned to domainFTPD_PLAN_ACTIVITY
SPECHIDClass rule SSPECIDCHAR8Assigned to domainFTPD_SSPEC_ID
PRIORITYPriority of trip rule PROFIL_PRIROITYCHAR1FTPD_PROF_PRIORITY
HIGHEST_PRIORITYPriority of trip rule PROFIL_PRIROITYCHAR1FTPD_PROF_PRIORITY
COMPLETE_ACCESSDirect Access to Reservation System of Hotel COMPLETE_ACCESS_INDCHAR1FTPD_BOOLEAN
BOOKING_CODEReservation Code for a Hotel Room HOTEL_BOOKING_CODECHAR10FTPD_HOTEL_BOOKING_CODE
CATALOGUE_IDHotel Catalog Item (enterprise-specific) HOTEL_IDCHAR8TA21PHFTPD_HOTEL_INDEX
CANCEL_TIMEHotel Reservation: Cancelation Deadline HOTEL_CANCEL_TIMECHAR5FTPD_CANCEL_TIME
CANCEL_TYPEHotel Reservation: Time Unit for Cancelation Deadline HOTEL_CANCEL_TYPECHAR1FTPD_HOTEL_CANCEL_TYPE
SMOKENonsmoking Room Requested HOTEL_PREF_SMOKECHAR1CHAR1_X
HCATGPreferred Hotel Category HOTEL_PREF_CLASSCHAR1FTPD_HOTEL_CLASS
BEDTPPreferred Bed Type HOTEL_PREF_BEDTYPECHAR1FTPD_BEDDING_TYPE
RCATGPreferred Room Category HOTEL_PREF_ROOMTYPECHAR1FTPD_HOTEL_ROOMTYPE
PREF1Hotel Chain - First Preference HOTEL_PREF_PROVIDERCHAR3TA21PFTPD_PROVIDER_CODE
PREF2Hotel Chain - Second Preference HOTEL_PREF_PROVIDER2CHAR3TA21PFTPD_PROVIDER_CODE
PREF3Hotel Chain - Third Preference HOTEL_PREF_PROVIDER3CHAR3TA21PFTPD_PROVIDER_CODE
REASON_CODEReason Code REASON_CODECHAR2Assigned to domainFTPD_REASON_CODE
REASON_TEXTReason Text REASON_TEXTCHAR132TEXT132
GUARANTEE_GUIDGUID of a Payment Card CARD_GUIDRAW16SYSUUID
DEPOSIT_GUIDGUID of a Payment Card CARD_GUIDRAW16SYSUUID
.INCLU--AP 0
LOC_TEXTLocation for Hotel Search HRS_HOTEL_LOCATIONCHAR64TEXT64
COUNTRYHRS Country Code HRS_HOTEL_COUNTRYCHAR3INTCA3
SINGLE_DOUBLERoom Occupancy HRS_HOTEL_OCCUPANCYCHAR12FTPD_HRS_HOTEL_OCCUPANCY
SEARCH_RADIUSRadius for Hotel Search HRS_HOTEL_SEARCH_RADIUSNUMC4FTPD_SEARCH_RADIUS
HOTEL_NUMBERHRS Hotel Number HRS_HOTEL_NUMBERCHAR10CHAR10
BOOKING_NRHRS Booking Number HRS_HOTEL_BOOKING_NRCHAR32CHAR32
BOOKING_PWHRS Booking Password HRS_HOTEL_BOOKING_PWCHAR32CHAR32
RATE_NUMBERHRS Rate HRS_HOTEL_RATE_NUMBERCHAR10CHAR10
.INCLU--AP 0
LOC_CODEHotel location code - Provider Specific HOTEL_LOCATION_CODECHAR20CHAR20
CORPORATE_RATEHotel Rate Type HOTEL_RATE_TYPECHAR1FTPD_HOTEL_RATE_TYPE
RATE_NAMEDirect Hotel/Room Rate Name FTPD_HOTEL_RATE_NAMECHAR40CHAR40
EXCEEDING_FAREExcess Amount over Lowest Offer EXCEEDING_FARECURR10(2) FTPD_PRICE
EXCEEDING_FARE_CCurrency of Excess Amount over Lowest Offer EXCEEDING_FARE_CURRCUKY5Assigned to domainWAERS

Key field Non-key field



How do I retrieve data from SAP table FTPT_HOTEL using ABAP code

The following ABAP code Example will allow you to do a basic selection on FTPT_HOTEL to SELECT all data from the table
DATA: WA_FTPT_HOTEL TYPE FTPT_HOTEL.

SELECT SINGLE *
FROM FTPT_HOTEL
INTO CORRESPONDING FIELDS OF WA_FTPT_HOTEL
WHERE...

How to access SAP table FTPT_HOTEL

Within an ECC or HANA version of SAP you can also view further information about FTPT_HOTEL and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!