TRM tables

[former_member210794]

Respected All,

Please provide me list of important TRM tables ,specially related to Letter of Credit?

This is my first implementation in TRM

Best regards

Abhishek

[lisa_savinovich · Accepted solution]

Hello Abhishek,

In working with the Treasury & Risk Management module, I have found the logical databases below extremely useful in ABAP programs and queries to meet users reporting requests.

Logical Databases:

FTI_TR_DEALS CFM - Transactions

FTI_TR_PL_CF CFM - Revenue Forecast

FTI_TR_PERIODS Foreign Exchange Risk Reporting

FTI_TR_CASH_FLOWS CFM - Maturity (Payment View)

FTI_TR_POSITIONS CFM - Positions

Best regards,

Lisa

[former_member210794 · Accepted solution]

Thank u very much.....

I'm new to TRM please keep helping me with your advice...

Abhishek

[Former Member · Accepted solution]

Hi,

We have used product category 540 - Cash Flow Transaction to map Letter of Credit entries. This is working perfectly for us. The data entered for such transactions gets updated in the standard SAP Tables - VTBFHA, VTBFHAPO and VTBFHAZU.

Warm regards,

Akhil

[Former Member]

Hi

Use Tx. FTR_SHOW it will give you all tables related to any transaction

Warm regards,

[danilosouza_meli]

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

FDC1 Cash Management Shadow table

[former_member210794]

Nice Thanks you all....And specially Mr.Alaa...Ur profile pic is very cute ..mail me

[Former Member]

Hi,

The standard tables in use for TR-TM are VTBFHA, VTBFHAPO & VTBFHAZU which are the header, transactional data table.  All the transactions irrespective of the product type will update the table.

Meanwhile Letter of Credit in some cases is not a standard mapping of a product type but rather a customized combination of product type?  How have your LC been configured? Is it a mapping done through facilities in which case you might have to look at a different table.  Meanwhile also let us know for what purpose you want the table so that we might be able to point you better.

Regards,

Ravi

[former_member210794]

Thank you very Much....

Actually I got a development request from a client ,so i have to give fields and tables to ABAP person.

Moreover,I'm new to this module, since I'm a FI certified consultant.

Please guide me on this module.

Best regards

Abhishek