cancel
Showing results for 
Search instead for 
Did you mean: 

what is the table of future cash flows (coupan flows).

Former Member
0 Kudos

Hi experts,

Can you please tell me what is the table of future cash flows.

I am using securities module in transaction manger.

I am using t.code- TS01 for creating a deal transaction. it is generating a future cash flows ion case of bonds.

but not able to figure out in which table it is storing these flows. TPM 13 is a transaction code to see cash flows.

I need this table to devolope some BI reports

Please help.

Regards

Gaurav Gupta

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Hi Guarav,

you can use logical databases like FTI_TR_PERIODS to create own reporting based on SAP queries, but they don't contain any data.

The cash flow data you see in TPM13 is from the TRL* tables and views, eg. TRLV_TRANS_POS or TRLV_FLOW. This data is valuation area dependant. To see transaction data you should check TRD* tables, for security account class data you better use TRS*.

Nevertheless, for BI reporting SAP offers some extractors with which you can get data from Treasury and furnish it to BI. For example, with 0CFM_INIT_POSITIONS you set initial position (like TPM12). With 0CFM_DELTA_POSITIONS you can then provide positions for further key dates and create BI reports that valuate delta flows. The DataSource 0CFM_O01 contains information about all position relevant flows, 0FM_O02 about reversed flows.

Extractor 0CFM_DELTA_POSITIONS and other 0CFM* extractors are generally based on logical databases, so you can e.g. create a query based on FTI_TR_PERIODS to check results that would be extracted to BI using 0CFM_DELTA_POSITIONS.

BR, Tomislav

Former Member
0 Kudos

Hi,

The cash flows are generated automatically and its a dynamic cash flow you see. This means when ever you modify the details in actual transaction with TS02 the future cash flows are updated automatically.

System stores all the flows related information in Logical Data Base (LDB) - FTI_TR_PERIODS. This LDB covers overall flow details of entire treasury instruments.

You can make use of this LDB for BI Reporting, LDB can be saw using Tcode - SE36.

Regards

Prasad AV