SAP ABAP Table FTPT_HOTEL_PREF (Hotel service preferences of a travel plan)
Hierarchy
☛ SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   ⤷ FI-TV-PL (Application Component) Travel Planning
     ⤷ PTRP (Package) Travel Planning
Basic Data
Table Category TRANSP    Transparent table 
Transparent table FTPT_HOTEL_PREF   Table Relationship Diagram
Short Description Hotel service preferences of a travel plan    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 .INCLUDE       0   0   Key to travel plan table  
2 MANDT MANDT MANDT CLNT 3   0   Client *
3 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
4 REINR REINR REINR NUMC 10   0   Trip Number  
5 PLANNR PLAN_NR FTPD_PLAN_NR NUMC 2   0   Travel Plan Number (Sequential Number) *
6 VARIANT VARIANT_NR FTPD_VARIANT_NR NUMC 2   0   Plan variant number (sequential number)  
7 VARIANTVRS VARIANT_VERSION FTPD_VARIANT_VERSION NUMC 2   0   Version of travel plan *
8 ITEM ITEMPOS_NR FTPD_ITEM_ID NUMC 3   0   Travel Request Item Number (Sequential Number) *
9 SERVICE HOTEL_SERVICE_NR FTPD_HOTEL_ID NUMC 3   0   Hotel number FTPT_HOTEL
10 SMOKE HOTEL_PREF_SMOKE CHAR1_X CHAR 1   0   Nonsmoking Room Requested  
11 HCATG HOTEL_PREF_CLASS FTPD_HOTEL_CLASS CHAR 1   0   Preferred Hotel Category  
12 BEDTP HOTEL_PREF_BEDTYPE FTPD_BEDDING_TYPE CHAR 1   0   Preferred Bed Type  
13 RCATG HOTEL_PREF_ROOMTYPE FTPD_HOTEL_ROOMTYPE CHAR 1   0   Preferred Room Category  
14 PREF1 HOTEL_PREF_PROVIDER FTPD_PROVIDER_CODE CHAR 3   0   Hotel Chain - First Preference *
15 PREF2 HOTEL_PREF_PROVIDER2 FTPD_PROVIDER_CODE CHAR 3   0   Hotel Chain - Second Preference *
16 PREF3 HOTEL_PREF_PROVIDER3 FTPD_PROVIDER_CODE CHAR 3   0   Hotel Chain - Third Preference *
17 INFO_TEXT HOTEL_INFO_TEXT CHAR45 CHAR 45   0   Additional text for user request  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 FTPT_HOTEL_PREF SERVICE FTPT_HOTEL ITEM KEY 1 C
History
Last changed by/on SAP  20020219 
SAP Release Created in