SAP Travel Management in FI (FI-TV) Tables Full list

Here is a list of important 428 SAP standard tables used with SAP Travel Management in FI component (SAP FI-TV) coming under SAP FI (Financial Accounting) Module. You will get more technical details of these SAP FI-TV tables by clicking on the respective table name link.

Error Codes of SABRE/BTS-API Server

Additional Amounts and Income-Related Expenses for Receipts

Additional Amounts and Income-Related Expenses

Additional Amounts for Meals in Accommodations Receipts

Rejected Trips

Travel Request Item – Car Rental Service

Rental car service preferences of a travel plan

Relationship SAP Human Resources Number – Amadeua Profile

Rate components

Rate Rules

Travel Request Item – Flight Service

Assignment table: flights <-> rate components

Leg of flight

Flight service preferences of a travel plan

Ticket Information

Travel Request Item – Hotel Service

Hotel Coordinates

Hotel Data

Hotel service preferences of a travel plan

IMR – General Information

IMR – Car Rental

IMR – Detail Information

IMR – Price Data Description

IMR: Passenger Information for Price Determination

IMR: Table for Assignment of Ticket to Flight Segment

IMR – Flight

IMR : Information on Payment Method

IMR: Assignment Table Payment Method to Flight Segments

IMR: Customer Programs

IMR: Assignment Table Customer Programs to Flight Segments

IMR: Assignment Table Passengers-Segments-TST

IMR – Hotel

IMR – Hotel (Direct Access)

IMR – Manually Created Segments

IMR : Name

IMR – Booking Rate

IMR: Seating Information

IMR: Table for Assignment of Seats to Flight Segments

IMR: Information on Special Service Requirements

IMR: Assignment Table Special Serv.Request to Flight Segment

IMR – Other Segments of Trip as Flights

IMR : Ticket Information

IMR: Table for Assignment of Ticket to Flight Segment

IMR – Train

Travel Service Request Item

Cluster for GDS Log Data

Travel Reservation Request Item – Other Service

General Plan Data

General Plan Data

Elements of passenger name records of travel plan variant

PNR delivery / billing addresses

Name element of PNR

Other PNR service information

PNR telephone references

PNR remarks

Special PNR service requests

Quicktrip Trip Alternative

Quicktrip Reservation Profile

Quicktrip Travel Request Item – Flight Service

Quicktrip Travel Request Item – Flight Service

Quicktrip Travel Request Item – Flight Service

Quicktrip Travel Service Request Item

Quicktrip Trip

Travel Plan Requests

Travel Request Cost Assignment

Travel Request Advance

Framework Data of Travel Request

Reason for Travel Request

General Services

Data Synchronization: SAP – External System

Memo table for Travel Management

Travel Request Item – Train Service

Train service preferences of a travel plan

Table of Travel Plan Variants

Info texts for travel plan variants

HR master record: Infotype 0017 (Travel Privileges)

HR master record for infotype 0468

HR master record for infotype 0469

HR master record infotype 0470 (travel profiles)

HR master record infotype 0471 (flight preferences)

HR master record infotype 0472 (hotel preferences)

HR master record infotype 0473 (rental car preferences)

HR master record infotype 0474 (train preferences)

HR master record infotype 0475 (customer programs)

Travel Management: Administrative Data for Personnel Numbers

Administrative Table for Archived Trip Data

Prearchiving FI-TV: Entries from PTRV_HEAD (Temporary)

Prearchiving FI-TV: Entries from PTRV_PERIO (Temporary)

Subsidies for Trips Home for Entire Separation Allowance

Assignment of Receipts to a Subsidy for Trips Home

Assignment of Days to a Subsidy for Trips Home

Assignment of Trip Segments to a Subsidy for Trips Home

Table for Treatment of Accumulation of Amounts

Error Receipts for Credit Card Clearing

Assign Personnel Number to Credit Card Clearing Run

Detail Data: Transfer to FM When Trip Saved

Header Data: Transfer to FM When Trip Saved

Comparison Calculation Results PS

Number of function calls in posting run management

Transfer Travel -> FI/CO: Lines of TRV interm. document

Transfer Travel -> FI/CO: Tax lines of TRV document

Columns for Which Suppression in Form Block is Allowed

Columns that may be suppressed in form block (sp)

Display Forms for Texts

Display Formats for Texts (Language-Dependent)

Form Blocks of the Trip Costs Form

Form Blocks of the Trip Costs Form

Sort Key for Individual Receipt Block

Sort Key for Individual Receipt Block

General Trip Data

Table for Use of Miles/Kms Accumulation

Assign Personnel Number to Credit Card Clearing Run

Storage of New Data from Temporarily Unchangable Trips

Period Data of a Trip

Personalization at Employee Level

Conversion of FM Data in Trip (e.g. Fiscal Year Change)

Decision Fields: Change of Statutory Trip Type for Reduction

Assignment of Trip Results to Posting Doc. Number and Line

Log of Posting Program RPRPOSTD

Trip Statistics – Add. Receipt Data

Trip Statistics – Batch/Backlog Processing

Trip Statistics – Cost Assignment

Trip Statistics – Trip Amounts

Trip Statistics – Receipts

Field Control Screens

Field Control Screens

Field Names for Field Control

Table of all Trip Destinations f. Processing Recurring Dest.

Table of all Trip Destinations f. Processing Recurring Dest.

Trips Deleted in SAP System for Offline Travel Manager

Supplier Data for VAT Refund in Travel Management

Logging for Synchronization GUID (DUPRECS)

Offline Travel Management: Conflict Processing

Restart File for Mobile Solution with Overlapping Trips

Display the Status of a Travel Plan

Display the Status Texts

Employee Grouping for Travel Expense Type

Credit Card Clearing Assignment Table

Name for Employee Grouping for Travel Expense Type

Vehicle Types

Statutory trip types

Caculation Guide Lines: Meals PD/Max.Amounts Scaled by Time

Statutory Reimbursement Groups for Meals/Accommodations

Enterprise-spec.Reimbursement Groups for Meals/Accomm.

Service provider

Name of Service Provider

Trip Provision Variants

Trip country/Trip region/Trip country group

Reimbursement Groups for Travel Costs/Add.Flat Rate Types

Name: Reimburs.Group for Travel Costs/Add.Flat Rate Types

Trip Activity Types

Calc.Guide Lines for Scaling Meals PD/Max.Amounts by Hours

Vehicle Classes

Enterprise-specific Trip Types

Employee Groupings for Travel Management

Assignment of Trip Types Enterprise-Specific (PS AT)

Country and Industry Specific Indicator (Public Sector)

Trip Provision Deduction Amount/Percentage

Travel Expense Types

Travel Expense Types

Travel Expense Types: Default Value/Maximum Amounts

Travel Expense Type Grouping

Travel Expense Types: Assignment of Wage Types

Travel Expense Type: Alternative Assignment of Wage Types

Names for Travel Expense Types

Names for Travel Expense Types

Default Values for Dialog

Names for vehicle types

FI-TV: Customizing Table Intranet Scenario

Travel Expenses Customizing for ESS Scenario

Mapping table for docu in Excel sheet

Trip Provision: Flat Rates for Travel Costs

Cumulation Procedure Dependent on Vehicle Type/Class

Accumulation of Amounts Depending on Vehicle Type/Class

Form background

Form block attributes

Form block titles

Form block titles

Suppressable columns per block

Fixed texts

Fixed texts (language-dependent)

Information in fixed positions

Form variant

Variable fields

Variable fields (language-dependent)

Form variant (language-dependent)

Names for statutory trip types

Trip Provision:Per-diem/Maximum Amount for Meals by Time

Name for statutory reimbursement group for meals/accomm.

Name for enterprise-specific reimburs.group for meals/acc.

Initial Account Assignment for FI

Assignment of Trip Country – Country Group – Region

Input Tax for International Per Diems

Names for trip provision variants

Names for Trip Country/Trip Country Group/Trip Region

Date Interval for Miles/Kms Accumulation

Names for period indicator for miles/kms accumulation

Names for trip activity types

Trip Schema

Names for trip schema

Texts for Absence Types (PS Separation Allowance)

Trip Provision: Per Diem for Accommodations

Trip Provision: Meals Per-diem/Maximum Amount by Hours

Names for vehicle classes

HTML Links and File Paths

Text Table HTML Links and File Paths

Names for enterprise-specific trip types

Names for Employee Groupings for Travel Management

Single Field Control for Dialog

Single Field Control for Dialog

Text table: Individual Field Control for Dialog

Absence Types from Place of Work (PS; Separation Allowance)

Credit Card Companies

Name of Credit Card Company

Replacement/Combination of Community Code Numbers, Date-Dep.

Table for Specifying the City Code/Community Code Number

Definition: City Codes / Community Code No, Date-Dependent

Definition: City Codes / Community Code No, Date-Dependent

Table for Specifying the City Code/Community Code Number

PA parameters: Travel Management

Names of Accounting Constants for Travel Expenses

Names of Reference Texts for Entering Trips

Wage Type Assignmt Table for Clearing Add.Amts/Inc.Rel Exp.

VAT Refund Codes

Country-Dependent Field Control for Receipt Data

Subcodes for Goods and Services

Subcodes for Goods and Services

Names of Reference Texts for Entering Trips

Country- and Expense Type-Dependent Defaults f. Receipt Data

Country-Dependent Field Control for Receipt Data

Data Entry and Posting of VAT Amount per Country of Receipt

Documentation for a Web Application

Documentation for a Web Application

API Server Access Parameters

Control Variant for Travel Planning

Control Variants – Travel Planning (Language-Dependent)

Access Parameters of User Groups per Reservation System

Displayable Hotel Rates of User Groups

Provider-Specific Reservation Systems

Buildings

Enterprise-Specific Travel Service Categories

Enterprise-Spec. Travel Service Categories (Language-Dep.)

Company Specific Contract for Negotiated Airfares

Company Specific Contract for Negotiated Airfares

Access Parameters for Deutsche Bahn via API

Strategic Settings for Travel Planning

Assignment of SAP Codes to GDS Codes

Maximum Rates for Hotel Stay

Maximum Rates for Hotel Stay

Internal Mail

Reasons

Reasons (Language-Dependent)

Trees (Current Settings for Travel Planning)

Trees (Current Settings for Travel Planning, Lang.-Depend.)

Tree Structure (Current Settings for Travel Planning)

Tree Node (Language-Dependent)

Logical Global Reservation System

Logical Global Reservation System

Current Settings for Travel Planning Control Variants

Current Settings for Control Variant (Language-Dependent)

Negotiated rental car rates (corporate nego rates)

Negotiated rental car rates (language-dependent)

Negotiated Car Rental Rates

Negotiated Car Rental Rates (Language-Dependent)

Negotiated Flight Fares (Corporate Nego Fares)

Negotiated Flight Fares (Language-Dependent)

Negotiated Flight Fares (Corporate Nego Fares)

Negotiated flight fares (language-dependent)

Negotiated hotel rates (corporate nego rates)

Negotiated hotel rates (language-dependent)

Negotiated Hotel Rates

Negotiated Hotel Rates (Language-Dependent)

Negotiated Hotel Rates (Nego Rates) with Catalog Hotel

Additional Info for Negotiated Rates and Discounts

Discount Agreement for Rental Car Usage

Exceptions to Negotiated Rates

Discount Agreement for Flights

Discount Agreement for Hotel Accommodations

Discount Agreement for Hotels (Individual Hotel)

Sales offices

Sales offices (language-dependent)

Reservation System-Specific Sales Offices

Assignment of Fulfillment Sales Offices

Access Parameters per Group ID – Sales Office Determination

Specify Access Parameters per Group ID

Sales Offices (Language-Dependent)

Resubmission (queue) of sales offices

Travel profiles

Travel Profiles (Language-Dependent)

Travel Profiles – Methods of Payment

Assignment Table of Hotel Catalog Items for Travel Profiles

Trip Rule

Trip Rule (Language-Dependent)

Car Rental Trip Rule

Flight Trip Rule

Hotel Trip Rule

Assignment Table of Trip Rules for Travel Profiles

Priority of Trip Rules

Priorities of Trip Rules (Language-Dependent)

Assignment Table of Trip Rules for Travel Profiles

Message handling: chosen priority with top priority

Message handling (language-dependent)

Class Rule

Class Rule (Language-Dependent)

Class Rule for a Trip Rule (Car Rental)

Class Rule for a Trip Rule (Flight)

Class Rule for a Trip Rule (Hotel)

Class Rule for a Trip Rule (Train)

Setting for Lowest Fare Availability Search

Define Queues of Sales Offices

Processing Types of Fulfillment Sales Offices

Define Queue Categories of Sales Office

Trip activity type – Travel Planning

Trip activity type – Travel Planning (language-dependent)

Discount Agreement for Flights

Company-Specific PNR Elements

Routes for Airfares and Discounts

Routes for Airfares and Discounts

Route Segments for Routings for Airfares and Discounts

Geographical Description of a Route Segment

Route Segment Provider

Booking Classes for Route Segment

Define Access Parameters for Reservation System

Logon to External Reservation System per Sales Office

Global Control Parameters

Strategic Settings for Travel Planning


WWW Link Catalog for Information Sources

WWW LInk Catalog for Information Sources (Language-Depend.)

Global Control Parameters

Rental Car Classes

Rental Car Classes (Language-Dependent)

Rental Car Rate

Car Rental Rates (Language-Dependent)

Assignment car rental classes – booking specifications

Hotel Rates

Hotel Rates (Language-Dependent)

Room category

Room category (language-dependent)

Assignment Room Category – Class Rule

IATA Locations

IATA Locations (Language-Dependent)

Office Activity

Travel Service Providers

Provider-Specific Customer Programs

Assignment of Customer Programs to Additional Providers

Customer-Specific Hotel Catalog

Regions

Regions (Language-Dependent)

IATA/ATPCO Areas

Region Hierarchy

Assignment: Country-Subdividing Region to Location

Assignment: Region of Several Countries to Country

Assignment table expense code – service category

Assignment trip schema – travel plan type

IATA RBD assignment

RBD assignment of airline exceptions

RBD Assignment of Airline Exceptions

Equipment Types

Pricing Functionality Restrictions

START: Train Attributes

START: Train Attributes (Lang.-Dependent)

START: Error Messages

START: Error Messages (Language-Dependent)

START: Train Stations

START: Train Station Synonyms

Amadeus: status flight/car rental/hotel

Payer of Travel Services

Predefined Addresses in Travel Management

Name of Predefined Addresses in Travel Management

Categories of Predefined Addresses

Names of Categories of Predefined Addresses

Parameters for Access to Deutsche Bahn Through BIBE Portal

Enterprise-Specific F4 Help for IATA Locations

RBD assignment of airline exceptions

Validity of Enterprise-Specific Airfare Contracts

Amadeus Profile

Amadeus Profile Text Table

Situations for GDS-Specific Decisions

Situations for GDS-Specific Decisions

Situations for GDS-Specific Decisions

Situations for GDS-Specific Decisions

Access Parameters for External Content of Front End

Control Parameter (Flight Availability Query)

GDS-Specific Decisions

MCR (Major Customer Rate German Railway)

Hotel Data

HRS Access Parameters

Access URLs for the Internet Graphics Server

Assign Locations to IATA Locations (Car Rental)

Assign Locations to IATA Locations (Flight)

Assign Locations to IATA Locations (Hotel)

Office activity

Sales Office Activitiy (Language Independent)

Sales Office Addresses

Field Control for Travel Res. Request Item: Other Services

Field Control Travel Req. Item: Other Services (Lang.-Depen)

Airline Programs for Corporate Customers

Airline Programs for Corporate Customers

Permissibility of Airline Programs for Corporate Customers

Assignment of Airline Programs Corporate Cust. – Route/Class

Payment Method

Car Rental Trip Rule (Filter before Availability Query)

Flight Trip Rule (Filter before Availability Query)

Hotel Trip Rule (Filter before Availability Query)

Flight Trip Rule

Assignment Parameters for Preference Synchronization

Log for Sabre Interface

Travel Service Providers

Assign TVTTA – Trip Activity Type

Routes for Airfares and Discounts

Routes for Airfares and Discounts

Route Segments for Routings for Airfares and Discounts

Logon to External Reservation System per Sales Office

Payment Method Modifier

Payment Method Modifier (Language Dependent)

Modifier Car Rental Rates

Groupings for Negotiated Car Rental Rates

Groupings for Negotiated Car Rental Rates (Language-Dep.)

MCR Modifier

MCR Modifier (Language Dependent)

Grouping For Eligibility of Activity Types

Activity Type Modifier


Sales Office Determination: Categories with XI Integration