SAP Travel Planning Tables
Are you looking for the right table related to SAP Travel Planning Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Travel Planning (FI-TV-PL) module.
Top 10 tables in Travel Planning
| Table | Description |
|---|---|
| FTPT_IMR_TKT | IMR : Ticket Information |
| TA20RTG_P | Route Segment Provider |
| TA21RH | Region Hierarchy |
| TA20PIH | Hotel Trip Rule |
| TA22EQU | Equipment Types |
| TA20PPT | Assignment Table of Trip Rules for Travel Profiles |
| TA23PAF_ASG | Permissibility of Airline Programs for Corporate Customers |
| TA20PIC | Car Rental Trip Rule |
| TA23WIZZ | Names |
| TA20OFFICE_AS0 | Assignment of Fulfillment Sales Offices |
List of tables in Travel Planning
| Table | Description |
|---|---|
| FTPT_IMR_TKT | IMR : Ticket Information |
| TA20RTG_P | Route Segment Provider |
| TA21RH | Region Hierarchy |
| TA20PIH | Hotel Trip Rule |
| TA22EQU | Equipment Types |
| TA20PPT | Assignment Table of Trip Rules for Travel Profiles |
| TA23PAF_ASG | Permissibility of Airline Programs for Corporate Customers |
| TA20PIC | Car Rental Trip Rule |
| TA23WIZZ | Names |
| TA20OFFICE_AS0 | Assignment of Fulfillment Sales Offices |
| TA23TVTTA_FIND1 | Activity Type Modifier |
| TA21CAR | Rental Car Rate |
| TA23SUBSCRPT_ASG | Logon to External Reservation System per Sales Office |
| TA23TRVCD_FIND | Groupings for Negotiated Car Rental Rates |
| TA20PPZ1 | Message handling (language-dependent) |
| TA21HO1 | Room category (language-dependent) |
| TA23PAF_CONN | Assignment of Airline Programs Corporate Cust. - Route/Class |
| TA20OFFICE | Reservation System-Specific Sales Offices |
| TA21CAZ | Assignment car rental classes - booking specifications |
| TA20PIF | Flight Trip Rule |
| TA20PPI | Assignment Table of Trip Rules for Travel Profiles |
| TA20PPP | Priority of Trip Rules |
| TA20OZ | Resubmission (queue) of sales offices |
| TA21L | IATA Locations |
| TA20PHC | Assignment Table of Hotel Catalog Items for Travel Profiles |
| TA23R | Assign TVTTA - Trip Activity Type |
| TA20PF | Travel Profiles - Methods of Payment |
| TA20BUILDING | Buildings |
| TA23ROUTING1 | Routes for Airfares and Discounts |
| FTPT_VARIANT | Table of Travel Plan Variants |
| FTPT_FLIGHT | Travel Request Item - Flight Service |
| FTPT_A_TRN_PREF | Prearchiving FI-TV: Entries from FTPT_TRAIN_PREF (Temp.) |
| TA23TRVCD_FIND1 | Groupings for Negotiated Car Rental Rates (Language-Dep.) |
| TA23PROT | Log for Sabre Interface |
| PA0474 | HR master record infotype 0474 (train preferences) |
| TA23OS | Field Control for Travel Res. Request Item: Other Services |
| FTPT_A_PNR_PHONE | Prearchiving FI-TV: Entries from FTPT_PNR_PHONE (Temp.) |
| TA20LE1 | Tree Node (Language-Dependent) |
| FTPT_A_OTHER | Prearchiving FI-TV: Entries from FTPT_OTHER (Temp.) |
| FTPT_QT_HOTEL | Quicktrip Travel Request Item - Flight Service |
| TA21RZC | Assignment: Country-Subdividing Region to Location |
| TA20R | Trip activity type - Travel Planning |
| TA23PAF1 | Airline Programs for Corporate Customers |
| TA20PSH | Class Rule for a Trip Rule (Hotel) |
| TA20DB | Access Parameters for Deutsche Bahn via API |
| TA23TRVCD_ASG | Modifier Car Rental Rates |
| FTPT_CAR | Travel Request Item - Car Rental Service |
| PA0473 | HR master record infotype 0473 (rental car preferences) |
| TA20PI | Trip Rule |
| TA23TRVCC_FIND | Payment Method Modifier |
| FTPT_IMR_CAR | IMR - Car Rental |
| FTPT_IMR_HTL | IMR - Hotel |
| FTPT_LOG_GDS | Cluster for GDS Log Data |
| TA23TVGKT_FIND | MCR Modifier |
| TA21RZL | Assignment: Region of Several Countries to Country |
| TA23PAF | Airline Programs for Corporate Customers |
| TA23PIF | Flight Trip Rule (Filter before Availability Query) |
| TA20LT | Current Settings for Travel Planning Control Variants |
| TA20K1 | Reasons (Language-Dependent) |
| FTPT_IMR_FQTV | IMR: Customer Programs |
| FTPT_IMR_FAREDAT | IMR - Price Data Description |
| TA20Q | Define Queues of Sales Offices |
| FTPT_IMR_DETAIL | IMR - Detail Information |
| TA21R1 | Regions (Language-Dependent) |
| TA20OFFICE_TEXT | Sales Offices (Language-Dependent) |
| FTPT_A_SYNCDATA | Prearchiving FI-TV: Entries from FTPT_SYNC_DATA (Temp.) |
| TA20_SWITCH | Global Control Parameters |
| FTPT_FLIGHT_TST | Ticket information |
| FTPT_QT_FLIGHT | Quicktrip Travel Request Item - Flight Service |
| TA23GDS_DECVAL | GDS-Specific Decisions |
| TA23OS1 | Field Control Travel Req. Item: Other Services (Lang.-Depen) |
| FTPT_A_FL_PREF | Prearchiving FI-TV: Entries from FTPT_FLIGHT_PREF (Temp.) |
| TA20C1 | Enterprise-Spec. Travel Service Categories (Language-Dep.) |
| TA23HOTELS | Hotel Data |
| FTPT_IMR_SSRSEG | IMR: Assignment Table Special Serv.Request to Flight Segment |
| TA22RSSY | START: Train Station Synonyms |
| TA23OFFICE_ADR | Sales Office Addresses |
| FTPT_PLAN | General Plan Data |
| TA23RTG1 | Route Segments for Routings for Airfares and Discounts |
| TA20NCR1 | Negotiated Car Rental Rates (Language-Dependent) |
| TA20IH_MAIL | Internal Mail |
| TA22CEXC | RBD Assignment of Airline Exceptions |
| FTPT_A_PNR | Prearchiving FI-TV: Entries from FTPT_PNR (Temp.) |
| TA20CORPID | Company Specific Contract for Negotiated Airfares |
| FTPT_PNR_SSR | Special PNR service requests |
| TA20PPP1 | Priorities of Trip Rules (Language-Dependent) |
| TA23C | Enterprise-Specific F4 Help for IATA Locations |
| TA23BIBE | Parameters for Access to Deutsche Bahn Through BIBE Portal |
| FTPT_REQ_REASON | Reason for Travel Request |
| TA20OFFICE_FIND | Access Parameters per Group ID - Sales Office Determination |
| TA20Q_CAT | Define Queue Categories of Sales Office |
| FTPT_FLIGHT_TSTK | Ticket Information |
| PA0475 | HR master record infotype 0475 (customer programs) |
| TA23PIC | Car Rental Trip Rule (Filter before Availability Query) |
| TA20PVP | Setting for Lowest Fare Availability Search |
| TA21R | Regions |
| TA20PS | Class Rule |
| FTPT_IMR_FAREELM | IMR: Passenger Information for Price Determination |
| TA20NRHS | Discount Agreement for Hotels (Individual Hotel) |
| FTPT_IMR_FSP | IMR: Assignment Table Passengers-Segments-TST |
| TA20REBF | Discount Agreement for Flights |
| TA20SUBSCRPT_ASG | Logon to External Reservation System per Sales Office |
| TA20NF1 | Negotiated flight fares (language-dependent) |
| TA23PF | Payment Method |
| TA22ST | Amadeus: status flight/car rental/hotel |
| TA23HRS | HRS Access Parameters |
| TA20PI1 | Trip Rule (Language-Dependent) |
| TA20LOGGDS | Logical Global Reservation System |
| TA20P1 | Travel Profiles (Language-Dependent) |
| FTPT_HOTEL_PREF | Hotel service preferences of a travel plan |
| FTPT_A_PNR_NAME | Prearchiving FI-TV: Entries from FTPT_PNR_NAME (Temp.) |
| FTPT_PNR_ADDRESS | PNR delivery / billing addresses |
| FTPT_FARE_COMP | Rate components |
| TA21PH | Customer-Specific Hotel Catalog |
| TA23GKT | MCR (Major Customer Rate German Railway) |
| BTS_ERROR_CODES | Error Codes of SABRE/BTS-API Server |
| TA23FILTER_CTRL | Control Parameter (Flight Availability Query) |
| FTPT_A_FL_LEG | Prearchiving FI-TV: Entries from FTPT_FLIGHT_LEG (Temp.) |
| FTPT_QT_ITEM | Quicktrip Travel Service Request Item |
| TA21CA1 | Rental Car Classes (Language-Dependent) |
| FTPT_A_VAR_INFO | Prearchiving FI-TV: Entries from FTPT_VAR_INFO (Temp.) |
| FTPT_A_CAR_PREF | Prearchiving FI-TV: Entries from FTPT_CAR_PREF (Temp.) |
| FTPT_IMR_SSRS | IMR: Information on Special Service Requirements |
| TA20NH | Negotiated hotel rates (corporate nego rates) |
| PA0469 | HR master record for infotype 0469 |
| TA23CT | Amadeus Profile |
| FTPT_A_HTL_PREF | Prearchiving FI-TV: Entries from FTPT_HOTEL_PREF (Temp.) |
| TA20WIZZ | Names |
| FTPT_HOTEL_DATA | Hotel Data |
| TA23PIT | Flight Trip Rule |
| TA23DEC1 | Situations for GDS-Specific Decisions |
| TA20PSC | Class Rule for a Trip Rule (Car Rental) |
| TA20B | Control Variant for Travel Planning |
| STATUSAGENCY | Display the Status of a Travel Plan |
| TA22CE | RBD assignment of airline exceptions |
| TA20RMRK | Company-Specific PNR Elements |
| TA22C | IATA RBD assignment |
| TA20BPR | Provider-Specific Reservation Systems |
| FTPT_IMR_TKTSEG | IMR: Table for Assignment of Ticket to Flight Segment |
| FTPT_IMR | IMR - General Information |
| FTPT_PNR | Elements of passenger name records of travel plan variant |
| FTPT_IMR_SURFACE | IMR - Other Segments of Trip as Flights |
| FTPT_CSX_PROFILE | Relationship SAP Human Resources Number - Amadeua Profile |
| FTPT_A_FARE_COMP | Prearchiving FI-TV: Entries from FTPT_FARE_COMP (Temp.) |
| TA23L_C | Assign Locations to IATA Locations (Car Rental) |
| TA23APIS1 | APIS ( Advanced Passenger Information System ) - sprachabh. |
| FTPT_FLIGHT_PREF | Flight service preferences of a travel plan |
| TA23TVGKT_FIND1 | MCR Modifier (Language Dependent) |
| FTPT_PNR_OSI | Other PNR service information |
| TA20FINALMESSAGE | Strategic Settings for Travel Planning |
| TA20ROUTING | Routes for Airfares and Discounts |
| FTPT_ITEM | Travel Service Request Item |
| TA22RSA1 | START: Train Attributes (Lang.-Dependent) |
| TA23CT1 | Amadeus Profile Text Table |
| TA23XI | Sales Office Determination: Categories with XI Integration |
| TA23A | Payer of Travel Services |
| FTPT_HOTEL | Travel Request Item - Hotel Service |
| TA20OFFICE_FIND1 | Specify Access Parameters per Group ID |
| TA20NEGOF1 | Negotiated Flight Fares (Language-Dependent) |
| TA20LBEZ | Tree Structure (Current Settings for Travel Planning) |
| FTPT_FARE_NOTE | Rate Rules |
| TA23OA1 | Sales Office Activitiy (Language Independent) |
| FTPT_CAR_PREF | Rental car service preferences of a travel plan |
| FTPT_FLIGHT_FCMP | Assignment table: flights <-> rate components |
| FTPT_A_PNR_OSI | Prearchiving FI-TV: Entries from FTPT_PNR_OSI (Temp.) |
| FTPT_IMR_FELMSEG | IMR: Table for Assignment of Ticket to Flight Segment |
| TA20ROUTE | Routes for Airfares and Discounts |
| TA20NF | Negotiated Flight Fares (Corporate Nego Fares) |
| TA23PIFT | Trip Rule for Mandatory Combined Display of Flights/Rail |
| PA0472 | HR master record infotype 0472 (hotel preferences) |
| TA20LOGGDS_TEXT | Logical Global Reservation System |
| TA20PPZ | Message handling: chosen priority with top priority |
| FTPT_VAR_INFO | Info texts for travel plan variants |
| FTPT_FLIGHT_FARE | Assignment table: flights <-> rate components |
| FTPT_A_FL_FCMP | Prearchiving FI-TV: Entries from FTPT_FLIGHT_FCMP (Temp.) |
| TA20HH1 | Maximum Rates for Hotel Stay |
| FTPT_SYNC_DATA | Data Synchronization: SAP - External System |
| TA20WWW | WWW Link Catalog for Information Sources |
| FTPT_PNR_PHONE | PNR telephone references |
| TA23OA | Office activity |
| FTPT_PNR_REMARKS | PNR remarks |
| TA22B | Assignment trip schema - travel plan type |
| TA23PROFILE_SYNC | Assignment Parameters for Preference Synchronization |
| FTPT_QT_ALTERN | Quicktrip Trip Alternative |
| TA22PRFR | Pricing Functionality Restrictions |
| TA20O | Sales offices |
| FTPT_IMR_TRAIN | IMR - Train |
| FTPT_IMR_FLIGHT | IMR - Flight |
| TA23DEC_VAL | Situations for GDS-Specific Decisions |
| TA20R1 | Trip activity type - Travel Planning (language-dependent) |
| FTPT_IMR_FOP | IMR : Information on Payment Method |
| FTPT_REQ_ADVANCE | Travel Request Advance |
| TA20P | Travel profiles |
| TA22RSF1 | START: Error Messages (Language-Dependent) |
| TA23CEXC | RBD assignment of airline exceptions |
| FTPT_PNR_NAME | Name element of PNR |
| FTPT_IMR_FOPSEG | IMR: Assignment Table Payment Method to Flight Segments |
| TA20Q_ASG | Processing Types of Fulfillment Sales Offices |
| FTPT_A_PNR_ADDR | Prearchiving FI-TV: Entries from FTPT_PNR_ADDRESS (Temp.) |
| TA20RTG_R | Booking Classes for Route Segment |
| FTPT_IMR_MANUAL | IMR - Manually Created Segments |
| FTPT_QT_QTRIP | Quicktrip Trip |
| TA23_PAPTF | Additional Airport for Availability Query |
| TA20NHC | Negotiated Hotel Rates |
| STATUSAGENCYT | Display the Status Texts |
| TA23CORPID_ASG | Validity of Enterprise-Specific Airfare Contracts |
| FTPT_OTHER | Travel Reservation Request Item - Other Service |
| FTPT_REQUEST | Travel Plan Requests |
| TA20PS1 | Class Rule (Language-Dependent) |
| TA20NRH | Discount Agreement for Hotel Accommodations |
| TA20PSF | Class Rule for a Trip Rule (Flight) |
| TA20NRF | Discount Agreement for Flights |
| FTPT_A_FARE_NOTE | Prearchiving FI-TV: Entries from FTPT_FARE_NOTE (Temp.) |
| FTPT_IMR_RECLOC | IMR - Booking Rate |
| TA20RTG_G | Geographical Description of a Route Segment |
| FTPT_IMR_NAMES | IMR : Name |
| TA20A | API Server Access Parameters |
| FTPT_FLIGHT_LEG | Leg of flight |
| TA20SWITCH | Global Control Parameters |
| TA20B1 | Control Variants - Travel Planning (Language-Dependent) |
| FTPT_TRAIN | Travel Request Item - Train Service |
| TA21PF | Provider-Specific Customer Programs |
| TA22RSA | START: Train Attributes |
| FTPT_IMR_FQTVSEG | IMR: Assignment Table Customer Programs to Flight Segments |
| FTPT_PLANHISTORY | General Plan Data |
| FTPT_IMR_SEATS | IMR: Seating Information |
| FTPT_REQ_HEAD | Framework Data of Travel Request |
| TA20LE | Tree Node (Current Settings for Travel Planning) |
| TA21CAR1 | Car Rental Rates (Language-Dependent) |
| TA23TVTTA_FIND | Grouping For Eligibility of Activity Types |
| TA20RTG | Route Segments for Routings for Airfares and Discounts |
| FTPT_IMR_SEATSEG | IMR: Table for Assignment of Seats to Flight Segments |
| TA22A | Assignment table expense code - service category |
| TA21H | Hotel Rates |
| FTPT_QT_CAR | Quicktrip Travel Request Item - Flight Service |
| TA20BH | Displayable Hotel Rates of User Groups |
| TA20WIZARD | Strategic Settings for Travel Planning |
| TA21PHC | Hotel Codes of a Catalog Hotel in Reservation System |
| FTPT_IMR_HTL_DIR | IMR - Hotel (Direct Access) |
| TA20C | Enterprise-Specific Travel Service Categories |
| FTPT_HOTEL_COORD | Hotel Coordinates |
| FTPT_SERVICE | General Services |
| TA21REGION | IATA/ATPCO Areas |
| FTPT_REQ_ACCOUNT | Travel Request Cost Assignment |
| TA20SUBSCRPT | Define Access Parameters for Reservation System |
| TA23PIH | Hotel Trip Rule (Filter before Availability Query) |
| TA20CORPID1 | Company Specific Contract for Negotiated Airfares |
| TA20LT1 | Current Settings for Control Variant (Language-Dependent) |
| TA20NC1 | Negotiated rental car rates (language-dependent) |
| TA21L1 | IATA Locations (Language-Dependent) |
| TA20NCR | Negotiated Car Rental Rates |
| TA20NRADD | Additional Info for Negotiated Rates and Discounts |
| TA21PFA | Assignment of Customer Programs to Additional Providers |
| TA21HO | Room category |
| TA20LB | Trees (Current Settings for Travel Planning) |
| TA20NC | Negotiated rental car rates (corporate nego rates) |
| TA21HOZ | Assignment Room Category - Class Rule |
| TA20NHC1 | Negotiated Hotel Rates (Language-Dependent) |
| TA23L_H | Assign Locations to IATA Locations (Hotel) |
| TA20NHS | Negotiated Hotel Rates (Nego Rates) with Catalog Hotel |
| TA21CA | Rental Car Classes |
| TA23DEC_VAL1 | Situations for GDS-Specific Decisions |
| TA20GDS_CODES | Assignment of SAP Codes to GDS Codes |
| TA20LB1 | Trees (Current Settings for Travel Planning, Lang.-Depend.) |
| TA23TRVCC_FIND1 | Payment Method Modifier (Language Dependent) |
| TA20WWW1 | WWW LInk Catalog for Information Sources (Language-Depend.) |
| TA20O1 | Sales offices (language-dependent) |
| TA22RSF | START: Error Messages |
| TA20NREX | Exceptions to Negotiated Rates |
| TA20NEGOF | Negotiated Flight Fares (Corporate Nego Fares) |
| TA21P | Travel Service Providers |
| TA23IGS | Access URLs for the Internet Graphics Server |
| TA21H1 | Hotel Rates (Language-Dependent) |
| TA20BA | Access Parameters of User Groups per Reservation System |
| TA20HH | Maximum Rates for Hotel Stay |
| TA21OA | Office Activity |
| TA20K | Reasons |
| PA0471 | HR master record infotype 0471 (flight preferences) |
| TA23L_F | Assign Locations to IATA Locations (Flight) |
| TA23ROUTE1 | Routes for Airfares and Discounts |
| PA0468 | HR master record for infotype 0468 |
| TA20NH1 | Negotiated hotel rates (language-dependent) |
| FTPT_TM_MEMO | Memo table for Travel Management |
| TA20PST | Class Rule for a Trip Rule (Train) |
| FTPT_TRAIN_PREF | Train service preferences of a travel plan |
| TA23DEC | Situations for GDS-Specific Decisions |
| TA23P_FOID | Travel Service Providers |
| PA0470 | HR master record infotype 0470 (travel profiles) |
| FTPT_QT_BPROFILE | Quicktrip Reservation Profile |
| TA22RSS | START: Train Stations |
| TA20NRC | Discount Agreement for Rental Car Usage |