1. SAP Tutorial
  2. FI Module

TA23HOTELS SAP table for – Hotel Data

Here we would like to draw your attention to TA23HOTELS table in SAP. As we know it is being mainly used with the SAP FI-TV (Travel Management in FI) component which is coming under FI module (Financial Accounting). TA23HOTELS is a SAP standard transp table used for storing Hotel Data related data in SAP. It comes under the package PTRP_ADDON.

SAP TA23HOTELS table

Table TA23HOTELS technical data

TableTA23HOTELS
Data storingHotel Data
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP_ADDON
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-HRGXX
Table CategoryTRANSP

SAP TA23HOTELS Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in TA23HOTELS table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GDS : Reservation System
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • CHAIN : Hotel Chain
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • LOCATION : Hotel Location
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • PROPERTY : Hotel Code (Key for an Individual Hotel)
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Travel Web Interface: Geocoding
  • LATITUDE : Geo location latitude
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • LONGITUDE : Geo location longitude
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • .INCLUDE : Travel Web Interface: Addresses
  • COUNTRY : Country Key
    Its data type is CHAR (Character String) with field length 3
  • REGION : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • CITY : City
    Its data type is CHAR (Character String) with field length 40
  • POST_CODE : City postal code
    Its data type is CHAR (Character String) with field length 10
  • STREET : Street
    Its data type is CHAR (Character String) with field length 60
  • HOUSE_NUM : House Number
    Its data type is CHAR (Character String) with field length 10
  • NAME : Name of Hotel
    Its data type is CHAR (Character String) with field length 40
  • NAME_UL : Name of Hotel
    Its data type is CHAR (Character String) with field length 40
  • PHONE : Telephone Number
    Its data type is CHAR (Character String) with field length 40
  • FAX : Fax Number
    Its data type is CHAR (Character String) with field length 40
  • URL : URL (Uniform Resource Locator) of Information Source
    Its data type is CHAR (Character String) with field length 255

    • TA23HOTELS related tables

    • TA23PAF1 : Airline Programs for Corporate Customers
    • TA23GKT : MCR (Major Customer Rate German Railway)
    • TA23OS1 : Field Control Travel Req. Item: Other Services (Lang.-Depen)
    • TA23OA1 : Sales Office Activitiy (Language Independent)
    • TA23TVTTA_FIND : Grouping For Eligibility of Activity Types
    • TA23TVTTA_FIND1 : Activity Type Modifier
    • TA23OFFICE_ADR : Sales Office Addresses
    • TA23PIF : Flight Trip Rule (Filter before Availability Query)
    • TA23TRVCD_ASG : Modifier Car Rental Rates
    • TA23PIH : Hotel Trip Rule (Filter before Availability Query)
    • TA23TRVCD_FIND1 : Groupings for Negotiated Car Rental Rates (Language-Dep.)
    • TA23PROFILE_SYNC : Assignment Parameters for Preference Synchronization
    • TA23ROUTING1 : Routes for Airfares and Discounts
    • TA23WIZZ : Names
    • TA23L_F : Assign Locations to IATA Locations (Flight)
    • TA23TVGKT_FIND : MCR Modifier
    • TA23PAF_CONN : Assignment of Airline Programs Corporate Cust. – Route/Class
    • TA23CT1 : Amadeus Profile Text Table
    • TA23DEC : Situations for GDS-Specific Decisions
    • TA23OA : Office activity

    Related References

    Related Tutorials

    FTPT_HOTEL_DATA SAP table for – Hotel Data

    FTPT_HOTEL_DATA table in SAP FI (Travel Management in FI) module. This table is used for storing data of Hotel Data....

    TA21PHC SAP table for – Hotel Codes of a Catalog Hotel in Reservation System

    TA21PHC table in SAP FI (Travel Management in FI) module. This table is used for storing data of Hotel Codes...

    TA20NHS SAP table for – Negotiated Hotel Rates (Nego Rates) with Catalog Hotel

    TA20NHS table in SAP FI (Travel Management in FI) module. This table is used for storing data of Negotiated Hotel...

    TA21PH SAP table for – Customer-Specific Hotel Catalog

    TA21PH table in SAP FI (Travel Management in FI) module. This table is used for storing data of Customer-Specific Hotel...

    FTPT_HOTEL_COORD SAP table for – Hotel Coordinates

    FTPT_HOTEL_COORD table in SAP FI (Travel Management in FI) module. This table is used for storing data of Hotel Coordinates....

    TA20HH1 SAP table for – Maximum Rates for Hotel Stay

    TA20HH1 table in SAP FI (Travel Management in FI) module. This table is used for storing data of Maximum Rates...

    TA20NHC SAP table for – Negotiated Hotel Rates

    TA20NHC table in SAP FI (Travel Management in FI) module. This table is used for storing data of Negotiated Hotel...

    «
    »