FTPT_HOTEL_DATA

Hotel Data | #transactional | Component: Travel Planning
Column Name Description
MANDT Client
GDS Reservation System
CHAIN Hotel Chain
LOCATION Hotel Location
PROPERTY Hotel Code (Key for an Individual Hotel)
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
LATITUDE Geo location latitude GEOLONLAT
LONGITUDE Geo location longitude GEOLONLAT
CITY City TEXT40
POST_CODE City postal code CHAR10
STREET Street TEXT60
HOUSE_NUM House Number TEXT10
NAME Name of Hotel TEXT40
NAME_UL Name of Hotel TEXT40
PHONE Telephone Number CHAR40
FAX Fax Number CHAR40
URL URL (Uniform Resource Locator) of Information Source TEXT255
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • FTPT_HOTEL_DATA.COUNTRY == T005.LAND1
  • FTPT_HOTEL_DATA.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • FTPT_HOTEL_DATA.MANDT == T005S.MANDT
  • FTPT_HOTEL_DATA.COUNTRY == T005S.LAND1
  • FTPT_HOTEL_DATA.REGION == T005S.BLAND