SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

FTPT_HOTEL Table in SAP | Travel Request Item - Hotel Service Table & Fields List

FTPT_HOTEL is a SAP table coming under FI module and SAP_HRGXX component.View details, Fields & related tables of FTPT_HOTEL in SAP.

  • Table description : Travel Request Item - Hotel Service
  • Module : FI-TV-PL
  • Parent Module : FI
  • Package : PTRP
  • Software Component : SAP_HRGXX
FTPT_HOTEL table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP FTPT_HOTEL Table Fields structure

FieldNoteData ElementDomain
.INCLUDEKey to travel plan table    
MANDTClientMANDTMANDT
PERNRPersonnel NumberPERNR_DPERNR
REINRTrip NumberREINRREINR
PLANNRTravel Plan Number (Sequential Number)PLAN_NRFTPD_PLAN_NR
VARIANTPlan variant number (sequential number)VARIANT_NRFTPD_VARIANT_NR
VARIANTVRSVersion of travel planVARIANT_VERSIONFTPD_VARIANT_VERSION
ITEMTravel Request Item Number (Sequential Number)ITEMPOS_NRFTPD_ITEM_ID
SERVICEHotel numberHOTEL_SERVICE_NRFTPD_HOTEL_ID
HOTELHotel ChainHOTEL_PROVIDERFTPD_PROVIDER_CODE
PROPERTYHotel Code (Key for an Individual Hotel)HOTEL_PROPERTYFTPD_HOTEL_PROP
DATE_ARRArrival Date HotelHOTEL_DATE_ARRFTPD_DATE
DATE_DEPDeparture Date HotelHOTEL_DATE_DEPFTPD_DATE
LOCHotel LocationHOTEL_SLOCATIONFTPD_IATA_LOCATION
NAMEName of HotelHOTEL_NAMETEXT40
ADDRESSHotel Address (address string separated by #)HOTEL_ADDRESSTEXT132
CLASSHotel categoryHOTEL_CLASSFTPD_HOTEL_CLASS
ROOMTYPEHotel Room TypeHOTEL_ROOMTYPEFTPD_HOTEL_ROOMTYPE
MEALSHotel MealsHOTEL_MEALSFTPD_HOTEL_MEALS
OCCUPANCYNumber of hotel occupantsHOTEL_OCCUPANCYFTPD_INT1
ROOMSNumber of Hotel RoomsHOTEL_NUMBER_OF_ROOMSFTPD_INT1
BEDSNumber of BedsHOTEL_NUMBER_OF_BEDSCHAR1
BED_TYPEBed TypeHOTEL_BEDDING_TYPEFTPD_BEDDING_TYPE
ROOM_RATE_CODERate Code (Hotel-Specific)HOTEL_ROOM_RATE_CODECHAR3
RATE_CODEHotel Rate CategoryHOTEL_RATE_PLAN_CODEFTPD_HOTEL_RATE_CODE
RATE_CHANGE_INDPrice Change Due To Requested Period of StayHOTEL_RATE_CHANGECHAR1_X
GUARANTEE_NEEDEDReservation Guarantee RequiredHOTEL_GUARANTEE_NEEDEDCHAR1_X
GUARANTEEGuarantee for room reservation at bookingHOTEL_GUARANTEECHAR40
DEPOSIT_NEEDEDDeposit Required for ReservationHOTEL_DEPOSIT_NEEDEDCHAR1_X
DEPOSITDeposit payment method for room reservationHOTEL_DEPOSITCHAR40
HOLD_INDGuarantee for Room AvailabilityHOTEL_HOLD_INDCHAR1_X
HOLD_TIMETime limit for guarantee of room availabilityHOTEL_HOLD_TIMEFTPD_TIME
SELL_RULE_INDReservation Rules ExistHOTEL_SELL_RULE_INDCHAR1_X
CORPORATE_ID_INDCompany Identification RequiredHOTEL_CORPORATE_ID_INDCHAR1_X
CORPORATE_IDCompany identification for room reservationHOTEL_CORPORATE_IDFTPD_CORPORATION_ID
QUALIFIED_INDRate Category Indicator: Authorization RequiredHOTEL_QUALIFIED_INDCHAR1_X
MIN_STAY_INDMinimum Stay RequiredHOTEL_MIN_STAY_INDCHAR1_X
TOTAL_RATE_INDTotal priceHOTEL_TOTAL_RATE_INDCHAR1_X
RATERate/Price Per NightHOTEL_RATEFTPD_PRICE
PRICETotal Price for Hotel StayHOTEL_PRICEFTPD_PRICE
CURRENCYCurrencyHOTEL_CURRENCYWAERS
ADD_INFOAdditional hotel informationHOTEL_ADD_INFOFTPD_INFO
STATUSHotel StatusHOTEL_STATUSFTPD_SERVICE_STATUS
TEMPLATETemplate indicatorVARIANT_TEMPLATEFTPD_TEMPLATE
AREA_LOCHotel AreaHOTEL_AREA_LOCFTPD_HOTEL_AREA
TRANS_LOCTransportation Option to HotelHOTEL_TRANS_LOCFTPD_HOTEL_TRANSPORT
CONF_NUMHotel Reservation NumberHOTEL_CONFIRMATION_NUMBERFTPD_HOTEL_CONF_NUMBER
MEMBSHIP_PROVCATCustomer Program: Provider CategoryMEMBSHIP_PROVIDER_CATEGORYFTPD_PROVIDER_CATEGORY
MEMBSHIP_PROVCustomer Program: Provider CodeMEMBSHIP_PROVIDER_CODEFTPD_PROVIDER_CODE
MEMBSHIP_KRZLCustomer Program CodePROV_PROGRAM_SHORTHANDFTPD_PROV_PROGRAM_SHORTHAND
MEMBSHIP_IDCustomer numberPROV_PROGRAM_NRCHAR20
FLIGHT_MEM_PROVFrequent flyer program: Provider codeFLIGHT_PROGRAM_PROVIDER_CODEFTPD_PROVIDER_CODE
FLIGHT_MEM_KRZLFrequent Flyer Program IDFLIGHT_PROGRAM_SHORTHANDFTPD_PROV_PROGRAM_SHORTHAND
FLIGHT_MEM_IDFrequent flyer numberFLIGHT_PROGRAM_NRCHAR20
PNR_NRLine Number of Hotel in PNR (if PNR available)HOTEL_LINENUMBERFTPD_PNR_NR
PROFILETravel ProfilePROF_IDFTPD_PROF_ID
PROFITEMTrip rulePROF_ITEMFTPD_PROF_ITEM
KZTKTTrip Activity TypePLAN_ACTIVITYFTPD_PLAN_ACTIVITY
SPECHIDClass ruleSSPECIDFTPD_SSPEC_ID
PRIORITYPriority of trip rulePROFIL_PRIROITYFTPD_PROF_PRIORITY
HIGHEST_PRIORITYPriority of trip rulePROFIL_PRIROITYFTPD_PROF_PRIORITY
COMPLETE_ACCESSDirect Access to Reservation System of HotelCOMPLETE_ACCESS_INDFTPD_BOOLEAN
BOOKING_CODEReservation Code for a Hotel RoomHOTEL_BOOKING_CODEFTPD_HOTEL_BOOKING_CODE
CATALOGUE_IDHotel Catalog Item (enterprise-specific)HOTEL_IDFTPD_HOTEL_INDEX
CANCEL_TIMEHotel Reservation: Cancelation DeadlineHOTEL_CANCEL_TIMEFTPD_CANCEL_TIME
CANCEL_TYPEHotel Reservation: Time Unit for Cancelation DeadlineHOTEL_CANCEL_TYPEFTPD_HOTEL_CANCEL_TYPE
.INCLUDEHR Master Record Infotype 0472 (Hotel Preferences)    
SMOKENonsmoking Room RequestedHOTEL_PREF_SMOKECHAR1_X
HCATGPreferred Hotel CategoryHOTEL_PREF_CLASSFTPD_HOTEL_CLASS
BEDTPPreferred Bed TypeHOTEL_PREF_BEDTYPEFTPD_BEDDING_TYPE
RCATGPreferred Room CategoryHOTEL_PREF_ROOMTYPEFTPD_HOTEL_ROOMTYPE
PREF1Hotel Chain - First PreferenceHOTEL_PREF_PROVIDERFTPD_PROVIDER_CODE
PREF2Hotel Chain - Second PreferenceHOTEL_PREF_PROVIDER2FTPD_PROVIDER_CODE
PREF3Hotel Chain - Third PreferenceHOTEL_PREF_PROVIDER3FTPD_PROVIDER_CODE
.INCLUDE   
.INCLUDEReason Code    
REASON_CODEReason CodeREASON_CODEFTPD_REASON_CODE
REASON_TEXTReason TextREASON_TEXTTEXT132
.INCLUDEEncryptiong of Credit Card Data for Hotels    
GUARANTEE_GUIDGUID of a Payment CardCARD_GUIDSYSUUID
DEPOSIT_GUIDGUID of a Payment CardCARD_GUIDSYSUUID
.INCLU--APAppend Structure for FTPT_HOTEL    
.INCLUDEAppend Structure HRS Connection for FTPT_HOTEL    
LOC_TEXTLocation for Hotel SearchHRS_HOTEL_LOCATIONTEXT64
COUNTRYHRS Country CodeHRS_HOTEL_COUNTRYINTCA3
SINGLE_DOUBLERoom OccupancyHRS_HOTEL_OCCUPANCYFTPD_HRS_HOTEL_OCCUPANCY
SEARCH_RADIUSRadius for Hotel SearchHRS_HOTEL_SEARCH_RADIUSFTPD_SEARCH_RADIUS
HOTEL_NUMBERHRS Hotel NumberHRS_HOTEL_NUMBERCHAR10
BOOKING_NRHRS Booking NumberHRS_HOTEL_BOOKING_NRCHAR32
BOOKING_PWHRS Booking PasswordHRS_HOTEL_BOOKING_PWCHAR32
RATE_NUMBERHRS RateHRS_HOTEL_RATE_NUMBERCHAR10
.INCLU--APAppend Structure - Fields needed for Direct Hotel Providers    
.INCLUDEStructure Fields needed for Direct Hotel Providers    
LOC_CODEHotel location code - Provider SpecificHOTEL_LOCATION_CODECHAR20
CORPORATE_RATEHotel Rate TypeHOTEL_RATE_TYPEFTPD_HOTEL_RATE_TYPE
RATE_NAMEDirect Hotel/Room Rate NameFTPD_HOTEL_RATE_NAMECHAR40

FTPT_HOTEL related tables

TableNote
FTPT_HOTELTravel Request Item - Hotel Service
TA20NHSNegotiated Hotel Rates (Nego Rates) with Catalog Hotel
TA21PHCHotel Codes of a Catalog Hotel in Reservation System
FTPT_HOTEL_PREFHotel service preferences of a travel plan
TA20PHCAssignment Table of Hotel Catalog Items for Travel Profiles
FTPT_CARTravel Request Item - Car Rental Service
FTPT_FLIGHTTravel Request Item - Flight Service
FTPT_ITEMTravel Service Request Item
FTPT_OTHERTravel Reservation Request Item - Other Service
FTPT_QT_CARQuicktrip Travel Request Item - Flight Service
FTPT_QT_FLIGHTQuicktrip Travel Request Item - Flight Service
FTPT_QT_HOTELQuicktrip Travel Request Item - Flight Service
FTPT_QT_ITEMQuicktrip Travel Service Request Item
FTPT_TRAINTravel Request Item - Train Service
TA23OSField Control for Travel Res. Request Item: Other Services
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com