SAP ABAP Table FTPT_HOTEL_DATA (Hotel Data)
Hierarchy
☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ FI-TV-PL (Application Component) Travel Planning
     ⤷ PTRP_WEB_INTERFACE (Package) RFC Modules for Web User Interface: Travel Planning
Basic Data
Table Category TRANSP    Transparent table 
Transparent table FTPT_HOTEL_DATA   Table Relationship Diagram
Short Description Hotel Data    
Delivery and Maintenance
Pool/cluster      
Delivery Class C   Customizing table, maintenance only by cust., not SAP import 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client *
2 GDS RESERVATION_SYSTEM FTPD_PROVIDER_CODE CHAR 3   0   Reservation System *
3 CHAIN HOTEL_PROVIDER FTPD_PROVIDER_CODE CHAR 3   0   Hotel Chain *
4 LOCATION HOTEL_SLOCATION FTPD_IATA_LOCATION CHAR 3   0   Hotel Location *
5 PROPERTY HOTEL_PROPERTY FTPD_HOTEL_PROP CHAR 6   0   Hotel Code (Key for an Individual Hotel)  
6 .INCLUDE       0   0   Travel Web Interface: Geocoding  
7 LATITUDE GEOLAT GEOLONLAT DEC 15   12   Geo location latitude  
8 LONGITUDE GEOLON GEOLONLAT DEC 15   12   Geo location longitude  
9 .INCLUDE       0   0   Travel Web Interface: Addresses  
10 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
11 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
12 CITY AD_CITY1 TEXT40 CHAR 40   0   City  
13 POST_CODE AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
14 STREET AD_STREET TEXT60 CHAR 60   0   Street  
15 HOUSE_NUM AD_HSNM1 TEXT10 CHAR 10   0   House Number  
16 NAME HOTEL_NAME TEXT40 CHAR 40   0   Name of Hotel  
17 NAME_UL HOTEL_NAME TEXT40 CHAR 40   0   Name of Hotel  
18 PHONE AP_PHONE_NUMBER CHAR40 CHAR 40   0   Telephone Number  
19 FAX HOTEL_FAX CHAR40 CHAR 40   0   Fax Number  
20 URL INFO_URL TEXT255 CHAR 255   0   URL (Uniform Resource Locator) of Information Source  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 FTPT_HOTEL_DATA COUNTRY T005 LAND1 KEY 1 CN
2 FTPT_HOTEL_DATA REGION T005S BLAND KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 500