TA23HOTELS - Hotel Data

Hotel Data information is stored in SAP table TA23HOTELS.
It is part of development package PTRP_ADDON in software component FI-TV-PL. This development package consists of objects that can be grouped under "Travel Planning Add-On".

Fields for table TA23HOTELS

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	*
GDS	Reservation System	X	RESERVATION_SYSTEM	CHAR	6	TA21P
CHAIN	Hotel Chain	X	HOTEL_PROVIDER	CHAR	6	TA21P
LOCATION	Hotel Location	X	HOTEL_SLOCATION	CHAR	6	TA21L
PROPERTY	Hotel Code (Key for an Individual Hotel)	X	HOTEL_PROPERTY	CHAR	12
.INCLUDE	GEOCODING			FTPS_WEB_GEOCODING	0
LATITUDE	Geo location latitude		GEOLAT	DEC	8
LONGITUDE	Geo location longitude		GEOLON	DEC	8
.INCLUDE	ADDRESS			FTPS_WEB_ADDRESS	0
COUNTRY	Country/Region Key		LAND1	CHAR	6	T005
REGION	Region (State, Province, County)		REGIO	CHAR	6	T005S
CITY	City		AD_CITY1	CHAR	80
POST_CODE	City postal code		AD_PSTCD1	CHAR	20
STREET	Street		AD_STREET	CHAR	120
HOUSE_NUM	House Number		AD_HSNM1	CHAR	20
NAME	Name of Hotel		HOTEL_NAME	CHAR	80
NAME_UL	Name of Hotel		HOTEL_NAME	CHAR	80
PHONE	Telephone Number		AP_PHONE_NUMBER	CHAR	80
FAX	Fax Number		HOTEL_FAX	CHAR	80
URL	URL (Uniform Resource Locator) of Information Source		INFO_URL	CHAR	510