Skip to Content
0

Interest Rate Instrument ; Interest Calculation ; Key Date

Jul 11, 2017 at 07:21 AM

110

avatar image
S M

Dear SAP Experts,

We are having requirement , in Our Client side, they have Given Loan to Business Partner , long year Back , in which having, Start date of loan , No End Date , we are taking assumption 31.12.9999, having interest rate ,say 4 percent.

Suppose I want to check the How much total interest is accrued on any Key date?say 31.12. 2017

What is T.Code or Report to check the Total Interest as on any Key Date

Reagrds

Sourabh

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Jain varghese Jul 12, 2017 at 09:36 AM
0

HI,

We might have option in many way. I tried with TPM12 as below. Not sure whether we have exact report which will fulfill your requirement.


tpm12.png (77.8 kB)
Share
10 |10000 characters needed characters left characters exceeded
Jain varghese Jul 13, 2017 at 07:34 AM
0

Hi,

We don't have any such option which will fulfill your requirement. Please user TPM20 & TPM12 & TPM13 and build logic for your requirement.

TPM20


tpm20.png (21.4 kB)
Share
10 |10000 characters needed characters left characters exceeded
S M Jul 12, 2017 at 10:42 AM
0

Thanks Jain For your Reply ,

I tried TPM12 , but it is not fulfilling the requirement , I was checking T.Code TPM44 . I enter Key date , system is calculating correct total interest accured upto that key date , But is in Journal entries Form , My client I asking any Report , they are not willing to go TPM44.

Can we do any workaround in configuration partTPM44 itself Treasury Accrual and Deferral ?

Regards

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member
Jul 18, 2017 at 04:26 PM
0

HI,

Check Report - S_ALN_01001154. it gives the simulated Values for Accrual / Valuation / Amortization for a key date.

Regards,

Nikhil

Share
10 |10000 characters needed characters left characters exceeded
S M Jul 21, 2017 at 07:04 AM
0

Dear Nikhil,

Thanks for Reply , But I was T.code

Check Report - S_ALN_01001154. it gives the simulated Values for Accrual / Valuation / Amortization for a key date..

But it Showing error cusersa672206desktopcapture.png

Regards

Sourabh M.


Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member
Aug 01, 2017 at 04:12 PM
0

HI,

Follow these steps -

Execute TCode - SQ01

Select User group - /SAPQUERY/T1 and Select Query CFM_POS_11 from the list and on the top menu , QUERY > More Functions> Adjust; QUERY > More Functions> Generate Program

Go to SE38 > RSVARDOC_610, execute

S_REPORT = AQZZ/SAPQUERY/T1CFM_POS_11====

S_VARI = SAP&STANDARD

SYSVAR = X

Execute. Now try the report again, it should work.

Regards,

Nikhil

Share
10 |10000 characters needed characters left characters exceeded