Interest Report

[Former Member]

Hi Experts,

i want to know the table relation in treasury

from which tables can i get the below fields information

1. company code & customer no

2. lender cheque in favor of

3. type of loan & loan account no

4. sanction amount

5. outstanding amount

6. deal no & entry posting date

7. interest amount & rate of interest

8. pending (reason for pending)

please provide me the above details.

Thanks & Regards,

aish

[Former Member · Accepted solution]

Please find the list of Tables in Treasury with Description

All above the data you have asked above can be obtained from VTBFHAPO table. This is the master table for all Treasury Transactions.

VTBFHA	Transaction
VTBFHAZU	Transaction Activity
VTBFHAPO	Transaction Flow
VTBFHAPO_UNFIXED	Non-Fixed Financial Transaction Flows
VTBFINKO	Transaction Condition
VTBAFINKO	Alternative Conditions
VTBKORES	Correspondence Data
VTIFHA	Underlying transaction
VTIFHAZU	Underlying transaction status table
VTIFHAPO	Underlying transaction flows
VTIFINKO	Underlying transaction conditions
VTIAFINKO	Alternative Conditions Underlying
TRIAT	Treasury: Int.Rate Adjust. - Registration and Int.Rate Adj.
REFON	References between object numbers (CO object no.)
TRDT_TRDBUSTRANS	Treasury: Persistent distributor business transaction
TRDT_FLOW	Persistent distributor flows
PAYRQ	Payment Requests
BKPF	Accounting Document Header
BSEG	Accounting Document Segment
FDT1	CMF Line Items for Forex, Money Market, Derivatives
TZPA	Product type
ATRAS	Treasury Rates Table  Treasury - Treasury
AT15	Foreign exchange swap rates  Treasury - Treasury
BPISIS	BP: Assign Treasury Partner to IS-IS-Partner  Cross Application - Business Partner Enhancements for Financial Services
BP002	Treasury attributes natural person  Cross Application - Business Partner Enhancements for Financial Services
BPTRGP_WORK	BP: Assign Treasury Partner to IS-IS-Partner  Financials - Business Partner
AT16B	Treasury: Settings for mirror transaction types  Financials - Transaction Manager
BCKTRACT_ACCITEM	Treasury: Accounting Items  Financials - Transfer to Financial Accounting
VWBEKI	Treasury Securities: Actual Flows - Header  Financials - Transaction Manager
TWD01	Treasury: Securities Account Master Data  Financials - Transaction Manager
AT15B	Treasury: Forex Swap Rates (New)  Financials - Transaction Manager
AT16	Treasury: Fixing Settings for Forex Transactions  Financials - Transaction Manager
TRACT_DOCUMENT	Treasury: Accounting Adaptor Document  Financials - Transfer to Financial Accounting
BCKTRLT_FLOW	Treasury Ledger Flows  Financials - Transfer to Financial Accounting
AT18	Treasury: Valid Formulas  Financials - Transaction Manager
ADJT_TRANSACTION	Treasury: Reconciliation business transactions  Financials - Transfer to Financial Accounting
TRAC_DFTRULE1	Treasury: Assignment of Update Type to Posting Specs  Financials - Transfer to Financial Accounting
ATPA	Treasury: Product Type Supplements  Financials - Transaction Manager
TRLT_TRANSACTION	Treasury Ledger Business Transactions  Financials - Transfer to Financial Accounting
FMTC_SCHNO	Treasury Confirmation Schedule No status  PSM - Funds Management
BCKTLVT_VAL_FLOW	Backup: Treasury: Valuation Flow  Financials - Transfer to Financial Accounting

[Former Member · Accepted solution]

Hi Anil Kumar,

Thanks you so much for immediate reply, if i need anything else on this I will ask you.

Thanks & Regards,

Aish.

[jasmine_li]

Hi AIM,

In treasury, logical databases are prepared for reporting.

Let me give some information about the logical databases. For
ERP6.0 the TRM Transaction Manager offers five logical databases which
should suffice as the basis of SAP-Queries and drill down reports:

+ FTI_TR_POSITIONS  key date   reporting for position management
+ FTI_TR_PERIODS    periodical reporting for position management
+ FTI_TR_PL_CF      like FTI_TR_PERIODS but only profit related fields
+ FTI_TR_CASH_FLOWS payment reporting
+ FTI_TR_DEALS      key date reporting for transaction management

Moreover, there are the Reporting Application Programming Interfaces
(RAPI) in function group FTI_LDB_RAPI-

For Position Relevant flows you may consider FTI_TR_POSITIONS /
FTI_TR_PERIODS. For profit & loss, you may check FTI_TR_PL_CF.

Also see note 808461, KBA note 1829370 for more information.

Financial Supply Chain Management

Treasury and Risk Management

   Transaction Manager

     Information System

       Reports  ->  standard reports

       Tools

          SAP Query

          Drilldown Reporting

You may find more information from online help as below:

Information System - SAP Library

Best regards,

Jasmine

[Former Member]

Hi AIM,

Alternatively you can use below steps to find out the tables getting effected by particular transaction.

In case you wan to read the data from a particular deal, then please try through Functional Module.

SE37-->  DealData_Read--> Input : Co.Code and Deal No. -->

You will find all the tables impacted through this deal and pick directly from there.

Cheers !

Aditiya

[Former Member]

Hi experts,

please help me to develop the report in treasury, i am new ti this module.

thanks

aish