Solution : https://service.sap.com/sap/support/notes/839381 (SAP Service marketplace login required)
Summary :
For calculating the effective annual interest of financial transactions in SAP, the SAPLFV90 (FV90) is utilized. Notably, if alignment with Excel's XIRR function is required, the 'EU-act/365' effective interest method should be implemented using the 'EFFEKTIVZINS_BERECHNEN' function module. Parameters such as I_SEFFMETH dictate the interest calculation method, while I_RUNIT determines rounding precision. Payments are structured in the IEFFZ table where fields like DDISPO (due date) and BCWHR (amount) are crucial. The result, including the effective annual interest rate, can be fetched from E_EFFZINS, and additional detailed figures are retrievable via the 'VERGLEICHSKONTO_AUSGEBEN_TAB' function module for control accounts.
Key words :
payment day activity amount balance days interest-------------------------------------------------------------01, 00the abbreviation 'int capital' means interest capitalization, i_seffmeth = 6 => effective interest method 'eu-act/365'i_runit = 0 =>, effective interest method 'eu-act/365', terms effective interest rate record, export parameterthe effective annual interest, calculated effective interest rate record, effective interest rate record, effective interest rate method, effective interest rate calculation
Related Notes :
| 840221 | Changing the 'VERGLEICHSKONTO_AUSGEBEN_TAB' function module |
| 316142 | Documentation for effective interest rate calculation |
| 191194 | Effective interest methods EU-act/365 and EU-30,42/365 |