FTPS_PNR_HOTEL_RES_OUT SAP (PNR Hotel) Structure details
Description: PNR Hotel
Related tables to FTPS_PNR_HOTEL_RES_OUT
Access table FTPS_PNR_HOTEL_RES_OUT
Structure field list including key, data, relationships and ABAP select examples
FTPS_PNR_HOTEL_RES_OUT 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_HOTEL_RES_OUT TYPE FTPS_PNR_HOTEL_RES_OUT.
The FTPS_PNR_HOTEL_RES_OUT 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: Not classified
SAP FTPS_PNR_HOTEL_RES_OUT 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 | Line Number in PNR | 0 | |||||||
CHAIN_CODE | Hotel Chain | HOTEL_PROVIDER | CHAR | 3 | Assigned to domain | FTPD_PROVIDER_CODE | |||
LOCATION | Hotel Location | HOTEL_SLOCATION | CHAR | 3 | Assigned to domain | FTPD_IATA_LOCATION | |||
PROPERTY_CODE | Hotel Code (Key for an Individual Hotel) | HOTEL_PROPERTY | CHAR | 6 | FTPD_HOTEL_PROP | ||||
CHECKIN_DATE | Arrival Date Hotel | HOTEL_DATE_ARR | DATS | 8 | FTPD_DATE | ||||
CHECKIN_TIME | Checkin Time | 0 | |||||||
CHECKOUT_DATE | Departure Date Hotel | HOTEL_DATE_DEP | DATS | 8 | FTPD_DATE | ||||
CHECKOUT_TIME | Depart. Time | 0 | |||||||
NAME | Name of Hotel | HOTEL_NAME | CHAR | 40 | TEXT40 | ||||
NUMBER_OF_ROOMS | Number of Hotel Rooms | HOTEL_NUMBER_OF_ROOMS | INT1 | 3 | FTPD_INT1 | ||||
OCCUPANCY | Number of hotel occupants | HOTEL_OCCUPANCY | INT1 | 3 | FTPD_INT1 | ||||
STATUS_CODE | Hotel Status | HOTEL_STATUS | CHAR | 2 | FTPD_SERVICE_STATUS | ||||
ROOMTYPE | Hotel Room Type | HOTEL_ROOMTYPE | CHAR | 1 | FTPD_HOTEL_ROOMTYPE | ||||
BEDS | Number of Beds | HOTEL_NUMBER_OF_BEDS | CHAR | 1 | CHAR1 | ||||
BED_TYPE | Bed Type | HOTEL_BEDDING_TYPE | CHAR | 1 | FTPD_BEDDING_TYPE | ||||
ROOM_RATE_CODE | Rate Code (Hotel-Specific) | HOTEL_ROOM_RATE_CODE | CHAR | 3 | CHAR3 | ||||
RATE_CODE | Hotel Rate Category | HOTEL_RATE_PLAN_CODE | CHAR | 3 | Assigned to domain | FTPD_HOTEL_RATE_CODE | |||
BOOKING_CODE | Reservation Code for a Hotel Room | HOTEL_BOOKING_CODE | CHAR | 10 | FTPD_HOTEL_BOOKING_CODE | ||||
CONFIRMATION_NR | Hotel Reservation Number | HOTEL_CONFIRMATION_NUMBER | CHAR | 17 | FTPD_HOTEL_CONF_NUMBER | ||||
BOOKING_SOURCE | Identification for booking/reservations | BOOKING_SOURCE | CHAR | 40 | CHAR40 | ||||
CORPORATE_ID | Company identification for room reservation | HOTEL_CORPORATE_ID | CHAR | 30 | FTPD_CORPORATION_ID | ||||
MEMBERSHIP_ID | Customer number | PROV_PROGRAM_NR | CHAR | 20 | CHAR20 | ||||
SUPPLEMENTAL_INFO | Additional hotel information | HOTEL_ADD_INFO | CHAR | 132 | FTPD_INFO | ||||
NAME_IN_SEG | Name of Traveler | 0 | |||||||
TOTAL_RATE_IND | Total price | HOTEL_TOTAL_RATE_IND | CHAR | 1 | CHAR1_X | ||||
RATE_QUOTE_RATE | Rate/Price Per Night | HOTEL_RATE | CURR | 10(2) | FTPD_PRICE | ||||
RATE_QUOTE_CURR | Currency | HOTEL_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | |||
DEPOSIT_CREDIT_CARD_CODE | Deposit: Credit Card Company | 0 | |||||||
DEPOSIT_CREDIT_CARD_NUMBER | Deposit: Credit Card Number | 0 | |||||||
DEPOSIT_CREDIT_CARD_DATE | Deposit: Credit Card Date | 0 | |||||||
DEPOSIT_AMOUNT | Deposit: Amount | 0 | |||||||
DEPOSIT_CURR | Deposit: Total | 0 | |||||||
GUARANTEE_CREDIT_CARD_VENDOR | Guaranteed Reservation: Credit Card Company | 0 | |||||||
GUARANTEE_CREDIT_CARD_NUMBER | Guaranteed Reservation: Credit Card Number | 0 | |||||||
GUARANTEE_CREDIT_CARD_DATE | Guaranteed Reservation: Credit Card Date | 0 | |||||||
GUARANTEE_AMOUNT | Guaranteed Reservation: Total | 0 | |||||||
GUARANTEE_CURR | Guaranteed Reservation: Amount | 0 | |||||||
COMP_ACC_SELL | Direct Access to Reservation System of Hotel | COMPLETE_ACCESS_IND | CHAR | 1 | FTPD_BOOLEAN | ||||
ADDRESS | Hotel Address (address string separated by #) | HOTEL_ADDRESS | CHAR | 132 | TEXT132 | ||||
PASSENGER_ID | Assigned Traveler | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure FTPS_PNR_HOTEL_RES_OUT using ABAP code?
As FTPS_PNR_HOTEL_RES_OUT 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_HOTEL_RES_OUT as there is no data to select.How to access SAP table FTPS_PNR_HOTEL_RES_OUT
Within an ECC or HANA version of SAP you can also view further information about FTPS_PNR_HOTEL_RES_OUT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects