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
Here is some free PDF files that you can download free for your reference.
Download Now
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
Field | Note | Data Element | Domain |
---|---|---|---|
.INCLUDE | Key to travel plan table | ||
MANDT | Client | MANDT | MANDT |
PERNR | Personnel Number | PERNR_D | PERNR |
REINR | Trip Number | REINR | REINR |
PLANNR | Travel Plan Number (Sequential Number) | PLAN_NR | FTPD_PLAN_NR |
VARIANT | Plan variant number (sequential number) | VARIANT_NR | FTPD_VARIANT_NR |
VARIANTVRS | Version of travel plan | VARIANT_VERSION | FTPD_VARIANT_VERSION |
ITEM | Travel Request Item Number (Sequential Number) | ITEMPOS_NR | FTPD_ITEM_ID |
SERVICE | Hotel number | HOTEL_SERVICE_NR | FTPD_HOTEL_ID |
HOTEL | Hotel Chain | HOTEL_PROVIDER | FTPD_PROVIDER_CODE |
PROPERTY | Hotel Code (Key for an Individual Hotel) | HOTEL_PROPERTY | FTPD_HOTEL_PROP |
DATE_ARR | Arrival Date Hotel | HOTEL_DATE_ARR | FTPD_DATE |
DATE_DEP | Departure Date Hotel | HOTEL_DATE_DEP | FTPD_DATE |
LOC | Hotel Location | HOTEL_SLOCATION | FTPD_IATA_LOCATION |
NAME | Name of Hotel | HOTEL_NAME | TEXT40 |
ADDRESS | Hotel Address (address string separated by #) | HOTEL_ADDRESS | TEXT132 |
CLASS | Hotel category | HOTEL_CLASS | FTPD_HOTEL_CLASS |
ROOMTYPE | Hotel Room Type | HOTEL_ROOMTYPE | FTPD_HOTEL_ROOMTYPE |
MEALS | Hotel Meals | HOTEL_MEALS | FTPD_HOTEL_MEALS |
OCCUPANCY | Number of hotel occupants | HOTEL_OCCUPANCY | FTPD_INT1 |
ROOMS | Number of Hotel Rooms | HOTEL_NUMBER_OF_ROOMS | FTPD_INT1 |
BEDS | Number of Beds | HOTEL_NUMBER_OF_BEDS | CHAR1 |
BED_TYPE | Bed Type | HOTEL_BEDDING_TYPE | FTPD_BEDDING_TYPE |
ROOM_RATE_CODE | Rate Code (Hotel-Specific) | HOTEL_ROOM_RATE_CODE | CHAR3 |
RATE_CODE | Hotel Rate Category | HOTEL_RATE_PLAN_CODE | FTPD_HOTEL_RATE_CODE |
RATE_CHANGE_IND | Price Change Due To Requested Period of Stay | HOTEL_RATE_CHANGE | CHAR1_X |
GUARANTEE_NEEDED | Reservation Guarantee Required | HOTEL_GUARANTEE_NEEDED | CHAR1_X |
GUARANTEE | Guarantee for room reservation at booking | HOTEL_GUARANTEE | CHAR40 |
DEPOSIT_NEEDED | Deposit Required for Reservation | HOTEL_DEPOSIT_NEEDED | CHAR1_X |
DEPOSIT | Deposit payment method for room reservation | HOTEL_DEPOSIT | CHAR40 |
HOLD_IND | Guarantee for Room Availability | HOTEL_HOLD_IND | CHAR1_X |
HOLD_TIME | Time limit for guarantee of room availability | HOTEL_HOLD_TIME | FTPD_TIME |
SELL_RULE_IND | Reservation Rules Exist | HOTEL_SELL_RULE_IND | CHAR1_X |
CORPORATE_ID_IND | Company Identification Required | HOTEL_CORPORATE_ID_IND | CHAR1_X |
CORPORATE_ID | Company identification for room reservation | HOTEL_CORPORATE_ID | FTPD_CORPORATION_ID |
QUALIFIED_IND | Rate Category Indicator: Authorization Required | HOTEL_QUALIFIED_IND | CHAR1_X |
MIN_STAY_IND | Minimum Stay Required | HOTEL_MIN_STAY_IND | CHAR1_X |
TOTAL_RATE_IND | Total price | HOTEL_TOTAL_RATE_IND | CHAR1_X |
RATE | Rate/Price Per Night | HOTEL_RATE | FTPD_PRICE |
PRICE | Total Price for Hotel Stay | HOTEL_PRICE | FTPD_PRICE |
CURRENCY | Currency | HOTEL_CURRENCY | WAERS |
ADD_INFO | Additional hotel information | HOTEL_ADD_INFO | FTPD_INFO |
STATUS | Hotel Status | HOTEL_STATUS | FTPD_SERVICE_STATUS |
TEMPLATE | Template indicator | VARIANT_TEMPLATE | FTPD_TEMPLATE |
AREA_LOC | Hotel Area | HOTEL_AREA_LOC | FTPD_HOTEL_AREA |
TRANS_LOC | Transportation Option to Hotel | HOTEL_TRANS_LOC | FTPD_HOTEL_TRANSPORT |
CONF_NUM | Hotel Reservation Number | HOTEL_CONFIRMATION_NUMBER | FTPD_HOTEL_CONF_NUMBER |
MEMBSHIP_PROVCAT | Customer Program: Provider Category | MEMBSHIP_PROVIDER_CATEGORY | FTPD_PROVIDER_CATEGORY |
MEMBSHIP_PROV | Customer Program: Provider Code | MEMBSHIP_PROVIDER_CODE | FTPD_PROVIDER_CODE |
MEMBSHIP_KRZL | Customer Program Code | PROV_PROGRAM_SHORTHAND | FTPD_PROV_PROGRAM_SHORTHAND |
MEMBSHIP_ID | Customer number | PROV_PROGRAM_NR | CHAR20 |
FLIGHT_MEM_PROV | Frequent flyer program: Provider code | FLIGHT_PROGRAM_PROVIDER_CODE | FTPD_PROVIDER_CODE |
FLIGHT_MEM_KRZL | Frequent Flyer Program ID | FLIGHT_PROGRAM_SHORTHAND | FTPD_PROV_PROGRAM_SHORTHAND |
FLIGHT_MEM_ID | Frequent flyer number | FLIGHT_PROGRAM_NR | CHAR20 |
PNR_NR | Line Number of Hotel in PNR (if PNR available) | HOTEL_LINENUMBER | FTPD_PNR_NR |
PROFILE | Travel Profile | PROF_ID | FTPD_PROF_ID |
PROFITEM | Trip rule | PROF_ITEM | FTPD_PROF_ITEM |
KZTKT | Trip Activity Type | PLAN_ACTIVITY | FTPD_PLAN_ACTIVITY |
SPECHID | Class rule | SSPECID | FTPD_SSPEC_ID |
PRIORITY | Priority of trip rule | PROFIL_PRIROITY | FTPD_PROF_PRIORITY |
HIGHEST_PRIORITY | Priority of trip rule | PROFIL_PRIROITY | FTPD_PROF_PRIORITY |
COMPLETE_ACCESS | Direct Access to Reservation System of Hotel | COMPLETE_ACCESS_IND | FTPD_BOOLEAN |
BOOKING_CODE | Reservation Code for a Hotel Room | HOTEL_BOOKING_CODE | FTPD_HOTEL_BOOKING_CODE |
CATALOGUE_ID | Hotel Catalog Item (enterprise-specific) | HOTEL_ID | FTPD_HOTEL_INDEX |
CANCEL_TIME | Hotel Reservation: Cancelation Deadline | HOTEL_CANCEL_TIME | FTPD_CANCEL_TIME |
CANCEL_TYPE | Hotel Reservation: Time Unit for Cancelation Deadline | HOTEL_CANCEL_TYPE | FTPD_HOTEL_CANCEL_TYPE |
.INCLUDE | HR Master Record Infotype 0472 (Hotel Preferences) | ||
SMOKE | Nonsmoking Room Requested | HOTEL_PREF_SMOKE | CHAR1_X |
HCATG | Preferred Hotel Category | HOTEL_PREF_CLASS | FTPD_HOTEL_CLASS |
BEDTP | Preferred Bed Type | HOTEL_PREF_BEDTYPE | FTPD_BEDDING_TYPE |
RCATG | Preferred Room Category | HOTEL_PREF_ROOMTYPE | FTPD_HOTEL_ROOMTYPE |
PREF1 | Hotel Chain - First Preference | HOTEL_PREF_PROVIDER | FTPD_PROVIDER_CODE |
PREF2 | Hotel Chain - Second Preference | HOTEL_PREF_PROVIDER2 | FTPD_PROVIDER_CODE |
PREF3 | Hotel Chain - Third Preference | HOTEL_PREF_PROVIDER3 | FTPD_PROVIDER_CODE |
.INCLUDE | |||
.INCLUDE | Reason Code | ||
REASON_CODE | Reason Code | REASON_CODE | FTPD_REASON_CODE |
REASON_TEXT | Reason Text | REASON_TEXT | TEXT132 |
.INCLUDE | Encryptiong of Credit Card Data for Hotels | ||
GUARANTEE_GUID | GUID of a Payment Card | CARD_GUID | SYSUUID |
DEPOSIT_GUID | GUID of a Payment Card | CARD_GUID | SYSUUID |
.INCLU--AP | Append Structure for FTPT_HOTEL | ||
.INCLUDE | Append Structure HRS Connection for FTPT_HOTEL | ||
LOC_TEXT | Location for Hotel Search | HRS_HOTEL_LOCATION | TEXT64 |
COUNTRY | HRS Country Code | HRS_HOTEL_COUNTRY | INTCA3 |
SINGLE_DOUBLE | Room Occupancy | HRS_HOTEL_OCCUPANCY | FTPD_HRS_HOTEL_OCCUPANCY |
SEARCH_RADIUS | Radius for Hotel Search | HRS_HOTEL_SEARCH_RADIUS | FTPD_SEARCH_RADIUS |
HOTEL_NUMBER | HRS Hotel Number | HRS_HOTEL_NUMBER | CHAR10 |
BOOKING_NR | HRS Booking Number | HRS_HOTEL_BOOKING_NR | CHAR32 |
BOOKING_PW | HRS Booking Password | HRS_HOTEL_BOOKING_PW | CHAR32 |
RATE_NUMBER | HRS Rate | HRS_HOTEL_RATE_NUMBER | CHAR10 |
.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 | HOTEL_LOCATION_CODE | CHAR20 |
CORPORATE_RATE | Hotel Rate Type | HOTEL_RATE_TYPE | FTPD_HOTEL_RATE_TYPE |
RATE_NAME | Direct Hotel/Room Rate Name | FTPD_HOTEL_RATE_NAME | CHAR40 |
FTPT_HOTEL related tables
Table | Note |
---|---|
FTPT_HOTEL | Travel Request Item - Hotel Service |
TA20NHS | Negotiated Hotel Rates (Nego Rates) with Catalog Hotel |
TA21PHC | Hotel Codes of a Catalog Hotel in Reservation System |
FTPT_HOTEL_PREF | Hotel service preferences of a travel plan |
TA20PHC | Assignment Table of Hotel Catalog Items for Travel Profiles |
FTPT_CAR | Travel Request Item - Car Rental Service |
FTPT_FLIGHT | Travel Request Item - Flight Service |
FTPT_ITEM | Travel Service Request Item |
FTPT_OTHER | Travel Reservation Request Item - Other Service |
FTPT_QT_CAR | Quicktrip Travel Request Item - Flight Service |
FTPT_QT_FLIGHT | Quicktrip Travel Request Item - Flight Service |
FTPT_QT_HOTEL | Quicktrip Travel Request Item - Flight Service |
FTPT_QT_ITEM | Quicktrip Travel Service Request Item |
FTPT_TRAIN | Travel Request Item - Train Service |
TA23OS | Field Control for Travel Res. Request Item: Other Services |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP