SAP Treasury End User Training Part 1

Table of Contents

SAP Treasury & Risk Management-End User Training

 

Money Market Instruments

 

Interest Rate Instruments- End User Training

 

Interest Rate Instruments Functionality

  • An interest rate instrument is a money market transaction with additional structural characteristics, such as variable interest and installment repayment.

 

End to End Business Process for Interest Rate Instrument

Interest Rate InstrumentsSAP Transaction Codes
Create Interest Rate InstrumentFTR_CREATE
Settle Interest Rate InstrumentFTR_EDIT
Post Inception FlowsTBB1
Display Payment RequestF8BT
Pay Money to Bank/ Fund transfer to BankF111
Post Month End Accrual EntriesTPM44
Update Reference Interest RateJBIRM
Run automatic Reference updateTJ05
Repayment on Loan maturityTBB1
FI Posting JournalTPM20

 

Create Interest Rate Instrument

Transaction Code: FTR_Create

A screenshot of a computer Description automatically generated

A screenshot of a computer Description automatically generated

  • Reference Interest Rate: When calculating the variable interest, the reference interest rate is normally a money market interest rate.
  • Frequency: It specifies interest Payment frequency – End of Period, Monthly, quarterly etc.

A screenshot of a computer Description automatically generated

A screenshot of a financial account Description automatically generated

A screenshot of a computer Description automatically generated

Interest rate instrument 5000000000104 in company code 1000 is created.

 

Settle Interest Rate Instruments

Transaction Code: FTR_EDIT

Here we review the above transaction. This ensures dual verification of transaction. If everything is correct it is saved, which results in settlement.

A screenshot of a computer Description automatically generated

 

Post Inception Flows

Transaction Code: TBB1

This will post FI inception documents- If Investment, Investment account debit and Bank Clearing Account credited. This explained in detail in the course SAP Treasury and Risk Management

A screenshot of a computer Description automatically generated

A screenshot of a computer Description automatically generated

Accounting Document

A screenshot of a computer Description automatically generated

 

Post Month End Interest Accrual entries.

Here we will post the accrued-on Interest rate instruments. We will use a reset method which will post interest on the last day of the month and then reverse it on 1st day of next month. Total interest from inception to maturity will be posted to the Interest account on interest rate instrument maturity.

Transaction code: TPM44

A screenshot of a computer screen Description automatically generated

A screenshot of a computer Description automatically generated

A screenshot of a computer Description automatically generated

Accrued Interest Posted on 29.02.2024 as shown below.

A screenshot of a computer Description automatically generated

It is reversed om 01.03.2024 as shown below.

A screenshot of a computer Description automatically generated

Please refer to below link for explanation: SAP Treasury & Risk Management-Introduction

SAP Treasury and Risk Management Course

 

Variable Reference Interest Rate Update

Variable Reference Interest Rate are received from Bloomberg or any other 3rd party provider. These are updated in system automatically thorough interface with Bloomberg or these 3rd party providers. In our case we will manually update variable reference interest rate

Transaction Code: JBIRM

Current Interest Rate is 2.18%

A screenshot of a computer Description automatically generated

A screenshot of a computer Description automatically generated

Reference Interest Rate is EUREUR01YM

WE entered Rate 10% from 01.03.2024.

A screenshot of a computer Description automatically generated

Now we run Transaction code TJ05 and then check the Interest Payments for this deal in transaction code FTR_EDIT as below. We can Reference Interest Rate updated to 10% in the contract. Further Interest Payments recalculated based on new Reference Interest rate

A screenshot of a computer Description automatically generated

 

Repayment on Term Deposit / Interest Rate Instrument maturity

Transaction Code: TBB1

Maturity date is 31.05.2024. So, we will run Transaction code TBB1 on 30.05.2024. This will post FI entries on loan maturity.

A screenshot of a computer Description automatically generated

A screenshot of a computer Description automatically generated

Investment Repayment FI document

A screenshot of a computer Description automatically generated

Full Interest received on investment FI document.

A screenshot of a computer Description automatically generated

This complete end to end business process and training on Interest rate instruments with variable reference interest rate. Same process for fix interest rate except rate adjustment steps (JBIRM, TJ05) not applicable

Please take course SAP Treasury & Risk Management for videos and details on Treasury business process and configuration

Facebook
Twitter
LinkedIn

Leave a Comment

Your email address will not be published. Required fields are marked *

error: Content is protected !!