SAP Localization for Treasury Tables
Are you looking for the right table related to SAP Localization for Treasury 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 Localization for Treasury (FI-LOC-TRM) module.
Top 10 tables in Localization for Treasury
| Table | Description |
|---|---|
| IDCFMHU_TET | TET - Consolidated securities transactions per day |
| IDCFM_DATA_SEC | Valuation-Area-Independent Data for Securities |
| IDCFMHU_KELER1 | Keler - SAP data processing control table |
| IDCFM_BST_CFMAV | Customizing for Balance Sheet Transfer with VA (obsolete) |
| IDCFMFLCALCRLP | Description of simplified flow calc.procedure (percentages) |
| IDCFMHU_INC | Interface Set Up |
| IDCMLHU_14PASS | Interest on Arrears Flow Type for Payment |
| IDCFM_USFA_COND | Facility: Conditions |
| IDCFM_SWP_FLOWS | Flows for Net Amount Procedure |
| IDCFMHU_OB_AAR | Assign G/L Accounts for Off-Balance Postings |
List of tables in Localization for Treasury
| Table | Description |
|---|---|
| IDCFMHU_TET | TET - Consolidated securities transactions per day |
| IDCFM_DATA_SEC | Valuation-Area-Independent Data for Securities |
| IDCFMHU_KELER1 | Keler - SAP data processing control table |
| IDCFM_BST_CFMAV | Customizing for Balance Sheet Transfer with VA (obsolete) |
| IDCFMFLCALCRLP | Description of simplified flow calc.procedure (percentages) |
| IDCFMHU_INC | Interface Set Up |
| IDCMLHU_14PASS | Interest on Arrears Flow Type for Payment |
| IDCFM_USFA_COND | Facility: Conditions |
| IDCFM_SWP_FLOWS | Flows for Net Amount Procedure |
| IDCFMHU_OB_AAR | Assign G/L Accounts for Off-Balance Postings |
| IDCFMHU_TKILOG | KELER-KID Import Log |
| IDCFM_FRIM_DATA | Impairment Main Data |
| IDCFMHU_TKIDEP | Assign KELER Accounts to Securities Accounts |
| IDCFM_FRIM_CELMS | Data Elements for Selection Parameters - Impairment |
| IDCMLHU_01HDR | Contract Amount Off-Balance Posting - Header |
| IDCFM_FRIM_IMOTC | OTC Transaction for Impairment |
| IDCFM_USWS_SATTT | Wash Sales: Selection Attributes (Text table) |
| IDCFM_USWS_WSIT | Wash Sales: Worklist Item |
| IDCFM_BST_CUSAV | Customizing for Balance Sheet Transfer for Brazil (obsolete) |
| IDCFMHU_CSECHDR | SEC off-blnc postings head |
| IDCFMHU_CFW_HDR | CFM - FW off-blnc postings head |
| IDCFMHU_DR001 | Addition data for CFM collateral repo transaction |
| IDCFM_BST_HIST | History table for balance sheet transfer for Brazil |
| IDCFMHU_TKIKIV | Account List for Except Securities |
| IDCFM_TRANSFUNDS | Funds: Additional Informations |
| IDCFM_FRIM_RUNS | Runs of Impairment Report |
| IDCFM_USTB_SETT | TBA: Link Settlement Type to Settlement Indicator (Text) |
| IDCFMFLOWCALC | Flow calculation using condition technique |
| IDCFMHU_CFMKSW | Interest Swap Null Correction |
| IDCMLHU_01FTYP | Relevant flow types for Contract amnt. off-balance posting |
| IDCFM_ICLTXCALC | Intercompany Loan Tax Calculation Method |
| IDCFMHU_KELERDEP | Keler import control data |
| IDCFM_FRCR_ACA | Capitalization Reserve - Account Check Activation |
| IDCFM_USHA_DEF | FAM-US: Product Type Activation |
| IDCMLHU_01DOC | Contract Amount Off-Balance Posting - Documents |
| IDCFM_FRCR_PDVA | Capitalization Reserve - Product Type |
| IDCFM_USWS_TGRP | Wash Sales: Tax Group |
| IDCFM_RF_POSEC | Tax Security Account |
| IDCFM_USFA_SITA | Facility: Secondary Index ID - Text Table |
| IDCMLHU_01ACC | Determine Account Assignments |
| IDCFM_ICLTXFLDIR | Flow Types for Tax Types with Sign |
| IDCFM_USFX_UT_CU | Customizing FX Average Rate: Currencies |
| IDCFMHU_LR | Last starts of the off-balance posting programs |
| IDCFMHU_CREPO | Treasury - Repo off-blnc postings |
| IDCFMFLOWCALCIN | Flow calculation using conditions: map CFM data to KOMK/KOMP |
| IDCFM_ICLTXFLOWS | Intercompany loan tax flow types for different product type |
| IDCMLHU_01SIL | Assign Internal Status to Processing Status |
| IDCFMHU_CFW_REF | FW off-blnc aa_ref and valuation area pairs |
| IDCFM_USWS_ACTI | WashSales: Activate Valuation Area |
| IDCMLHU_01TRAN | Set Currency Translation Date |
| IDCMLHU_13ERRL | Suspension Error Log |
| IDCFM_FRCR_PF | Capitalization Reserve - Portfolio |
| IDCFMFLOWCALCOUT | Flow calc.using conditions:map KOMK/KOMP fields to flow data |
| IDCFM_USTB_SETP | TBA: Link Settlement Type to Product Types |
| IDCFMHU_TKICFM | KELER Interface Current Date Confirmed Items |
| IDCFM_FRIM_CSETS | Parameter Sets for Impairment |
| IDCFM_FRCR_CDD | Capitalization Reserve - Differentiation Criteria |
| IDCFMHU_CISWHDR | CFM - ISW off-blnc postings head |
| IDCMLHU_14FTYP | Interest on Arrears Reference Condition Type |
| IDCFM_USFX_UT_HD | Customizing Average Exchange Rate: Differentiation |
| IDCMLHU_13HIST | Suspension Item History Table |
| IDCMLHU_13SCAS | Assign Legal Entity to Sector Code Groups |
| IDCFMHU_TKELOG | KELER-KID Export Log |
| IDCMLHU_14PSTPOS | Interest on Arrears Posting Document Item |
| IDCFMHU_TR_KLRA | IDCFMHU_TR_KLRA Ac |
| IDCFM_USWS_WSHD | Wash Sales: Worklist Header |
| IDCMLHU_LELOGU | Itemized Commitment - Waiver Log Transaction |
| IDCFM_USWS_CRIT | Wash Sales: Selection Criteria |
| IDCFM_FRIM_CTABT | Tab Pages for Selection Parameters - Impairment (Text) |
| IDCFM_BST_CFMA | Customizing for Balance Sheet Transfer with VA (obsolete) |
| IDCFM_USFA_SIA | Facility: Secondary Index |
| IDCFMSETX_RATE | Tax rates for tax reports TRM Brazil |
| IDCFMBRSETX_HST | History table for taxation |
| IDCFM_BST_CUST | Customizing for Balance Sheet Transfer for Brazil |
| IDCFM_FRCR_DFT_B | Assignment: Update Types to Position Change Category B |
| IDCMLHU_12RUNL | Run Log for Debt Transfer |
| IDCFM_ICLTXCAT | Intercompany Loan Tax Calculation Category |
| IDCFM_FRIM_SELPR | Selection Parameters for Impairment Report Run |
| IDCMLHU_13PARA | Define Overdue Days |
| IDCFMHU_TR002 | Authorized flowtypes for collateral REPO transactions |
| IDCMLHU_14CALSUM | Interest on Arrears Calculation Summary |
| IDCFM_FRCR_DFT_M | CFM: Update Types for Manual Posting |
| IDCFMHU_COPTDOC | OPT off-blnc postings documents |
| IDCFMHU_TR005 | Partner's KELER ledger |
| IDCMLHU_14BAS | Interest on Arrears Define Posting |
| IDCFM_REGION | Identifies Region Special Role |
| IDCFM_RF_POMAP | Non-Regulated and Tax Porfolios Mapping |
| IDCMLHU_13RUNR | Suspension Run Relation |
| IDCFM_FRAM_DICRI | Assignment of Alternative Position Management Procedure |
| IDCMLHU_13SFTY | Assign Flow Types for Year-End Suspension |
| IDCFM_RF_CCYES | Set Company Code: Active for the FIFO Reevaluation |
| IDCFM_FRIM_DEXP | Impairment: BAdI Example Values: Expected & Expert Values |
| IDCMLHU_13SCGT | Sector Code Group Text |
| IDCFM_USWS_SATT | Wash Sales: Selection Attributes |
| IDCFM_USFAM_DEF | US-FAM: Topic Activation |
| IDCMLHU_13SPFT | Assign Flow Types for Intrayear Suspension |
| IDCFMHU_DCACCT | Accrual account debit/credit |
| IDCFMSETX_CUST | Cusotmizing for tax posting to FI for funds - Brazil |
| IDCFM_BST_CUSTIT | Customizing for Balance Sheet Transfer for Brazil |
| IDCFMFLCALCRLN | Description of simplified flow calculation procedure (lines) |
| IDCFM_FRREU_CUS | Treasury France: Topic Activation |
| IDCFMHU_TKESEC | Define KELER Security IDs |
| IDCMLHU_01DTY | Assign Product Types to Document Types |
| IDCMLHU_13SCGR | Define Sector Code Groups |
| IDCFMHU_TKEEXP | KELER-KID Export Transactions |
| IDCFM_FRCR_PFVA | Capitalization Reserve - Portfolio |
| IDCMLHU_14CALERR | Interest on Arrears Calculation Error |
| IDCFM_FRIM_CTABS | Tab Pages for Selection Parameters - Impairment |
| IDCFM_HU_DERIV | HU GAAP: Relevant BT Categories per Derivation Method |
| IDCFMHU_CREPO_C | Assign G/L Accounts for Repo Off-Balance Postings |
| IDCFM_SWP_NET | Net Amount Procedure |
| AT200 | Rules for Determining a Tax Indicator |
| IDCMLHU_LELOGF | Itemized Commitment - Waiver Log Header |
| IDCFMHU_TR_KLRL | IDCFMHU_TR_KLRL |
| IDCFM_RF_SAVA | Separate Additional Valuation Area |
| IDCMLHU_LELOGM | Itemized Commitment - Waiver Log Messages |
| IDCFMHU_ASLOG | LOG installments repayment sec. depreciation |
| IDCMLHU_13QUAL | Set Suspension Relevancy of Rating Codes |
| IDCFM_HU_REPO | REPO: HU GAAP Activation |
| IDCFMHU_TR006 | Partner's KELER sub-ledgers |
| IDCMLHU_13RUNL | Suspended Commissions and Interest Posting Log |
| IDCMLHU_12FTYP | Flow Types for Debt Transfer |
| IDCMLHU_13COLG | Contract Log Pass on Table - Suspension |
| IDCFM_USTB_SETY | TBA: Link from Settlement Type to Settlement Indicator |
| IDCFMHU_HKT | Securitity Extract Type |
| IDCMLHU_01LR | Contract amnt. off-balance posting - last run of the prg. |
| IDCMLHU_LELOGT | Itemized Commitment - Waiver Log Items |
| IDCFMHU_LTK | Securities Deposit Code |
| IDCFM_USFA_SI1A | Facility: Secondary Index ID |
| IDCFMHU_TR004 | Deposit accounts for passive collateral repos |
| IDCMLHU_14ACC | Interest on Arrears Posting Rule |
| IDCFM_IN_HSN | Assign HSN/SAC Code to Update type |
| IDCFM_FRCR_PD | Capitalization Reserve - Product Type |
| IDCFMHU_COPTHDR | CFM - OPT off-blnc postings head |
| IDCMLHU_13PDLG | Suspended Commitment and Interest Posting Log |
| AT210 | Rules for Determining a Taxes for CFM postings |
| IDCMLHU_14CALHDR | Interest on Arrears Calculation Run |
| IDCMLHU_14ACCT | Interest on Arrears Posting Rule Text |
| IDCFMHU_CSECDOC | SEC off-blnc postings documents |
| IDCFM_FRIM_CSELP | Selection Parameters - Impairment |
| IDCMLHU_01PASL | Enable Inclusion of Passive Loans |
| IDCFMHU_TKEACC | Define KELER Accounts |
| IDCFM_USTB_VTIOF | TBA: Additional Option Data - Settlement Type |
| IDCMLHU_13CCNT | Define Status for Exclusion |
| IDCFM_FRCR_CD | Capitalization Reserve - Accounting Code |
| IDCMLHU_13FTYP | Define Flow Types for Suspension |
| IDCFMHU_RESPER | Archiving: Residence Period in Months |
| IDCMLHU_14CTYP | Interest on Arrears Condition Type |
| IDCFMBRSE_PST | Customizing for creation of sales transactions for tax pmnts |
| IDCFMHU_12_2 | Flow types for delivery repo riports |
| IDCMLHU_13SILG | Suspended Items Log for Intrayear Run |
| IDCMLHU_14ACCA | Interest on Arrears Assignment of Posting Rule |
| IDCMLHU_13ODLG | Open Debt Log Pass on Table |
| IDCMLHU_14PSTHDR | Interest on Arrears Posting Document Header |
| IDCFMHU_SP | Off-blnc postings selection parameters |
| IDCFMHU_TR_KLRS | IDCFMHU_TR_KLRS |
| IDCFM_USWS_ASGN | WashSales: Assignment of Update Types to PMP |
| IDCFMHU_CFW_DOC | FW off-blnc postings documents |
| IDCFMFLOWCALCRUL | Calculation rules for simplified flow calculation |
| IDCFM_FRAM_DICPT | Assign Product Types for Alternate Position Mngt. Procedure |
| IDCFMHU_SM | SUM - Consolidated securities transactions per day |
| IDCFMHU_TR001 | Authorized collateral REPO transactions in company |
| IDCFMHU_TR_EPFG | Treasury check |
| IDCFM_BST_CFMIT1 | Customizing for Balance Sheet Transfer for Brazil |
| IDCMLHU_14CALPOS | Interest on Arrears Calculation Item |
| IDCFM_FRIM_CSELT | Selection Parameters - Impairment (Text) |
| IDCFMHU_TKIELT | Account Deviation Code |
| IDCFMHU_CISWDOC | ISW off-blnc postings documents |
| IDCFMFLCALCRLA | Description of simplified flow calc.procedure (amounts) |
| IDCMLHU_14CATT | Interest on Arrears Category Text |
| IDCFM_BST_CFMIT | Customizing for Balance Sheet Transfer for Brazil (obsolete) |
| IDCFM_BST_CUSA | Customizing for Balance Sheet Transfer for Brazil (obsolete) |
| IDCFMHU_TKITEM | KELER-KID Import Security Accounts Day List |
| IDCFM_USFX_UT | TR: Customizing Average Exchange Rate for Income |
| IDCFMSETX_COMP | Compensating method for Funds (TRM) |
| IDCMLHU_14CAT | Interest on Arrears Category |
| IDCFM_FRIM_CSETT | Parameter Sets for Impairment (Text) |
| IDCFMHU_ADSLOG | Accruals of discount security log |
| IDCFM_BST_CFM | Customizing for Balance Sheet Transfer for Brazil |
| IDCMLHU_13SGR | Suspension Attributes |
| IDCMLHU_CKOND | Assign Condition Type to Condition Type Attribute |