FTPS_PNR_INTERF_HOTEL SAP (PNR Hotel) Structure details

Dictionary Type: Structure
Description: PNR Hotel




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




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

FTPS_PNR_INTERF_HOTEL is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "PNR Hotel" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FTPS_PNR_INTERF_HOTEL TYPE FTPS_PNR_INTERF_HOTEL.

The FTPS_PNR_INTERF_HOTEL table consists of various fields, each holding specific information or linking keys about PNR Hotel data available in SAP. These include CHAIN_CODE (Hotel Chain), LOCATION (Hotel Location), PROPERTY_CODE (Hotel Code (Key for an Individual Hotel)), CHECKIN_DATE (Arrival Date 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP FTPS_PNR_INTERF_HOTEL structure 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
LINE_NUMBER_CLine Number (CHAR Format) C_LINE_NUMBERNUMC5
CHAIN_CODEHotel Chain HOTEL_PROVIDERCHAR3Assigned to domainFTPD_PROVIDER_CODE
LOCATIONHotel 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
CHECKIN_TIMEField of type TIMS TIMSTIMS6TIME
CHECKOUT_DATEDeparture Date Hotel HOTEL_DATE_DEPDATS8FTPD_DATE
CHECKOUT_TIMEField of type TIMS TIMSTIMS6TIME
NAMEName of Hotel HOTEL_NAMECHAR40TEXT40
NUMBER_OF_ROOMS_C3-Byte field CHAR3CHAR3CHAR3
OCCUPANCY_C3-Byte field CHAR3CHAR3CHAR3
STATUS_CODEHotel Status HOTEL_STATUSCHAR2FTPD_SERVICE_STATUS
ROOMTYPEHotel Room Type HOTEL_ROOMTYPECHAR1FTPD_HOTEL_ROOMTYPE
BEDSNumber of Beds HOTEL_NUMBER_OF_BEDSCHAR1CHAR1
BED_TYPEBed Type HOTEL_BEDDING_TYPECHAR1FTPD_BEDDING_TYPE
ROOM_RATE_CODERate Code (Hotel-Specific) HOTEL_ROOM_RATE_CODECHAR3CHAR3
RATE_CODEHotel Rate Category HOTEL_RATE_PLAN_CODECHAR3Assigned to domainFTPD_HOTEL_RATE_CODE
BOOKING_CODEReservation Code for a Hotel Room HOTEL_BOOKING_CODECHAR10FTPD_HOTEL_BOOKING_CODE
CONFIRMATION_NRHotel Reservation Number HOTEL_CONFIRMATION_NUMBERCHAR17FTPD_HOTEL_CONF_NUMBER
BOOKING_SOURCEIdentification for booking/reservations BOOKING_SOURCECHAR40CHAR40
CORPORATE_IDCompany identification for room reservation HOTEL_CORPORATE_IDCHAR30FTPD_CORPORATION_ID
MEMBERSHIP_IDCustomer number PROV_PROGRAM_NRCHAR20CHAR20
SUPPLEMENTAL_INFOAdditional hotel information HOTEL_ADD_INFOCHAR132FTPD_INFO
NAME_IN_SEGCharacter field of length 40 CHAR40CHAR40CHAR40
TOTAL_RATE_INDTotal price HOTEL_TOTAL_RATE_INDCHAR1CHAR1_X
RATE_QUOTE_RATERate/Price Per Night HOTEL_RATECURR10(2) FTPD_PRICE
RATE_QUOTE_CURRCurrency HOTEL_CURRENCYCUKY5Assigned to domainWAERS
DEPOSIT_CREDIT_CARD_CODE3-Byte field CHAR3CHAR3CHAR3
DEPOSIT_CREDIT_CARD_NUMBERField Name CHAR21CHAR21CHAR21
DEPOSIT_CREDIT_CARD_DATEField of type DATS DATSDATS8DATS
DEPOSIT_AMOUNTHotel Deposit Amount HOTEL_DEPOSIT_AMOUNTCURR10(2) FTPD_PRICE
DEPOSIT_CURRCurrency Key CURCYCUKY5Assigned to domainWAERSFWS
GUARANTEE_CREDIT_CARD_VENDOR3-Byte field CHAR3CHAR3CHAR3
GUARANTEE_CREDIT_CARD_NUMBERField Name CHAR21CHAR21CHAR21
GUARANTEE_CREDIT_CARD_DATEField of type DATS DATSDATS8DATS
GUARANTEE_AMOUNTGuaran. Amount HOTEL_GUARANTEE_AMOUNTCURR10(2) FTPD_PRICE
GUARANTEE_CURRCurrency Key CURCYCUKY5Assigned to domainWAERSFWS
COMP_ACC_SELLDirect Access to Reservation System of Hotel COMPLETE_ACCESS_INDCHAR1FTPD_BOOLEAN
PASSENGER_ID_CPassenger Number C_PASS_IDNUMC5
ADDRESSHotel Address (address string separated by #) HOTEL_ADDRESSCHAR132TEXT132

Key field Non-key field



How do I retrieve data from SAP structure FTPS_PNR_INTERF_HOTEL using ABAP code?

As FTPS_PNR_INTERF_HOTEL is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FTPS_PNR_INTERF_HOTEL as there is no data to select.

How to access SAP table FTPS_PNR_INTERF_HOTEL

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