SAP Table TA23HOTELS
Hotel Data
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
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 |