Difference between report TJ12 - TPM13

[Former Member]

Could somebody please explain the difference between the Treasury report TJ12 and the TPM13 report.

It seems thatthe TJ12 report only takes into account the flow types, while the TPM13 report takes into account the update types...

I would like to know why these reports are used. Purpose of report, etc...

Thanx,

Stef

[Former Member · Accepted solution]

Hi,

It is not just flow type, update type difference.

TJ12 shows the transaction cash flows i.e. it will show all the flows related to a specific transaction which will be reflected in the cash flow.

TPM13 is used to check the flows at the subledger level. It will show all the flows for at the subledger level or at the treasury level. Certain flows will not be posted in FI but will have a posting in treasury. These flows will be seen in TPM13. Flows like gain/loss or dividend which are not at the transaction level but at the sub ledger level can be checked in this transaction.

Regards,

Ravi

[Former Member · Accepted solution]

Hi Ravi,

Thak you very much for quick response. It helped a lot in understanding the report.

Just one more question : Why is the TPM13 report called a position flow list and can we find it under SAP pathway Reports--> Position Trend. what does it has to do with positions?

In fact the report that I am looking for is a report that gives all flows for all transactions that have been outstanding in a certain period (E.g. January).

[Former Member · Accepted solution]

Hi,

TPM13 is a report to check your positions. Take the case of securities. Position is the number of stocks and its value you hold. Since this report gives an overview of your total position it is classified under that.

About your requirement, could you be more specific in the sense in which area you want like for money market or securities etc. Also by outstanding you mean the total amount due for a particualr partner for that month or total amount which your company needs to pay for that month? If that is the case, then how will you include any investments made in that month or any loans taken in that month?

Regards,

Ravi

[Former Member · Accepted solution]

Sorry I have been away for a couple of days.

The exact functionality = I would like to have a report that gives all flows of all outstandings (loans, investments,...) that happen between a certain period.

E.g. Suppose I have two loans:

1 Loan 1 = start date 01 January --> end date 01 May

2 Loan 2 = start date 01 March --> end date 01 april

If I set my period for report from the 01 march till the 31 march, the report needs to select all the outstanding of that period and it needs to display all flows for those outstanding loans, also the flows that happen before and after the selected period of the 01 march till the 01 april.

With a normal outstanding report I get only the outstabnding amounts, with a flow report (TJ12 or TPM13) it will only select the flows that happen between the 01 march and the 01 april. But I need all flows so also investment amount on the 01 january and repayment on the 01 May

Any ideas for a report that can do this?

tx,

Stef

[former_member583013 · Accepted solution]

Hi Stef,

If you run the TPM13, with the product types from 30xx to 36xx, does it serve your purpose? if you dont give any dates, it shall give you all the flows for all the transactions for loans.

I am not sure if i answered your question

Best regards!

Sandip

[Former Member · Accepted solution]

Hello Sansip,

Thanx for answer, but it doesn't do the trick..

If I do that I get all the flows of all loans that have been entered in the system, instead I would like to see only the flows of all outstanding in a certain period.

I would like to see for example all flows of all outstandings in that period (eg month march). So it needs to check for outstandings in the month March and when he has found them he needs to display all flows just for the transactions that where outstanding in the month march.So all flows from 01/01/1900 ---> 01/01/9999.

A solution/work around is I think to run fist a outstanding report for the month March (already difficult because they normally work on a key date, so just 1 date). Then selecting all the financial transactions of that period and copy paste those transactions in a normal flow report (e.g. TPM13) without entering any dates. But this "solution" they didn"t like.

Kind regards,

Stef

[former_member583013 · Accepted solution]

Hi Stef,

Can you tell me the outstanding report name??? Maybe we can display only scheduled flows for those transactions.. I will check it...

Regards!

Sandip

[Former Member · Accepted solution]

Sandip,

I build a query (based on alogical database) for the outstanding amounts that they would like to have for this, so I would like to integrate the "new" report in that query.

But an outstanding report that they use here = TPM12

kind regards,

Stef

[Former Member · Accepted solution]

Try TJ04. This will give you the payment schedule for a particular day or a range. For e.g. if you run TJ04 for today, it will give you the total inflows and outflows for today from all the Treasury transactions.

Our users use this to find out 'Net inflow/outflow' for the day from treasury. They also use it to confirm that all the transactions are reflected in the bank statement - compare this report with FEBAN transaction to confirm that the bank has correctly debited/credited their account for all the treasury related flows.

Kalyan

[Former Member · Accepted solution]

Hello kalyan,

Thank you very much for respons.

Our users also like this report a lot, but it doesn't give the data that they are looking for..

They use it mostly for planning the work that needs to be done for the upcomming week(s)

kind regards,

Stef

[former_member583013 · Accepted solution]

Hi,

I find that the flows selected in Payment Schedule TJ04 ,are different from flows selected in tpm13.

Can you tell me why are they different?

Best regards!

Sandip

[former_member583013 · Accepted solution]

Hi Stef,

As i understand, you might have to create a new report for outstanding loan amounts. Loans 36a etc might not have good reports in TRM space. It can have LDB's with more advanced characterstics, like outstanding amt etc in Loans Module.

Regards!

Sandip

[Former Member · Accepted solution]

Sansip,

I think this is becaue tj04 takes into account flow types and tpm13 also update types

kind regards,

Stef

[former_member583013 · Accepted solution]

Hi stef,

I dont think so... Because it that case, it TJ04, would have been a subset of TPM13. But it gives altogether different selected flows. For me, TJ04 gave 4 results for payment for 25th aug, but tpm13 gave nothing.

Regards!

Sandip

[Former Member · Accepted solution]

I do not know the reason for that

I tried it here for a date and I got exactly the same number of transactions for both transactions. For the tpm13 I also had flows that were related to update types, for tj12 i only had flows that were related to flow types, just as how i expected it

kind regards,

Stef

[former_member583013 · Accepted solution]

Hi Stef,

Ok.. so lets think in the LDB direction, as tpm13 or tj04 is not helpful. You must have created an infoset on an LDB, before writing the query on that infoset. Can you tell me the LDb name and the fields selected in the query?? Maybe we can find some helpful field in the LDB for Loans positions.

Best regards!

Sandip

[Former Member · Accepted solution]

Sandip,

I already tried that but the LDB can not do that ( I think)

I use FTI_TR_POSITIONS and FTI_TR_PL_CF

kr,

Stef

[former_member583013 · Accepted solution]

Hi Stef,

I guessed you are using those and will not have the info. Try using FTI_LO_PERIODS or FTI_LO_POSITIONS. I think that will have some additional fields for the loans which will help.

Best regards!

Sandip