TA23HOTELS

Hotel Data | #other | Component: Travel Planning
Column Name Description
MANDT Client
GDS FK Reservation System
CHAIN FK Hotel Chain
LOCATION FK 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 | to Other Relations ↓ Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • TA23HOTELS.COUNTRY == T005.LAND1
  • TA23HOTELS.MANDT == T005.MANDT
Hotel Location
  • Hotel Location
  • Client
  • TA23HOTELS.LOCATION == TA21L.LOCID
  • TA23HOTELS.MANDT == TA21L.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • TA23HOTELS.MANDT == T005S.MANDT
  • TA23HOTELS.COUNTRY == T005S.LAND1
  • TA23HOTELS.REGION == T005S.BLAND
Other Relations | to Master Data Relations ↑ Join Conditions
Hotel Chain
  • ?
  • Hotel Chain
  • Client
  • TA23HOTELS.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • TA23HOTELS.CHAIN == TA21P.PROVIDER
  • TA23HOTELS.MANDT == TA21P.MANDT
Reservation System
  • ?
  • Reservation System
  • Client
  • TA23HOTELS.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • TA23HOTELS.GDS == TA21P.PROVIDER
  • TA23HOTELS.MANDT == TA21P.MANDT