Skip to Content
S M

Interest Rate Instrument ; Interest Calculation ; Key Date

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Jul 12, 2017 at 09:36 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 13, 2017 at 07:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 12, 2017 at 10:42 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 18, 2017 at 04:26 PM

    HI,

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

    Regards,

    Nikhil

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 21, 2017 at 07:04 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 01, 2017 at 04:12 PM

    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

    Add comment
    10|10000 characters needed characters exceeded