SAP Transfer to Financial Accounting Tables
Are you looking for the right table related to SAP Transfer to Financial Accounting 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 Transfer to Financial Accounting (FIN-FSCM-TRM-TM-AC) module.
Top 10 tables in Transfer to Financial Accounting
| Table | Description |
|---|---|
| ADJT_TRANSACTION | Treasury: Reconciliation business transactions |
| TRACT_POSCONTEXT | Treasury: Position Context Table |
| TRACC_MIG_AAREF | Migration of Definitions of Account Assignment References |
| TRLC_DFT_ASSGN_L | Assignment: Update Types for Position Change Category L |
| TRLC_DFT_ASSGN_M | Assignment: Update Types for Position Change Category M |
| TRLC_DFT_ASSGN_B | Assignment: Update Types to Position Change Category B |
| TRAC_DFTRULE2 | Treasury: Assgmt of Update Type to Post. Specs per Valn Area |
| TRL_C_FT_REPLACE | Replacement of Update Types |
| TRLTC_ATTRVAL_MT | medium attribute values |
| TRLTC_ATTRVAL_S | short attribute values |
List of tables in Transfer to Financial Accounting
| Table | Description |
|---|---|
| ADJT_TRANSACTION | Treasury: Reconciliation business transactions |
| TRACT_POSCONTEXT | Treasury: Position Context Table |
| TRACC_MIG_AAREF | Migration of Definitions of Account Assignment References |
| TRLC_DFT_ASSGN_L | Assignment: Update Types for Position Change Category L |
| TRLC_DFT_ASSGN_M | Assignment: Update Types for Position Change Category M |
| TRLC_DFT_ASSGN_B | Assignment: Update Types to Position Change Category B |
| TRAC_DFTRULE2 | Treasury: Assgmt of Update Type to Post. Specs per Valn Area |
| TRL_C_FT_REPLACE | Replacement of Update Types |
| TRLTC_ATTRVAL_MT | medium attribute values |
| TRLTC_ATTRVAL_S | short attribute values |
| TRLTC_ATTRVAL_M | medium attribute values |
| TRACTSLT | Totals Table |
| TRAC_ACCASSREF | OLD: Valuation Area-Dependent Account Assignment Refs |
| ADJTC_DFT_ASSIGN | Update Types for Position Reconciliation |
| TRLT_INIT_SUB_TR | Init.Hedging Rel.: Bus.Trans.Mgmnt, Designation Subpositions |
| VALC_VAL_PROC_T | OLD! TR: Texts for Valuation Procedures |
| VALC_FORW_PROC | OLD! Rate Valuation Procedure: Forward |
| TRACTSLA | Actual Line Item Table |
| TRLTS_DERIVDEF_T | Position Management Category (Text) |
| TRLT_FS_SUB_COMP | Transaction Figures for Each Component and Subposition |
| TRLTC_ATTRVAL_ST | short attribute values |
| TRLTS_DCAT_PCAT | Treasury: Asst of Derivation Method to Pos. Management Cat. |
| TRLC_DFT_ASSGN_P | Assignment: Update Types for P/L due to payment |
| TRAC_ACCSYMB_INI | Alternative Acct Symbols for OTC Transaction Initialization |
| TRSET_FLOW | OLD: Prelim. Solution: Transferred Security Flows |
| TRACT_DOCUMENT | Treasury: Accounting Adaptor Document |
| TRACC_GROUP | Definition of Grouping Characteristic Values |
| TRLC_DFT_ASSGN_A | Assignment: Update Types to Position Change Category A |
| VALC_TIFE_PROC_T | OLD! Texts for One-Step Price Valn, Sec. Valn, FX Valuation |
| TRGTS_STEPDEF_T | Treasury: Description of Step Categories |
| TRLT_FIXINGSUM | TR Ledger Transaction Figures |
| TRLTC_POSATT_DEF | position attributes |
| TRGTS_STEPDEF | Treasury: Step Categories in Position Management |
| TRSET_BUSTRANS | OLD! Preliminary Solution: Transferred Sec. Bus.Transactions |
| TRILC_DFT_ASSGN | Assignment of Update Types for Hedge Accounting |
| TRGT_MIGR1 | Management Table for CFM Conversion (Custom. Steps) |
| TRLC_IFT_ASSGN | Assign Update Types for Initializing Positions |
| TRAC_ACCSYMBREP1 | OLD: Prelim. Solution for Acct Det.: Acct Symbol Replacement |
| TRAC_ACCSYMB | Account Determination: Account Symbols |
| BCKTRLT_FLOW | Treasury Ledger Flows |
| VALC_VAL_PROC | OLD! TR: Definition - Valuation Procedure |
| TRGC_ZATTRIB | Custom Settings for Valuation Steps |
| TRLC_DFT_ASSGN_E | Assignment: Update Types to Position Change Category E |
| TRACC_OPTIONS | Treasury: Options for the Accounting Adaptor |
| TRLT_FLOW | Treasury Ledger Flows |
| TRACC_ACCASSREF1 | OLD: TR: Account Assignment Ref. Allocation Old->New |
| TRLT_FS_COMP | TR Ledger: Transaction Figures per Component |
| TRLT_INIT_VAL_LO | Initialization Values for TRL Positions: Loans |
| TRACTSLO | Object Table 1 |
| TRAC_DFTRULE1 | Treasury: Assignment of Update Type to Posting Specs |
| VALC_RPVAL_PROC | OLD! TR: Definition - Price Valuation Procedures |
| TRLTS_PMCAT_T | Position Change Category (Text) |
| TLVC_DFT_ASSGN | Assign Update Types for Valuation |
| TRILT_DTRANS | Derived Business Transactions in the Income Ledger |
| TRACT_TAX_ASSIGN | TRM Tax Code Assignment |
| VALC_RPVALPROC_T | OLD! TR: Texts for Price Valuation Procedures |
| TRACT_QUEUE | Resubmission for Reversal |
| TRLT_INIT_SUB_OT | Init.Hedging Rel.: Data for MM, FX, OTC Deriv.with Subpos. |
| BCKTRLT_SUBPOSIT | Backup: Treasury Ledger Position |
| TRACC_MIG_ACCDET | Table for Migration of Account Determination |
| TRACTSLC | Object Table 2 |
| TLVT_VAL_TRANS | Treasury: Valuation Business Transactions |
| BCKTRLT_POSITION | Backup: Treasury Ledger Position |
| TRPRT_PAYMENTS | Persistent Data for Payment Requests |
| TRLC_DFT_ASSGN_H | Assignment: Update Types to Position Man. Procedure Cat. H |
| BCKTLVT_VAL_FLOW | Backup: Treasury: Valuation Flow |
| TRLC_DFT_ASSGN_V | Assignment: Update Types to Position Management Category V |
| TRLC_DFT_ASSGN_K | Assignment: Update Types for Position Change Category K |
| TRGC_STEP_PROC_T | Step Procedure Texts |
| TRLC_PC_INIT | Treasury: Product Cats in the Parallel Valuation Classes |
| TRACTSLP | Plan Line Items Table |
| TRLTS_DERIV_CAT | Treasury: Assignment of Derivation Method to Pos. Mgmt Cat. |
| TRLT_POSITION | Treasury Ledger Position |
| TLVT_VAL_STEP | Treasury: Valuation Step |
| TRLT_POS_ATTRIB | additional attributes of TRL-positions |
| TRATT_FLOW | Transfer Flows |
| VALC_FORW_PROC_T | OLD! TR: Texts for Rate Valuation Procedures - Forwards |
| TRLT_FLOWBCKPACK | Flow Backpack |
| TLVT_VAL_STEPLOG | Treasury: Valuation Step Additional Log |
| TRACC_ADDACCDATA | Additional Acct Assignments Dependent on Acct Assignm. Ref. |
| TRLT_INIT_POS | Admin. Table: (Obsolete as from Support Package 01) |
| TRACC_AA_REF | Treasury: Account Assignment Reference |
| TRLT_LOCK | Treasury Ledger Position Lock |
| BCKTRACT_ACCITEM | Treasury: Accounting Items |
| TRLC_DFT_ASSGN_F | Assignment: Update Types to Position Change Category F |
| TRLT_INIT_TRANS | List of Initializing Business Transactions |
| TRACC_ACCSYMBREP | Acct Determination: Replacement of Acct Symbols by G/L Accts |
| TLVT_VALGRP_BLDR | Valuation Group Builders |
| TRAC_ACCASSREF_T | OLD: Text Table for Account Assignment References |
| TRLT_INIT_VAL_SE | Initialization Values for TRL Positions: Securities |
| TRLC_DFT_ASSGN_G | Assignment: Update Types to Position Change Category G |
| TRLT_NEW_POS | Treasury: New Initialization or Transfer Positions |
| TRLT_DERIVTRANS | Derived Business Transactions |
| TRLT_INITIALIZE | Management Data for Initialization of Treasury Ledger |
| VALC_TIFE_PROC | OLD! Procedures for One-Step Price Valn, Sec. Valn, FX Valn |
| TRILT_DFLOW | Derived Flows in the Income Ledger |
| TRLC_DFT_ASSGN_J | Assign Update Types to Position Management Category J |
| TRLT_TRANSACTION | Treasury Ledger Business Transactions |
| TRSET_RUN_HEAD | OLD: Prelim. Solution: Transfer Runs |
| TRLT_FBP_CMP_VAL | Flow Backpack Values for Each Component and Subposition |
| TRLT_DERIVFLOWS | Treasury: Flows for Derived Business Transactions |
| TRLTS_DERIV_REL | Treasury: Relevant BT Categories per Derivation Method |
| TRAC_POSTRULE_T | Treasury Account Determination: Text Table Posting Specs |
| TRLT_INIT_IGT_SE | Initialization Values for Intragroup Transactions |
| TRLTS_DERIVDEF | Position Management Category (Definition) |
| TRLT_BACKUPVORAB | Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol. |
| TRACC_POST_REL | Exclude Product Types from Posting |
| TRSET_RUN_POS | OLD: Preliminary Solution: Transfer Run Items |
| TRLT_INIT_SUB_SE | Init.Hedging Relationship for Securities with Subpositions |
| TRATT_TRANS | Account Assignment Reference Transfer Business Transactions |
| TRLT_INIT_DES | Init.Hedging Relationship: Bus.Trans.Mgmt, Designation |
| TRLT_INIT_VAL_FU | Initialization Values for TRL Futures Positions |
| TRAC_ACCSYMBREP2 | OLD: Prelim. Solut.: Replace Acct Symbols per Acct Ass.Ref. |
| TRGC_ZATTRIB_T | Texts for Custom Settings for Valuation Steps |
| TRGC_STEP_PROC | Procedure for Steps |
| TRLT_DOCUMENT | Treasury Ledger Documents |
| TRAC_ACCSYMB_T | Treasury Account Determination: Text Table for Acct Symbols |
| TRLT_INIT_VAL_HR | Init.Hedging Rel.:Mapping to Hedging Rel.in New Company Code |
| TRLTS_INIT_COMP | Mapping of Position Components to Treasury Ledger |
| BCKTRLT_DERIVFLO | Treasury: Flows for Derived Business Transactions |
| TRLT_INITSTEP3 | Function Modules of Treasury Ledger Initialization Step 3 |
| TRACT_ACCITEM | Accounting Items |
| TRLTS_STATE_T | Texts for TRL Posting Status |
| TRLTS_PMCAT | Position Change Category |
| TRATC_DFTASS | Update Types for Account Assignment Reference Transfer |
| TRLC_DFT_ASSGN_N | Assignment: Update Types to Position Change Category N |
| TRLT_BUSTRANS_BW | Treasury Ledger Business Transactions for BW Extraction |
| VALT_SP_VAL_SEC | Security Prices and NPV for Special Valuation |
| TRLT_SUBPOSITION | Treasury Ledger: Subposition |
| TRLTC_POSATT_D_T | position attributes |
| TLVT_VAL_FLOW | Treasury: Valuation Flow |
| TLVT_MANUAL_VAL | Book Values for Manual Valuation of Positions |
| TRACC_DFT_REL | Posting Relevant Update Types |
| TRACC_AA_REF_T | Treasury: Text Table Account Assignment Reference |
| TRAC_POSTRULE | Treasury Account Determination: Posting Specifications |
| TRLC_DFT_ASSGN_D | Assignment: Update Types to Position Change Category D |
| TRGTS_STEPS | Treasury: Permitted Steps per Position Management Category |
| TRLC_CT_INIT | Treasury: Contract Types in Parallel Valuation Areas |
| TRLAC_DFT_PMC | Assignment of Update Type to Position Change Category Value |
| TRACC_GROUP_T | Description of Grouping Characteristic Values |
| TRLC_DFT_ASSGN_C | Assignment: Update Types to Position Change Category C |