FTPT_HOTEL_DATA SAP (Hotel Data) Table details

Dictionary Type: Table
Description: Hotel Data




ABAP Code to SELECT data from FTPT_HOTEL_DATA
Related tables to FTPT_HOTEL_DATA
Access table FTPT_HOTEL_DATA




Table field list including key, data, relationships and ABAP select examples

FTPT_HOTEL_DATA is a standard SAP Table which is used to store Hotel Data data and is available within R/3 SAP systems depending on the version and release level.

The FTPT_HOTEL_DATA table consists of various fields, each holding specific information or linking keys about Hotel Data data available in SAP. These include GDS (Reservation System), CHAIN (Hotel Chain), LOCATION (Hotel Location), PROPERTY (Hotel Code (Key for an Individual Hotel)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP FTPT_HOTEL_DATA table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
GDSReservation System RESERVATION_SYSTEMCHAR3Assigned to domainFTPD_PROVIDER_CODE
CHAINHotel Chain HOTEL_PROVIDERCHAR3Assigned to domainFTPD_PROVIDER_CODE
LOCATIONHotel Location HOTEL_SLOCATIONCHAR3Assigned to domainFTPD_IATA_LOCATION
PROPERTYHotel Code (Key for an Individual Hotel) HOTEL_PROPERTYCHAR6FTPD_HOTEL_PROP
LATITUDEGeo location latitude GEOLATDEC15(12) GEOLONLAT
LONGITUDEGeo location longitude GEOLONDEC15(12) GEOLONLAT
COUNTRYCountry Key LAND1CHAR3T005LAND1LND
REGIONSTATE (State, Province, County) REGIOCHAR3T005SREGIO
CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
POST_CODECity postal code AD_PSTCD1CHAR10CHAR10
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
HOUSE_NUMHouse Number AD_HSNM1CHAR10TEXT10
NAMEName of Hotel HOTEL_NAMECHAR40TEXT40
NAME_ULName of Hotel HOTEL_NAMECHAR40TEXT40
PHONETelephone Number AP_PHONE_NUMBERCHAR40CHAR40
FAXFax Number HOTEL_FAXCHAR40CHAR40
URLURL (Uniform Resource Locator) of Information Source INFO_URLCHAR255TEXT255

Key field Non-key field



How do I retrieve data from SAP table FTPT_HOTEL_DATA using ABAP code

The following ABAP code Example will allow you to do a basic selection on FTPT_HOTEL_DATA to SELECT all data from the table
DATA: WA_FTPT_HOTEL_DATA TYPE FTPT_HOTEL_DATA.

SELECT SINGLE *
FROM FTPT_HOTEL_DATA
INTO CORRESPONDING FIELDS OF WA_FTPT_HOTEL_DATA
WHERE...

How to access SAP table FTPT_HOTEL_DATA

Within an ECC or HANA version of SAP you can also view further information about FTPT_HOTEL_DATA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!