SAP Table TA23HOTELS

Hotel Data

The table TA23HOTELS (Hotel Data) is a standard table in SAP ERP. It belongs to the package PTRP_ADDON.

Technical Information

Table	TA23HOTELS
Short Text	Hotel Data
Package	PTRP_ADDON
Table Type	Transparent Table

Fields for Table TA23HOTELS

Field Name	Key	Description	Data Element	Type	Length	Check Table
MANDT	✔	Client	MANDT	CLNT	3	*
GDS	✔	Reservation System	RESERVATION_SYSTEM	CHAR	3	TA21P
CHAIN	✔	Hotel Chain	HOTEL_PROVIDER	CHAR	3	TA21P
LOCATION	✔	Hotel Location	HOTEL_SLOCATION	CHAR	3	TA21L
PROPERTY	✔	Hotel Code (Key for an Individual Hotel)	HOTEL_PROPERTY	CHAR	6
LATITUDE		Geo location latitude	GEOLAT	DEC	15
LONGITUDE		Geo location longitude	GEOLON	DEC	15
COUNTRY		Country Key	LAND1	CHAR	3	T005
CITY		City	AD_CITY1	CHAR	40
POST_CODE		City postal code	AD_PSTCD1	CHAR	10
STREET		Street	AD_STREET	CHAR	60
HOUSE_NUM		House Number	AD_HSNM1	CHAR	10
NAME		Name of Hotel	HOTEL_NAME	CHAR	40
NAME_UL		Name of Hotel	HOTEL_NAME	CHAR	40
PHONE		Telephone Number	AP_PHONE_NUMBER	CHAR	40
FAX		Fax Number	HOTEL_FAX	CHAR	40
URL		URL (Uniform Resource Locator) of Information Source	INFO_URL	CHAR	255