SAP Travel Expenses Tables
Are you looking for the right table related to SAP Travel Expenses 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 Expenses (FI-TV-COS) module.
Top 10 tables in Travel Expenses
| Table | Description |
|---|---|
| PTRV_PERIO | Period Data of a Trip |
| T702B | Credit Card Clearing Assignment Table |
| T706B6 | Default Values When Difference Values Are Exceeded |
| T706FORM_VAR_TXT | Form variant (language-dependent) |
| T706FORM_BLK_HDL | Form block titles |
| T702_VCF4_D | Assignment of Detail Info. to Trans. Keys of Card Companies |
| T706B5 | Names for Travel Expense Types |
| T702L | Name of Service Provider |
| T706B3 | Travel Expense Type Grouping |
| T702K | Service provider |
List of tables in Travel Expenses
| Table | Description |
|---|---|
| PTRV_PERIO | Period Data of a Trip |
| T702B | Credit Card Clearing Assignment Table |
| T706B6 | Default Values When Difference Values Are Exceeded |
| T706FORM_VAR_TXT | Form variant (language-dependent) |
| T706FORM_BLK_HDL | Form block titles |
| T702_VCF4_D | Assignment of Detail Info. to Trans. Keys of Card Companies |
| T706B5 | Names for Travel Expense Types |
| T702L | Name of Service Provider |
| T706B3 | Travel Expense Type Grouping |
| T702K | Service provider |
| T702A | Employee Grouping for Travel Expense Type |
| T702J | Enterprise-spec.Reimbursement Groups for Meals/Accomm. |
| T702G | Statutory trip types |
| T702_SIC_ATR | Assignment of MCC to Transaction Key of Credit Card Company |
| T702_SIC | List of MCC Codes |
| T702I | Statutory Reimbursement Groups for Meals/Accommodations |
| T706ESS3 | Mapping table for docu in Excel sheet |
| PTRV_WAF_RESTART | Restart File for Mobile Solution with Overlapping Trips |
| T702V | Calc.Guide Lines for Scaling Meals PD/Max.Amounts by Hours |
| T706B | Travel Expense Types |
| PTRV_ARCH_HEAD | Prearchiving FI-TV: Entries from PTRV_HEAD (Temporary) |
| FTPT_A_PLAN | General Plan Data |
| T702_VCF4_ER | Enhanced Data Record Types |
| FTPT_A_CAR | Travel Request Item - Car Rental Service |
| FTPT_A_REQ_CAT | Type of Transport/Accomm. and Est.Cost of Travel Request |
| T702_SIC_T | Description of Merchant Category Code |
| T706F2 | Amount Accumulation Depending on Vehicle Type/Class |
| FTPT_REQ_CAT | Type of Transport/Accomm. and Est.Cost of Travel Request |
| PTRV_A_COMP | Prearchiving: Comparison Calculation Results P.S. |
| PTRV_ARCHIVE | Administrative Table for Archived Trip Data |
| T702Y | Employee Groupings for Travel Management |
| PTRV_A_BEIH_TAG | Prearchiv.: Assignment of Days to Subsidy for Trips Home |
| PTRV_A_FRACTION | Prearchiving FI-TV: Entries from PTRV_FRACTION (Temp.) |
| T706B6_T | Default Values When Difference Values Are Exceeded |
| FTPT_A_REM | PNR remarks |
| FTPT_A_HOTEL | Travel Request Item - Hotel Service |
| T706ESS1 | FI-TV: Customizing Table Intranet Scenario |
| T706B2 | Travel Expense Types: Default Value/Maximum Amounts |
| PTRV_SREC | Trip Statistics - Receipts |
| PTRV_A_BEIH_BEL | Prearchiv.: Assignment of Receipts to Subsidy for Trips Home |
| PTRV_DOC_IT | Transfer Travel -> FI/CO: Lines of TRV interm. document |
| T706S | Trip Schema |
| PTRV_CHANGE | Change to Trip |
| T706_ABWH | Absence Types from Place of Work (PS; Separation Allowance) |
| PTRV_T706Z_DNPR | Field Control Screens |
| T706FORM_VARFLD | Variable fields |
| T702O | Trip country/Trip region/Trip country group |
| FITV_HINZ_WERB_S | Additional Amounts and Income-Related Expenses |
| PTRV_F_CLM_TXT | Columns that may be suppressed in form block (sp) |
| T706_CITYCD_CHG | Replacement/Combination of Community Code Numbers, Date-Dep. |
| PTRV_FILE_EXTEN | Allowed file extensions for trip attachments |
| T706_VAT_POSTING | Data Entry and Posting of VAT Amount per Country of Receipt |
| T706V | Trip Provision: Meals Per-diem/Maximum Amount by Hours |
| FITV_A_HIWE_B | Prearchiv.: Addit. Amts and Inc.-Rel. Expenses for Receipts |
| T706A | Trip Provision Deduction Amount/Percentage |
| PTRV_DOC_TAX | Transfer Travel -> FI/CO: Tax lines of TRV document |
| T702Q | Name: Reimburs.Group for Travel Costs/Add.Flat Rate Types |
| T706H | Trip Provision:Per-diem/Maximum Amount for Meals by Time |
| T702H | Caculation Guide Lines: Meals PD/Max.Amounts Scaled by Time |
| FTPT_A_REQ_REASN | Reason for Travel Request |
| T706_CCOMP | Credit Card Companies |
| T706D | Default Values for Dialog |
| PTRV_RECDETAIL | Participant(s) in Entertainment Receipts |
| PTRV_DOC_HD | Transfer Travel -> FI/CO: Header of TRV int. document |
| T706B4_ALTERN | Travel Expense Type: Alternative Assignment of Wage Types |
| T706W | Names for vehicle classes |
| T706_REQ_CATTEXT | Name for Types of Transp/Accomm. and Est.Cost of Travel Req. |
| PTRV_A_BEIH_WEG | Prearchiv.: Assignmt of Trip Segs to Subsidy for Trips Home |
| T706_SUB_SRV_C_T | Subcodes for Goods and Services |
| T706Z | Single Field Control for Dialog |
| PTRV_SHDR | Trip Statistics - Trip Amounts |
| PTRV_A_SCOM | Pre-Archiving FI-TV: Entries from PTRV_SCOM (Temporary) |
| PTRV_WAF_CONFLCT | Offline Travel Management: Conflict Processing |
| T706P | Date Interval for Miles/Kms Accumulation |
| PTRV_FRACTION | Data for Meals Settlement PS Austria |
| PTRV_SBACKLOG | Trip Statistics - Batch/Backlog Processing |
| PTRV_REASGN_FM | Conversion of FM Data in Trip (e.g. Fiscal Year Change) |
| T706FORM_BLKATTR | Form block attributes |
| PTRV_F_SORTKEY_T | Sort Key for Individual Receipt Block |
| T706M | Input Tax for International Per Diems |
| PTRV_F_FBLK | Form Blocks of the Trip Costs Form |
| PTRV_VERSION | History Table |
| PTRV_ADMIN | Travel Management: Administrative Data for Personnel Numbers |
| PTRV_A_SHDR | Trip Statistics - Trip Amounts |
| T706_COST_CP | Cost Comparison on Trip Level: Maximum Difference |
| PTRV_NOT_CH_TR | Storage of New Data from Temporarily Unchangable Trips |
| PTRV_T706Z_FLDS | Field Names for Field Control |
| T706Z1_TXT | Text table: Individual Field Control for Dialog |
| T706FORM_BLKHDLS | Form block titles |
| T702X | Enterprise-specific Trip Types |
| T706FORM_CLMATTR | Suppressable columns per block |
| T702R | Trip Activity Types |
| T706WWW | HTML Links and File Paths |
| T706_VAT_DEFLT | Country- and Expense Type-Dependent Defaults f. Receipt Data |
| PTRV_REDUCTION | Decision Fields: Change of Statutory Trip Type for Reduction |
| PA0017 | HR master record: Infotype 0017 (Travel Privileges) |
| PTRV_A_COMM_AMT | Pre-Archiving FI-TV: Entries from PTRV_COMM_AMT (Temporary) |
| T706ESS2 | Travel Expenses Customizing for ESS Scenario |
| FTPT_A_PNR_SSR | Special PNR service requests |
| T706FORM_FIXTXTS | Fixed texts (language-dependent) |
| PTRV_PRODUCT | Product customizing for Spend traking relevance |
| PTRV_F_COLDEP | Display Forms for Texts |
| PTRV_SCOS | Trip Statistics - Cost Assignment |
| FTPT_A_FL_TSTK | Ticket information |
| PTRV_F_SORTKEY | Sort Key for Individual Receipt Block |
| T706F | Trip Provision: Flat Rates for Travel Costs |
| PTRV_RPRPOSTD | Log of Posting Program RPRPOSTD |
| PTRV_HEAD | General Trip Data |
| PTRV_BEIH_BEL | Assignment of Receipts to a Subsidy for Trips Home |
| T702C | Name for Employee Grouping for Travel Expense Type |
| PTRV_RECPRODUCT | Products for Spend tracking relevance |
| T706_CONSTTEXT | Names of Accounting Constants for Travel Expenses |
| PTRV_CCC_RUNS | Assign Personnel Number to Credit Card Clearing Run |
| PTRV_COMM_ITM | Header Data: Transfer to FM When Trip Saved |
| T706Y | Names for Employee Groupings for Travel Management |
| PTRV_ROT_AWKEY | Assignment of Trip Results to Posting Doc. Number and Line |
| FTPT_A_REQ_ADV | Travel Request Advance |
| T706K | Initial Account Assignment for FI |
| PTRV_DOC_MESS | Transfer Travel -> FI/CO: CO Replacements of TRV Receipt |
| PTRV_CHAIN_MPD | Chain of Multiple Trips on One Day |
| PTRV_A_CHANGE | Pre-Archiving FI-TV: Entries from PTRV_CHANGE (Temporary) |
| T706_CITY_CD_D | Definition: City Codes / Community Code No., Date-Dependent |
| T706T_ABWH | Texts for Absence Types (PS Separation Allowance) |
| T706FORM_FIXTXT | Fixed texts |
| FTPT_A_REQUEST | Travel Plan Requests |
| PTRV_A_SREC | Trip Statistics - Receipts |
| PTRV_ARC_PEVST | Archived Posting Run Data |
| T706G | Names for statutory trip types |
| T706_DEFAULTTEXT | Names of Reference Texts for Entering Trips |
| T706_VAT_FLDS | Country-Dependent Field Control for Receipt Data |
| PTRV_A_RECPROD | Pre-Archiving FI-TV: Entries from PTRV_RECPRODUCT (Temp.) |
| T706_COST_CP_R_T | Cost Comparison at Trip Level: Default Values |
| PTRV_BEIH_WEG | Assignment of Trip Segments to a Subsidy for Trips Home |
| PTRV_F_COLDEPS | Display Formats for Texts (Language-Dependent) |
| T706F1 | Cumulation Procedure Dependent on Vehicle Type/Class |
| FITV_MEAL_ACCOM | Additional Amounts for Meals in Accommodations Receipts |
| T702E | Vehicle Types |
| T706L | Assignment of Trip Country - Country Group - Region |
| T706_SRV_CODE_T | Country-Dependent Field Control for Receipt Data |
| T706_SUB_SRV_C | Subcodes for Goods and Services |
| T702_BKZ | Country and Industry Specific Indicator (Public Sector) |
| T706J | Name for enterprise-specific reimburs.group for meals/acc. |
| PTRV_DELETE_LOG | Log Table for Deleted Trips |
| T706FORM_FLDS | Information in fixed positions |
| FTPT_A_PNR_REM | PNR remarks |
| T702P | Reimbursement Groups for Travel Costs/Add.Flat Rate Types |
| PTRV_A_GLOTRANSP | Reimbursement Amounts for Transport |
| PTRV_A_SCOS | Trip Statistics - Cost Assignment |
| PTRV_A_BEIHILFE | Prearchiving: Subsidies for Trips Home for Entire SA |
| FTPT_A_REQ_ACCNT | Travel Request Cost Assignment |
| PTRV_A_SADD | Trip Statistics - Add. Receipt Data |
| PTRV_RAL_TP_LOG | Read Access Logging for TP_LOG transaction |
| PTRV_F_CLM | Columns for Which Suppression in Form Block is Allowed |
| T706I | Name for statutory reimbursement group for meals/accomm. |
| T706S_RECEIPT | Trip Schemas: Assignment of Travel Expense Types |
| FTPT_A_REQ_HEAD | Prearchiving FI-TV: Entries from FTPT_REQ_HEAD (Temporary) |
| PTRV_SADD | Trip Statistics - Add. Receipt Data |
| FTPT_A_FLIGHT | Travel Request Item - Flight Service |
| FTPT_A_SSR | Special PNR service requests |
| T706R | Names for trip activity types |
| PTRV_USERPREFS | User Profiles in Travel Management |
| T706_CITY_CD_D_2 | Definition: City Codes / Community Code No., Date-Dependent |
| PTRV_ARCH_PERIO | Prearchiving FI-TV: Entries from PTRV_PERIO (Temporary) |
| PTRV_COMP | Comparison Calculation Results PS |
| T706U | Trip Provision: Per Diem for Accommodations |
| T702W | Vehicle Classes |
| T706T | Names for trip schema |
| FTPT_A_VARIANT | Table of Travel Plan Variants |
| PTRV_TRIP_CHAIN | Table of all Trip Destinations f. Processing Recurring Dest. |
| T706E | Names for vehicle types |
| FITV_A_HIWE_S | Prearchiving: Additional Amounts and Income-Related Expenses |
| PTRV_BTRGSUM | Table for Treatment for Amount Accumulation |
| PTRV_ARC_AWREFS | Reference Document Numbers of Archived Posting Runs |
| PTRV_ME_CCC_RUN | Assign Personnel Number to Credit Card Clearing Run |
| FITV_NOT_CH_TR | Key Fields of Temp. Non-Changeable Trips/Duty Allocation |
| T706C | Names for Travel Expense Types |
| PTRV_COMM_AMT | Detail Data: Transfer to FM When Trip Saved |
| PTRV_A_RECDETAIL | Pre-Archiving FI-TV: Entries from PTRV_REC_DETAIL (Temp.) |
| T706FORM_BCKGRND | Form background |
| T706_LGART | Wage Type Assignmt Table for Clearing Add.Amts/Inc.Rel Exp. |
| PTRV_A_VERSION | Pre-Archiving FI-TV: Entries from PTRV_VERSION (Temporary) |
| T706Z1 | Single Field Control for Dialog |
| PTRV_TRIP_DELETE | Trips Deleted in SAP System for Offline Travel Manager |
| T706_COST_CP_R | Cost Comparison at Trip Level: Default Values |
| T706_TEXTNAMES | Names of Reference Texts for Entering Trips |
| T702_ACCT_TYPE | AMEX: Account Types |
| T706_REQ_CAT | Types of Transport/Accomm. and Est.Cost of Travel Request |
| PTRV_COUNT | Number of function calls in posting run management |
| PTRV_BEIH_TAG | Assignment of Days to a Subsidy for Trips Home |
| T706Q | Names for period indicator for miles/kms accumulation |
| PTRV_T706Z_DNPRT | Field Control Screens |
| FTPT_A_ITEM | Travel Service Request Item |
| PTRV_SCOM | Travel Statistic - Request/Plan/Settlement Cost Comparison |
| T706_CONST | PA parameters: Travel Management |
| T706B4 | Travel Expense Types: Assignment of Wage Types |
| T702_ACCTTYPET | Description of American Express Account Types |
| T702_BEREI_REL | Assignment of Trip Types Enterprise-Specific (PS AT) |
| T706_CCOMP_TXT | Name of Credit Card Company |
| PTRV_WAFGUID | Logging for Synchronization GUID (DUPRECS) |
| T706_SRV_CODE | VAT Refund Codes |
| FITV_A_MEAL_ACC | Prearchiv.: Additional Amounts for Meals in Accomm. Receipts |
| T706FORM_VAR | Form variant |
| T706_CITY_CD_46C | Table for Specifying the City Code/Community Code Number |
| T706_CITY_CODE | Table for Specifying the City Code/Community Code Number |
| PTRV_BEIHILFE | Subsidies for Trips Home for Entire Separation Allowance |
| T702N | Trip Provision Variants |
| PTRV_CCC | Error Receipts for Credit Card Clearing |
| PTRV_TRIPCHN_46C | Table of all Trip Destinations f. Processing Recurring Dest. |
| FITV_HINZ_WERB_B | Additional Amounts and Income-Related Expenses for Receipts |
| FTPT_A_TRAIN | Travel Request Item - Train Service |
| PTRV_VATDETAIL | Supplier Data for VAT Refund in Travel Management |
| T706X | Names for enterprise-specific trip types |
| T706WWW_TXT | Text Table HTML Links and File Paths |
| PTRV_A_TRIPCHAIN | Pre-Archiving FI-TV: Entries from PTRV_TRIP_CHAIN (Temp.) |
| PTRV_F_FBLK_TXT | Form Blocks of the Trip Costs Form |
| T706O | Names for Trip Country/Trip Country Group/Trip Region |
| PTRV_A_VATDETAIL | Pre-Archiving FI-TV: Entries from PTRV_VAT_DETAIL (Temp.) |
| PTRV_CANCEL_KEY | Link Between Reversed Document No. and Reversal Document No. |
| T706N | Names for trip provision variants |
| PTRV_A_CHAIN_MPD | Prearchiving FI-TV: Entries from PTRV_CHAIN_MPD (Temp.) |
| T706B1 | Travel Expense Types |
| PTRV_KMSUM | Table for Use of Miles/Kms Accumulation |
| T706FORM_VARFLDS | Variable fields (language-dependent) |
| PTRV_A_COMM_ITM | Pre-Archiving FI-TV: Entries from PTRV_COMM_ITM (Temporary) |
| PTRV_A_SBACKLOG | Trip Statistics - Batch/Backlog Processing |
| PTRV_TC_UPDATE | Credit Card Conversion as of Release 6.04 (SAP Note 2160484) |