FTPT_QT_HOTEL SAP (Quicktrip Travel Request Item - Flight Service) Table details

Dictionary Type: Table
Description: Quicktrip Travel Request Item - Flight Service




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




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

FTPT_QT_HOTEL is a standard SAP Table which is used to store Quicktrip Travel Request Item - Flight Service data and is available within R/3 SAP systems depending on the version and release level.

The FTPT_QT_HOTEL table consists of various fields, each holding specific information or linking keys about Quicktrip Travel Request Item - Flight Service data available in SAP. These include QTNR (Quicktrip Number), ITEM (Travel Request Item Number (Sequential Number)), ITEM_ALTERN (Alternative Line Item Number), SERVICE (Hotel number).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP FTPT_QT_HOTEL 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
QTNRQuicktrip Number QTNRNUMC5FTPD_QTNR
ITEMTravel Request Item Number (Sequential Number) ITEMPOS_NRNUMC3Assigned to domainFTPD_ITEM_ID
ITEM_ALTERNAlternative Line Item Number ALTERNPOS_NRNUMC3Assigned to domainFTPD_ITEM_ID
SERVICEHotel number HOTEL_SERVICE_NRNUMC3Assigned to domainFTPD_HOTEL_ID
SERVICE_ALTERNAlternative Hotel Number HOTEL_ALTERN_NRNUMC3Assigned to domainFTPD_HOTEL_ID
CHAIN_CODEHotel Chain HOTEL_PROVIDERCHAR3Assigned to domainFTPD_PROVIDER_CODE
CITY_CODEHotel Location HOTEL_SLOCATIONCHAR3Assigned to domainFTPD_IATA_LOCATION
PROPERTY_CODEHotel Code (Key for an Individual Hotel) HOTEL_PROPERTYCHAR6FTPD_HOTEL_PROP
CHECKIN_DATEArrival Date Hotel HOTEL_DATE_ARRDATS8FTPD_DATE
CHECKOUT_DATEDeparture Date Hotel HOTEL_DATE_DEPDATS8FTPD_DATE
OCCUPANCYNumber of hotel occupants HOTEL_OCCUPANCYINT13FTPD_INT1
ROOMTYPEHotel Room Type HOTEL_ROOMTYPECHAR1FTPD_HOTEL_ROOMTYPE
BEDSNumber of Beds HOTEL_NUMBER_OF_BEDSCHAR1CHAR1
BED_TYPEBed Type HOTEL_BEDDING_TYPECHAR1FTPD_BEDDING_TYPE
RATE_CODEHotel Rate Category HOTEL_RATE_PLAN_CODECHAR3Assigned to domainFTPD_HOTEL_RATE_CODE
COMPLETE_ACCESSDirect Access to Reservation System of Hotel COMPLETE_ACCESS_INDCHAR1FTPD_BOOLEAN

Key field Non-key field



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

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

SELECT SINGLE *
FROM FTPT_QT_HOTEL
INTO CORRESPONDING FIELDS OF WA_FTPT_QT_HOTEL
WHERE...

How to access SAP table FTPT_QT_HOTEL

Within an ECC or HANA version of SAP you can also view further information about FTPT_QT_HOTEL 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!