SAP Transaction Management Tables
Are you looking for the right table related to SAP Transaction Management 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 Transaction Management (FIN-FSCM-TRM-TM-TR) module.
Top 10 tables in Transaction Management
| Table | Description |
|---|---|
| THXET_ITEM_SC | Effectiveness Test: Results per HItem & HInst. for Scenarios |
| THXEC_CRIT_TYP_T | Effectiveness Test Critical Term Type |
| FTR_TIER_DEF_T | Description of Rank |
| THXET_ITEM_BP | Effectiveness Test: Results per HItem & HInstr. |
| VTB_ASGN_RELAT | FTR Assignment Management: Assignment Object |
| THXT_GROUP_CUSTT | Text Customizing for Hedge Relationship Groupings |
| TPM_SECACC_GRD2 | Assign Transaction: Sec. Acct Position Lock |
| THXT_MD_ACC_KF | Market Data: Hedge Accounting Key Figures |
| ATALRT | Treasury: Alert Category Assignment |
| TRIAT | Treasury: Int.Rate Adjust. - Registration and Int.Rate Adj. |
List of tables in Transaction Management
| Table | Description |
|---|---|
| THXET_ITEM_SC | Effectiveness Test: Results per HItem & HInst. for Scenarios |
| THXEC_CRIT_TYP_T | Effectiveness Test Critical Term Type |
| FTR_TIER_DEF_T | Description of Rank |
| THXET_ITEM_BP | Effectiveness Test: Results per HItem & HInstr. |
| VTB_ASGN_RELAT | FTR Assignment Management: Assignment Object |
| THXT_GROUP_CUSTT | Text Customizing for Hedge Relationship Groupings |
| TPM_SECACC_GRD2 | Assign Transaction: Sec. Acct Position Lock |
| THXT_MD_ACC_KF | Market Data: Hedge Accounting Key Figures |
| ATALRT | Treasury: Alert Category Assignment |
| TRIAT | Treasury: Int.Rate Adjust. - Registration and Int.Rate Adj. |
| THXT_HINST | Hedge Instrument DB Table |
| VTBAT_PROCESS_TX | Transaction Processes |
| THXT_HR_TESTPLAN | Hedging - Effectivity Test Plan |
| TIDX_FLOW_CAT | Treasury: Flow Categories for Price Indexes |
| THXET_MEAS_HEAD | Effectiveness Test Results |
| VTBMARGIN | Int. FX: Rate Markups or Markdowns per Currency Pair |
| THXT_MD_HEADER | market data: header information |
| THXC_FLOWTYPE | Treasury: Update types based on a Product Type |
| THXEC_EFFCONDY_T | Effectiveness Condition Type Text Table |
| THXT_HR_TRANS | Treasury: Hedging Relationship Transactions |
| THXETS_HDG_CCT | Hedge Effectiveness: Current value calculation category |
| THXTS_HDG_SCEN | Hedge Relationship scenerio |
| FTRT_FIX_DEF | (FX Rate) Fixing Reference |
| THXET_MEAS_ITEMD | Effectiveness Test: Detailed Results per Deal & Hyp. Deri. |
| THXT_HR_FLOWS | Treasury: Hedging Relationship Flows |
| TIDX_INDEX_DFLOW | Relation Between the Indexes and the Distribution Flow Type |
| THXEC_EFF_TMET | Effectiveness Test Method Definition |
| THXT_HITEM | Hedge Item DB table |
| TCHT_HD_OPTION | SFGDT FGET Option Structure |
| THXT_MD_PV | market data present value |
| VTBMDFIELDS | Decide which fields are copied into mirror transaction |
| TIDX_PRICE_INDEX | Price Index Main Entity |
| VTBAT_PROCESS | Transaction Processes |
| FTRT_CFI_ATTR_T | CFI Attributes Per Group Text |
| FTRT_CFI_GRP | Define CFI Code Groups |
| TRCPAT | TR: Commodity Price Adjustm.-Regist. and Fixing (obsolete) |
| ATARCHIVE00 | Archiving: Minimum retention period per company code |
| TPM_SECACC_GUARD | Assign Transaction - Securities Acct Block |
| VTB_ASGN_POS | FTR Assignment Management: Assigned Position Changes |
| FTRT_CFI_GRP_TXT | CFI Code Groups |
| THXET_MEAS_DOC | Effectiveness Test Docu |
| THXTS_HDG_SCEN_T | Hedge Relationship scenerio |
| THXT_MD_YC | market data yield curve type |
| ATRELE1 | Transaction release: Release procedure |
| VTBMDIN | CFM: Mirror Trans.- Incoming Mapping Log. System Counterprty |
| VTB_WEB_SERVICE | Define Web Service and Link to Business Connector |
| THXT_GROUP1_VAL | Table for values of grouping 1 |
| THXETS_HDG_CCT_T | Hedge Effectiveness: Current value calculation category |
| VTB_FMOD_SFHAART | Field Modification Values |
| AT81M1 | Assignment Table: SWIFT Code of Sender -> Business Partner |
| FTRT_FIX_DEF_CMP | (FX Rate) Fixing Reference - Composition Details |
| VTB_SPPI_CLASSIF | SPPI Classification for Financial Transaction |
| FTRT_FIX_DEF_T | (FX Rate) Fixing Reference Descriptions |
| FTRT_CFI_ATTR | CFI Attributes Per Group |
| THXET_MEAS_EFFRT | Effectiveness Test: Hedge Ratio Results. |
| TRCPAT2 | TR: Commodity Price Adjustment-Registration and Fixing (DCS) |
| FTR_SEPA_CC | SEPA Activation per Company Code |
| VTB_WEB_SERV_URL | FTR Web: Service Declaration |
| THXC_HR_CLASS | Classes of Hedging Relationships |
| VTB_WEB_SUSER | FTR Web: Service Users |
| TRIGC_COMPANY_ID | Customizing view for Dummy Company ID |
| VTB_ASGN_LIMIT | FTR Assignment Mgmt: Limit Profile of Assignment Object |
| THXT_HREL | Hedging Relationship DB Table |
| THXETS_EFF_TCA_T | Effectiveness test method category text table |
| THXC_NR_RNG_ASS | Number Ranges Assignment for P-Hedge Accounting |
| THXTS_HINST_PCAT | Hedge Scenerio : List of product categories allowed |
| THXT_GROUP_CUST | Customizing for Hedge Relationship Groupings |
| VTBMDMAPFLW | CFM: Mirror Transaction - Map Flows |
| THXET_MEAS_USER | Users of the Effectiveness Test |
| TCHT_HD_BEWEG_CY | SFGDT Commodity Flows Table |
| THXC_HR_CLASS_T | Classes of hedging relationsships |
| VTB_WEB_SUSERSAP | FTR Web: Service Users |
| THXTS_HITEM_PCAT | Hedge scenerio : List of product categories allowed |
| THXETS_EFF_TCA | Effectiveness test method category |
| VTB_WEB_ORGA | FTR Web: Organization Mapping to Service |
| FTR_AVG_SCHEDULE | Schedule with Rates |
| THXT_HDOC | DB table for storing the Hedge Documentation. |
| TCHT_HD_BEWEG_CF | SFGDT FGET Cashflows Table |
| TCHT_HD_COND | Instrument Conditions |
| VTBCSPREAD | Credit Spread per OTC Transaction |
| FTR_CRDT_DEF_T | Definition of Line of Credit |
| ATFWDUL | Assignment of Underlying to Transaction |
| VTBMDEX | CFM: Mirror Transaction - Initial Table |
| THXC_FLOWTYPE_EX | Treasury: Update types for Open and Close |
| THXC_HR_PROFL | Profile of hedging relationships |
| TCHT_HD_FGET | SFGDT FGET Structure |
| FTR_CRDT_DEF | Definition of Line of Credit |
| THXEC_CRIT_TERM | Effectiveness Test Critical Term(Obsolete) |
| VTBMDINFKT | CFM: Mirror Transaction Mapping Functions |
| THXEC_EFF_CONDS | To capture the Effectiveness Conditions |
| THXT_MD_HRPARAMS | Market Data: Hedge related parameters |
| VTB_FX_WEB_QUOTE | FX Quotes for Transfer as Transaction |
| VTB_RULESET_CC | FTR Rule Management: Company Code Rules |
| VTB_FMOD_SFGZUST | Field Modification at Activity Category Level |
| TTMC_ROUNDING | FX: Rounding Rules |
| THXT_HDOC_DMS | Storing the hedge documentation documents |
| VTBMDLS | CFM: Mirror Transaction - Assign Partner - Logical System |
| THXC_HITEM_PTYPE | Hedge scenerio : List of product types allowed |
| VTBPA | Fin. Transaction: Assignment of Further Business Partners |
| TIDX_FM_FLOW_CAT | Treasury: Calc. Categories of Cash Flow Calculator for PI |
| VTB_FMOD_BASIC | Field Modification Values |
| FTRC_LOC_DEF_T | (Swift) Location and Financial Centre Codes Descriptions |
| VTB_RULESET_TT | FTR Rule Management: Transaction Type Rules |
| VTB_FMOD_SFUNKTL | Field Modification Values |
| THXC_HINST_PTYPE | Hedge scenerio : List of product types allowed |
| THXT_MD_SEC | market data securities price |
| VTBMDPARTNER | CFM: Mirror Trans.- Unique Assignment of Partner - CoCd |
| VTBRATING | Rating for Financial Transaction |
| CMM_AVG_OPTUL | Underlying flow of Average Price options |
| THXT_MD_ET_INTR | market data reference interest rate |
| VTB_FMOD_FTR | Field Modification Definition |
| TRSPAT | TR: Security Price Adjustment - Registration and Fixing |
| VTB_RULESET | FTR Rule Management: Rule |
| THXET_MEAS_LOG | Effectiveness Test Detailed Log |
| THXT_MD_ET_YC | market data yield curve type |
| VTBMDMAP | CFM: Mirror Transaction - Map PType/TType in Meta Name |
| ATRELE2 | Transaction release: Release procedure for detail parameters |
| TIDX_INDEX_FLOW | Relation Between the Indexes and the Flows |
| VTB_WEB_URLS | FTR Web: Service URLs |
| VTB_ASGN_POSOBJ | FTR Assignment Management: Assigned Position Objects |
| ATARCHIVE01 | Archiving: Minimum retention period of transaction in system |
| VTBMDMAPKOND | CFM: Mirror Transaction - Map Conditions |
| TIDX_PRICE_VALUE | Values for the Index |
| TIDX_INDEX_FLOWC | Relation Between the Indexes and the Flows |
| FTRC_DDES | Treasury: retention periods for data destruction |
| FTRT_FIX_TRANS | TR: Foreign Exchange Rate Fixing - Registration and Fixing |
| THXEC_EFF_TMET_T | Effectiveness Test Method Definition text table |
| THXT_MD_INTR | market data reference interest rate |
| FTR_AVG_RATE | Average Rates |
| THXEC_CRIT_TYPE | Effectiveness Test Critical Term Type |
| THXT_HREL_INIT | Hedging Relationship Initialization Transactions |
| FTRT_LOC_TIME | Define Locations and Times |
| TRIGC_IGI_PT | IGT - ProdCat / ProdType in Valn Areas to be Included |
| VTB_FMOD_PROCESS | BDT Field Grouping per Activity Category |
| TRIGC_IGI_PC | IGT - Product Cats of the Parallel Valn Areas to be Included |
| VTB_RULESET_PA | FTR Rule Management: Business Partner Rules |
| VTBRELE1 | Transaction release: Change history |
| VTB_PCAT_FMOD | BDT Field Modification per Product Category |
| THXEC_EFFCONDTY | Effectiveness Condition Type |
| AT26 | Non Deliverable Currencies |
| VTB_WEB_QUOTES | FX Quotes Received |
| THXC_HR_PROFL_T | descriptions for profiles of hedging relationsships |
| VTB_RULESET_CR | FTR Rule Management: Transaction Currency Rules |
| FTRC_LOC_DEF | (Swift) Location and Financial Centre Codes Definition |
| THXET_MEAS_ITEM | Effectiveness Test: Results per HItem & HInstr. |
| FTR_TIER_LEVEL | Tier Level |
| TCHT_HD_SFGDT | SFGDT Representation of Instruments |
| FTR_TIER_DEF | Definition of Rank |
| TCHT_HD_COND_FOR | Instrument Condition Formula |
| THXT_GROUP2_VAL | Table for values of grouping 1 |