Purpose
You use this report to create an interest on arrears debit for items ina customer account that have not yet been paid or that were paid toolate. You can also create an interest credit for items paid before thedue date. You can post the interest due in Accounting.
In addition, you can create and print letters to customers, as well asan overview of items that have been subject to interest.
This report replaces the standardCalculation of Interest on Arrears forcustomers (report RFDUZI00).

Differences to Report RFDUZI00
The new report contains the following changes and enhancements:

• The selection screen has been simplified; several of the selection
criteria have been transferred to Customizing for the interestindicator.

• Using report RFINTITUSERXT,
you can insert additional selection criteriain the interest calculation. You can also use this report to defineadditional fields to be displayed on the form.

• The form is now created with Smart Forms (previously: SAPscript).


• The interest posting is no longer triggered by running a batch input
session; the report posts the interest documents directly via theAccounting interface. This means that the document number for theinterest posting can also be displayed on the form.

• The results of the interest calculation are created in detail on the
database (tables INTITHE and INTITIT). You have the following options:
You can use report RFINTITSHOWto view the interest runs that have beencarried out.
You can print interest runs.
You can reverse or report individual interest postings or completeinterest runs.

• If you start the program as test run instead of an update run, an
overview of the items on which interest is to be calculated appears inthe ABAP List Viewer (ALV).
To display the items on which no interest is to be calculated, deletethe ALV filter.
Double-click on the individual items to view the detailed information.

• You can also calculate interest on items from assigned vendors.


• Branch-head office relationships are taken into account.


• Calculation using interest calculation numerators is no longer
supported.

Preconditions


• You have defined an interest indicator for the interest calculation type
P (item interest calculation) and made all other relevantspecifications.
For more information, see the Implementation Guide for FinancialAccounting under Accounts Receivable and Accounts Payable ->BusinessTransactions -> Interest Calculation -> Interest Calculation GlobalSettings -> Define Interest CalculationTypes.
IF &DEVICE& = 'SCREEN'
Proceed
ENDIF

• In Customizing for the interest indicator you have made the required
specifications, for example, whether the interest is to be posted andwhether forms are to be printed.
For more information, see the Implementation Guide for FinancialAccounting under Accounts Receivable and Accounts Payable ->BusinessTransactions -> Interest Calculation -> Interest Calculation GlobalSettings -> Prepare Item InterestCalculation.

• You have defined the required interest indicator in the master records
of the customers concerned.

• You have defined the conditions for your interest indicators.

For more information, see the Implementation Guide for FinancialAccounting under Accounts Receivable and Accounts Payable ->BusinessTransactions -> Interest Calculation -> Interest Calculation ->Define Time-Dependent Conditions.Note that thefield Amount From is not used in the item interest calculation.
IF &DEVICE& = 'SCREEN'
Proceed
ENDIF

• To send a letter, you have to create a Smart Form to be used for the
interest calculation and then define it in the system.
Define your own forms if necessary.
You can use the standard form F_INTITAR_SF as copy template.
Define the names of the forms for your interest indicators.
For more information, see the Implementation Guide for FinancialAccounting under Accounts Receivable and Accounts Payable ->BusinessTransactions -> Interest Calculation -> Print ->Define Forms for Interest Indicators.
IF &DEVICE& = 'SCREEN'
Proceed
ENDIF

• You have defined the account determination for posting the interest and
defined the document type to be used. You make the relevant settings inthe Implementation Guide for Financial Accounting under AccountsReceivable and Accounts Payable -> Business Transactions -> InterestCalculation Interest Posting ->Prepare Calculation of Interest onArrears for Customers.
IF &DEVICE& = 'SCREEN'
Funktion ausführen
ENDIF
To make the following entries, in the menu choose Goto and then:
Control
The account determination takes place via theposting interface of theapplication 0002 (calculation of interest on arrears).
Define which account determination keys are used. For the accountdetermination key Business Transaction,define 1000 (interestrevenue) and 2000 (interest expense). The other accountdeterminationkeys are optional.
Accounts
Enter the complete G/L account assignment (interest revenue or interestexpense). For the debit or credit posting to the customer account, youonly need the posting key. If you make an entry in the fieldG/L Accountin the account assignment for customers, this results in a posting withthe account entered as (alternative) reconciliation account.
Document Type
Define the document type for posting the interest.
Note that the interest cannot be entered as a held item.

Process Flow and Specifications for the Interest Calculation
You select the items on which interest is to be calculated using thesettings for the interest indicator.
In addition, general selections apply. Only the following itemsare considered:


• Items that have been posted to a customer account whose master record
contains an interest calculation indicator

• Items that are not blocked for interest calculation


• Items that do not contain a cash discount amount


• Items whose posting date is before or the same as the upper limit of the
selection period
The following settings for the interest indicator are decisivefor the item selection.
For more information, see the Implementation Guide for FinancialAccounting under Accounts Receivable and Accounts Payable ->BusinessTransactions -> Interest Calculation -> Interest Calculation GlobalSettings -> Prepare ItemInterest Calculation.

• Open Items

Interest is calculated on items that are currently open. Interest iscalculated on these items up to the upper limit of the calculationperiod.
Interest is not calculated on open items that are due after the upperlimit of the calculation period. (Exception: See selection criterion:Calculate Interest on Bill ofExchange in Advance)

• All Cleared Items

Interest is calculated on all cleared items whose clearing date (postingdate of clearing) is before or equal to the upper limit of thecalculation period. Interest is calculated on items whose clearing dateis after the upper limit of the calculation period if interest is alsocalculated on open items.
Items whose clearing date is before or equal to the key date for thelast interest calculation as entered in the account master record (upperlimit of the last interest calculation) are not selected as they havealready been completely subject to interest.
See also the selection criterion:Cleared Documents From.

• Items Cleared by Payments

Only clearing transactions that contain a payment are considered. Thismeans that you do not have to consider clearing transactions thatcontain only invoices, credit memos, and offsetting items.

• No Cleared Items

No cleared items are selected, regardless of when the clearing date is.

• Reference Date

The basis for calculating interest on a receivable is the time from thedue date for net payment to clearing.
As an alternative to the due date for net payment, in the fieldReference Date, you can also select the document date,the posting date,or the baseline date for payment. Interest is calculated on the items upto the selected reference date for the clearing document. If theclearing document has no items, interest is calculated up to theclearing date (posting date for clearing). Interest is calculated onopen items up to the upper limit of the calculation period.
If, in the report itself, in the screen area Performance,you select theindicator Payment with Bill of Exchange Possibleand accordingly,Calculate Interest on Bill of Exchange in Advance,special treatment isactivated for bills of exchange.

• Always Calculate Interest from Due Date for Net Payment

If you select this indicator, for each new interest run, interest iscalculated on all items from the selected reference date. Otherwise,interest is calculated on items that have already been subject tointerest from the date to which they were subject to interest in thelast interest run. Therefore, setting this indicator means that interestis calculated on items more than once for the same period. If interestis not calculated on any open items, the indicator has no effect. Thisis because items that were already cleared by the last interest run arenot subject to interest again.

• Transfer Days

The transfer days are the days that a payment potentially requires toreach the payee from the payer (for example, processing time at the bankfor the payment transfer). The transfer days are deducted from thereference date of incoming payments. The system cannot access the valuedate stored in the bank line of an incoming payment for performancereasons.
Transfer days only apply to incoming payments.

• Factory Calendar ID

The factory calendar defines which days are deemed to be non-workingdays. If the due date for a receivable is a non-working day, the duedate is deemed to be the next working day. If an incoming payment isreceived on a non-working day as a result of the transfer days, theincoming payment is deemed to be received on the previous working day.

• Tolerance Days

If an item is overdue, and interest is to be calculated, the number ofdays in arrears is compared with the number of tolerance days. If thenumber of days in arrears is less than or equal to the number oftolerance days, no interest is calculated on the item.

• Also Calculate Interest on Items Paid before the Due Date

If you select this indicator, interest is also calculated for items paidbefore the due date if the items were paid without cash discount beinggranted. Credit interest is calculated for debit items, and debitinterest is calculated for credit items.
Interest is calculated on partial payments made and down paymentclearing carried out before the invoice is due from the reference dateif this field is selected. Otherwise, interest is only calculated fromthe due date of the invoice.

• Only Calculate Interest on Debit Items

Setting this indicator has the effect that interest is not calculated oncredit items.
If the field is not selected, the credit item is treated like a debititem; interest is calculated with the same interest rate. Reason: If thecredit memo is not cleared against the invoice immediately, both theinvoice and the credit memo are #overdue# and cancel each other out forinterest purposes.
If you require a different logic to decide whether debit or creditinterest rates are to be applied, you can implement this yourself in theBAdI FI_INT_CUS01 in the method GET_INT_SIGN.

Calculation of Days for which Interest Is to be Calculated
If an item qualifies for the interest calculation according to thecriteria described above, then the system first calculates the days inarrears depending on the calendar type defined for the interest indic
ator. If the calendar type is Gregorian or French, the exact number ofdays is calculated. If you have selected the bank calendar or theJapanese calendar, the number of days is calculated according to thebank calendar that is standard in Germany. In the bank calendar, a monthhas 30 days.
Depending on the calendar type, the year has a different number of days:For the bank calendar and French calendar the assumption is 360 days;for the Gregorian and Japanese calendar, the exact number of days iscalculated.

Interest Rate Definition and Determination
The interest is usually calculated with the reference interest ratesdefined in the system. You define the interest rates in the key fieldsInterest Reference, Currency, and Date(from which the interest rate isto be valid).
The system determines the interest rates valid for a specific item viaconditions. You define these conditions in the system in the key fieldsInterest Indicator, Currency, and Date(from which the condition isvalid) and a sequential number for the interest reference valid.
The final interest rate is determined via a function module (as standardthe function modules DEBIT_INT_RATE_DETERMINE orCREDIT_INT_RATE_DETERMINE). The supplement or deduction specified forthe interest indicator is added (or subtracted, respectively) to thereference interest.
If the interest rates are to be determined using other function modules,you can assign these in transaction OB85. Alternatively, you can use theBAdI INT_CHANGE_ITEMS to assign interest rates to the item. The BAdIsare explained below.

Calculation of Interest
In the standard, interest is calculated on a linear basis. If you wantto use a different formula, you can use method INT_FORMULA of the BAdIFI_INT_CUS01.

Amount Limit and No Interest Credit
In order to decide whether an interest settlement is to be created, theinterest is calculated for all items. If the interest amount determinedfor each interest letter is less than the amount limit defined for theinterest indicator, no interest debit is created.
If a credit interest amount that is at least equal to the amount limitarises, no interest settlement is created as long as the indicatorNoInterest Credit is selected.

Posting the Interest
The account determination is explained above. In the interest indicator,you can also define the terms of payment and the tax on sales/purchasescode to be used to post the interest.
If you have selected the indicatorPosting with Invoice Reference, areference to the items on which interest has been calculated is enteredin all interest postings. The invoice reference type here is F.In thecalculation of interest on items that themselves refer to an invoice(entry in field REBZG), the interest documents refer to the originalinvoice.
If you want these interest documents to have certain characteristics ofthe documents on which interest has been calculated, enter thecorresponding characteristics in theTransfer Content fields. If thecharacteristics that you require are not offered, you can enhance thedisplay structure accordingly using the reportEnhancement of the ItemInterest Calculation (RFINTITUSEREXT).

Output
You can create a letter with a list of items for each customer, currency
, and one other grouping criterion. If you start the report as a testrun, you see an overview of all the items on which interest has beencalculated. If errors occur, you see an error log.

Overview of Items
If you select the indicator Test Run, then an overview ofthe items onwhich interest is to be calculated appears. The SAP standard ALV variantis configured such that items for which no interest is due are notdisplayed. You can double-click on the individual items to see thedetailed information for the interest calculation for the individualitems.
You can also post and print from the overview list.

Error Log
If errors occurred during the processing, the report issues an errorlog. The following errors can occur:


• The system does not find the form in the language of the customer.
Instead, the form language used is specified.

• The interest rate determination could not be carried out because the
interest rate definition was incorrect.

• Interest indicator is not defined.

Form Selection
You can issue a letter for your customers that contains the following:


• The text for the letter


• Item information at a level of detail that you can select


• Interest rate overview (optional)


• An interest amount overview sorted by interest rates

If you do not specify a form name for the interest calculation, the formdefined for the interest indicator is used. The language of the form isthe language of the recipient. If the form does not exist in thislanguage, the language in which the form was created is used (usuallythe language of the company code).
The letters for the customers are sorted by the following criteria:

• Company code


• Account number


• Account type


• Grouping criteria


• Currency

The items in a letter are transferred to the form as a table and you cansort them there according to your requirements.
If you want to issue separate letters for different special generalledger transactions, enter the special general ledger transaction(BSEG-UMSKZ) as grouping criterion with the BAdI INT_CHANGE_ITEMS.

Miscellaneous

Performance
You can influence the program performance during the item selection.
At the start of the interest calculation, the report analyzes thedisplay structure:


• If entries can be made in all of the fields from tables KNA1, KNB1, and
BSID here, then the system only reads the logical database up to theBSID nodes.

• If the fields of the display structure are filled from table BKPF and
not from these tables, then the system reads up to this node.

• If the fields are filled from BSEG and not from KNA1, KNB1, BSID, and
BKPF, the system reads up to this node of the logical database.
As standard, the system reads up to node BKPF, since the fields STBLG,WWERT, and BKTXT only exist in BKPF, and not in table BSID. However, ifyou add these fields to BSID in your system, BKPF does not have to beread. This improves the performance of the reports.
Accordingly, customer enhancements to the display or calculationstructure for the interest calculation can also have a negative effecton the performance of the report if the fields added, for example, fromtable BSEG have to be filled.

User-Specific Adjustments
Using the report Enhancement to Item Interest Calculation(RFINTITUSEREXT), you can adjust theinterest calculation to meet yourrequirements.
For further customer adjustments, you can use the following methods inthe BAdI FI_INT_CUS01:


• INT_SEL_MOD

With this method you can influence the selection criteria that thelogical database DDF (or KDF for vendor items) uses to retrieve itemsfrom the database.

• INT_ADD_ITEMS

This method enables you to control whether items that have already beenselected can be removed, or whether additional items can be added.

• INT_CHANGE_ITEMS

You can use this method to modify items before the FI function moduleFI_INTERESTS_ON_ITEMS calculates the interest for them. With theexception of the days in arrears (INT_DAYS), you can have default valuesfor all fields in the interest calculation.

• GET_INT_SIGN

You can use this method to control whether a debit or credit interestrate is used for the interest calculation.

• INT_FORMULA

With this method you can define a different formula for the interestcalculation (for example, non-linear interest calculation).

• INT_MODIFY_ITEMS

This method enables you to revise the interest items using a standardSAP interest calculation.

• INT_GROUP

After the calculation of the interest per item, the SAP standard reportgroups the different items according to the rules defined in Customizingand thereby prepares the creation of the form and the posting of theinterest. You can use this method to influence the grouping.

• INT_POST

In function module FI_INTIT_POST, the SAP standard report first preparesthe tables for posting the interest and then uses the tables to call theAccounting interface. You can use this method to either modify thetables used for posting (CT_ACCHD, CT_ACCIT, CT_ ACCCR, CT_ACCWT), or tocarry out the posting without using the Accounting interface.
If you do not want to post using the Accounting interface, you have toset the parameter CD_POST_STATUS to a value other than SPACE, and filltable CT_ACCPOSNR.

• INT_PRINT_OPTION

You can use this method, for example, to modify the options for sendingthe form.

• INT_SHOW_BUTTONS and INT_LIST_01 to INT_LIST_03

If you start the report as a test run, all the interest items are firstdisplayed in an ALV list. Programming the methods INT_LIST_01/02/03enables you to run additional actions from this list. If you use one ofthese methods, an additional pushbutton appears in the menu bar. You usemethod INT_SHOW_BUTTONS to control whether this button is to be activeor inactive.

Reporting, Reversal, and Repeat Print
You can use the report Interest Run Display(RFINTITSHOW) to displayinterest runs that you have performed, to reverse them, or to printforms again.

Deleting Interest Information
Using report RFINTITDEL, you can delete entries from the interest tablesINTITHE, INTITIT, and INTITPF. Note the following:


• You can only delete entries from the interest tables for items for
which interest has already been completely calculated. ProgramRFINTITDEL checks this automatically.

• For items on which interest has been calculated in full, the program
deletes the detailed information about the interest calculation fromtable INTITIT without checking the entries on the selection screen. Foran item whose entry in table INTITIT has been deleted, you can no longertrack the interest history or determine the amount of interest that wasdue on this item.

• An entry in table INTITPF that contains the information about the forms
created is retained until all relevant INTITIT entries have beendeleted. Program RFINTITDEL checks this automatically.

• Even after you have deleted tables INTITIT and INTITPF for a specific
item, table INTITHE still contains the information that interest hasbeen calculated on this item in full. This information is sufficient forany future calculation of interest by program RFINTITAR. As long as theentry remains in table INTITHE, duplicate calculation of interest on theitem is not possible.

• To delete entries from table INTITHE, you have to set the indicator
Delete from All Tables, and the items to be deleted must have beenarchived.

• Note the following: As soon as you have archived an item and deleted all
relevant interest information with report RFINTITDEL, in principle,interest can be calculated on this item again if you reimport it to thedatabase from the archive. The interest program RFINTITAR cannotrecognize this type of duplicate interest calculation; the user isresponsible for ensuring that this situation cannot occur.

Migration and Parallel Use

Forms
The new interest calculation (RFINTITAR) works with Smart Forms.
Copy the standard form F_INTITAR_SF, adjust it to meet your requirements
, and define it in Customizing.

Customizing
Both the old (RFDUZI00) and new (RFINTITAR) interest calculations accessthe same Customizing tables.
If you have been using report RFDUZI00 to calculate interest, you nowhave to make the entries for the interest indicator in the following IMGactivity: Implementation Guide for Financial Accounting underAccountsReceivable and Accounts Payable -> Business Transactions -> InterestCalculation -> Interest Calculation Global Settings ->
Prepare Item Interest Calculation.

Changeover to the New Interest Calculation (Change from RFDUZI00 toRFINTITAR)
To change over from the old Calculation of Interest on Arrears(RFDUZI00) to the new Item Interest Calculation (RFITITAR), inthe last calculation of interest on arrears run with RFDUZI00, selectthe indicator Prepare Migration. You can then run the nextinterest run with the Item Interest Calculation (RFINTITAR)with no problems.

Parallel Processing of RFINTITAR and RFDUZI00
You can run both interest calculation reports RFDUZI00 and RFINTITAR inparallel in different company codes. If you do not define your forms inCustomizing, or the forms for both reports have the same name, you caneven use both reports in parallel within one company code.
Note that SAP does not guarantee that you can calculate interestfor customers who you have subjected to interest using report RFINTITARwith report RFDUZI00 with no problems. Under no circumstances can youprocess completed interest runs further, since RFDUZI00 does notsave interest runs.