SAP Treasury Tables
Are you looking for the right table related to SAP 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 Treasury (TR) module.
Top 10 tables in Treasury
| Table | Description |
|---|---|
| TZ25 | Regulatory reporting list control |
| FLQQR_MORE | Liquidity Calculation - Other Fields for Conditions |
| FLQGRPT | Liquidity Calculation - Texts for Query Sequences |
| FLQLPOS_FIPOS | Relationship: Liquidity Items - Commitment Items |
| FLQQRCOND | Liquidity Calculation - Condition als String |
| FLQQR | Liquidity Calculation - Queries |
| FLQQR_FIELD | Liquidity Calculation - Proposal Fields for Conditions |
| TZ13T | Tax office indicator (Text) |
| TZ37T | Text table provision of security according to app. 5 R5/97 |
| FLQGRP | Liquidity Calculation - Query Sequences |
List of tables in Treasury
| Table | Description |
|---|---|
| TZ25 | Regulatory reporting list control |
| FLQQR_MORE | Liquidity Calculation - Other Fields for Conditions |
| FLQGRPT | Liquidity Calculation - Texts for Query Sequences |
| FLQLPOS_FIPOS | Relationship: Liquidity Items - Commitment Items |
| FLQQRCOND | Liquidity Calculation - Condition als String |
| FLQQR | Liquidity Calculation - Queries |
| FLQQR_FIELD | Liquidity Calculation - Proposal Fields for Conditions |
| TZ13T | Tax office indicator (Text) |
| TZ37T | Text table provision of security according to app. 5 R5/97 |
| FLQGRP | Liquidity Calculation - Query Sequences |
| FLQQR_MORETAB_S | Liquidity Calculation - Other Tables for Conditions |
| FLQITEMPARK_FC | Liquidity Calculation - Forecast Line Items for FI Documents |
| FLQCOMPANY | Liquidity Calculation - Company Codes |
| TW12T | BAV group 501 (Text) |
| FLQITEMFI | Liquidity Calculation - Line Items for Other FI Documents |
| TZ22 | Asset classes relationship table -- BAV- Sub-section |
| TZ28 | Asset Type According to Regulatory Accounting Requirements |
| FLQQRRG | Liquidity Calculation - Ranges for Queries |
| TZBPV | Control table for CH regulatory reporting (BPV) |
| TW05T | Insurance branch (Text) |
| TZ19 | Asset type in acc. with BAV PRF3 and PRF8, sub-section 7 |
| TZ36T | Text table for indicator appendix 3/4 circular R5/97 |
| TZK04 | Condition Groups |
| FLQACC_BURNED | Liquidity Calculation - Other Accounts |
| TZ32T | BAV asset group stmt 102 / Text |
| TZ39T | Text table indicator appendix 10 R5/97 mix type |
| TZ13 | Tax office stock indicator |
| TW12 | BAV asset group 501 |
| VZBAVF | BAV Master Data Without History Management |
| TZ27 | Allocation: Valuation area for internal stock indicator |
| FLQ_EXITS | Liquidity Planner: Valid user exits |
| FLQSUM_TP | Liquidity Calculation: Totals Records at Top Level |
| TZK0D | Condition groups: Texts (language-dependent) |
| TZ25T | Indicator for list selection |
| FLQACC_ACT | Liquidity Calculation - Other Actual Accounts |
| TW06T | BAV group (Text) |
| TZ36 | Check table for R5/97 appendix 3/4 |
| TZ18T | Asset group R11/76, append.1-2 and R2/87 append.1-2 (text) |
| TW10B | Relationship table TW10 - RANTYP |
| FLQQR_MORETAB | Liquidity Calculation - Further Tables for Conditions |
| TZ39B | Relationship table indicator R5/97 append. 10 for prod. cat. |
| TZ31T | Subsection / Text |
| TZ16 | BAV asset group stmt 201 |
| TZ29 | BAV asset group stmt 600 |
| TW05 | Insurance branch |
| TZ37 | Indicator for circular R5/97 appendix 5 |
| FLQITEMFI_TP | Liquidity Calculation: Actual Line Items at Top Level |
| FLQITEMD1_FC | Liquidity Calculation: Forecast Line Items from Loans |
| FLQGRP_QR | Liquidity Calculation - Queries for Sequence |
| FLQLPOS | Liquidity Items |
| TZ40 | Customizing regulatory reporting field control for contract |
| TZ32 | BAV asset group stmt 102 |
| FLQHEADMA | Liquidity Calculation - Header for Manual Transfer Postings |
| TZ28T | Asset Type in acc. with Reg.Acctng Requirements / Text |
| FLQINVEXIT | Liquidity Calculation - Settings for Invoice Exit |
| FLQITEMFI_FC | Liquidity Calculation - Forecast Line Items for FI Documents |
| FLQCLNT | Liquidity Calculation - Global Settings |
| FLQITEMMMPARK_FC | Liquidity Calculation - Forecast Line Items for MM Documents |
| TZ38T | Text table for indicator reason for message appendix 8 R5/97 |
| TZ21 | Control of cost elements for BAV statements |
| FLQACC_INFO_APP | Liquidity Calculation - Accounts with Assignment Information |
| TZ29P | Check table for indicator SNW600 |
| TW09B | Relationship table TW09 - RANTYP |
| TZ16T | BAV asset group stmt 201 (Text) |
| FLQQR_TABLE | Liquidity Calculation - Tables for Query Fields |
| TW10 | Subsection |
| FLQITEMMA | Liquidity Calculation - Line Items for Manual Transfers |
| VZBAVV | Variable BAV Master Data |
| FLQITEMBS | Liquidity Calculation - Line Items for Bank Statement Docs |
| TZ29T | BAV asset group stmt 600 / Text |
| TZ17 | Asset group C11/76 Asset 6 (Annual stock overview) |
| FLQSUM | Liquidity Calculation - Totals Records |
| FLQFC_LOCK | Liquidity Calculation - Lock for Forecast |
| FLQITEMT1_FC | Liquidity Calculation: Forecast Line Items from TR Trans. |
| FLQASSET | Liquidity Calculation - Settings for FI Mechanisms |
| TW10T | Subsection texts |
| TZ19T | Asset type in acc.with BAV PRF3 and PRF8, sub-sect. 7 (Text) |
| TW09T | Premium reserve fund (Text) |
| TZ30 | Premium reserve fund list |
| TW06 | BAV group 4/77 appendix 8 |
| TZ11T | Stock indicator (Text) |
| TZBRA | Name of grouping table acc.to R11/76 app.4 - Contract.party |
| FLQITEMSO_FC | Liquidity Calculation-Forecast Line Items from Sales Orders |
| TZ15T | BAV asset group stmt 102 (Text) |
| TZ30T | Premium reserve fund list number / Text |
| FLQACC_INFO | Liquidity Calculation - Accounts with Assignment Information |
| FLQQRT | Liquidity Invoices - Query Texts |
| FLQBANK_GRP | [Obseleted] Liquidity Calc. - Assignmt of Acct to Query Seq. |
| TZ14T | BAV asset group stmt 101 (Text) |
| TZ17T | Asset group R11/76, appendix 6 (Text) |
| TZ11 | Stock indicator |
| TZ14 | BAV asset group stmt 101 |
| TZ38 | Indicator for circular R5/97 appendix 8 |
| FLQSUM_FC | Liquidity Calculation - Forecast Totals Records |
| TZ15 | BAV asset group stmt 102 |
| TZ45 | Headings for BAV Lists |
| FLQGSBER_SUBST | Liquidity Calculation: Replacement of Business Area |
| FLQFIPOS_LPOS | Relationship: Commitment Items - Liquidity Items |
| TW09 | Premium reserve fund list |
| TZ18 | Appendix group R11/76, appendix 1-5 and R2/87, append. 1-2 |
| TZ31 | Subsection |
| FLQLPOST | Liquidity Items - Texts |
| TZ39 | Indicator for circular R5/97 appendix 10 |
| FLQITEMPO_FC | Liquidity Calculation - Forecast Line Items for MM POs |
| FLQITEMPR_FC | Liquidity Calc. Forecast - Line Items, Purchase Requisitions |